Actuarial Outpost
 
Go Back   Actuarial Outpost > Search Forums
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions



Showing results 1 to 25 of 141
Search took 0.02 seconds.
Search: Posts Made By: mark007
Forum: Finance - Investments 10-27-2008, 03:02 PM
Replies: 33
Views: 7,435
Posted By mark007
Yes. Going back to the days of actuarial...

Yes. Going back to the days of actuarial smoothing though the impact would come through over time so any short term blips would be removed. I'm not sure I'd advocate going back to that and don't get...
Forum: Finance - Investments 10-27-2008, 11:17 AM
Replies: 33
Views: 7,435
Posted By mark007
Not quite true as you're forgetting the...

Not quite true as you're forgetting the dividends. The sentiment clearly remains though. You are of course looking at a relatively small undiversified portfolio.



You're missing the point a...
Forum: Finance - Investments 10-23-2008, 06:11 PM
Replies: 33
Views: 7,435
Posted By mark007
Although I agree whole heartedly with the central...

Although I agree whole heartedly with the central issue put forward in the letter regarding ASOPs i.e. that they restrict new methods entering mainstream practice, I still cannot agree with the...
Forum: Software & Technology 02-21-2008, 03:45 PM
Replies: 36
Views: 4,748
Posted By mark007
IFERROR exists in Excel 2007. :)

IFERROR exists in Excel 2007.

:)
Forum: Pension - Social Security 01-03-2008, 08:07 PM
Replies: 45
Views: 15,326
Posted By mark007
:iatp:

:iatp:
Forum: Software & Technology 10-11-2007, 03:27 PM
Replies: 41
Views: 5,127
Posted By mark007
Well it works in Excel 2003 and below! I...

Well it works in Excel 2003 and below!

I have my own and use my own. However, I routinely check work that makes use of datedif and there are hundreds of s/s's set up with datedif on them. This...
Forum: Software & Technology 10-10-2007, 06:41 PM
Replies: 41
Views: 5,127
Posted By mark007
The fix for the 65536 bug has been released: ...

The fix for the 65536 bug has been released:

http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx

I've attached screen shots of ther datedif issue! Can...
Forum: Software & Technology 10-05-2007, 04:00 PM
Replies: 2
Views: 865
Posted By mark007
In addition to comments above - is the doc...

In addition to comments above - is the doc already open? Is word already open? etc.
Forum: Software & Technology 10-04-2007, 08:02 PM
Replies: 41
Views: 5,127
Posted By mark007
Yes confirmed in other versions. Will post a...

Yes confirmed in other versions. Will post a screenshot tomorrow if I remember.
Forum: Software & Technology 09-28-2007, 04:49 AM
Replies: 41
Views: 5,127
Posted By mark007
I've aso found a problem with Datedif when using...

I've aso found a problem with Datedif when using "yd" as the 3rd argument. Check it out and see what you think.

:)
Forum: General Actuarial 09-17-2007, 03:12 PM
Replies: 23
Views: 3,458
Posted By mark007
Question Northern Rock - Would you withdraw your money?

Not sure whether this has made much news in the states or not.

Alot's been said about people acting irrationally queuing to withdraw their money. So as an educated group of people, would you...
Forum: Software & Technology 09-16-2007, 06:29 AM
Replies: 2
Views: 918
Posted By mark007
Not sure why you'd want to do this but this will...

Not sure why you'd want to do this but this will dump it into column A of the active sheet:


Sub Binary()

Dim n As Integer
n = 6
Dim i As Long, j As Long
Dim strBinary As String...
Forum: Pension - Social Security 09-11-2007, 08:21 PM
Replies: 90
Views: 11,633
Posted By mark007
Well my thoughts on accounting standards can be...

Well my thoughts on accounting standards can be seen here: http://www.the-actuary.org.uk/pdfs/07_06_letters.pdf

Having said that, I don't have a huge problem with interest rates being used for...
Forum: Software & Technology 09-10-2007, 05:50 PM
Replies: 6
Views: 1,112
Posted By mark007
You could use a type: e.g. Type...

You could use a type:

e.g.

Type Employee
Dim Department as String
Dim Age as Single
End Type

Then use:
Forum: Pension - Social Security 09-09-2007, 03:07 PM
Replies: 90
Views: 11,633
Posted By mark007
I'm english and have such have no idea what you...

I'm english and have such have no idea what you mean here!



I accept this and swept it under the carpet above by considering a company with a very strong covenant.
Forum: Pension - Social Security 09-09-2007, 03:05 PM
Replies: 25
Views: 5,202
Posted By mark007
Like I say Gareth, I've not looked in detail,...

Like I say Gareth, I've not looked in detail, you're probably right (in actual fact the fact that it is a bank that has doen this went right passed me when I browsed this thread briefly late the...
Forum: Pension - Social Security 09-07-2007, 08:05 PM
Replies: 90
Views: 11,633
Posted By mark007
Ha, well I would argue if the only reason for...

Ha, well I would argue if the only reason for interest rate risk is the accounting standard then the standard is wrong.
Forum: Pension - Social Security 09-07-2007, 09:28 AM
Replies: 90
Views: 11,633
Posted By mark007
I don't think you've quite understood what I'm...

I don't think you've quite understood what I'm saying.

If liabilities are valued using interest rates then when interest rates change has the amount of cash that has to be paid out in the future...
Forum: Software & Technology 09-05-2007, 08:07 PM
Replies: 237
Views: 28,919
Posted By mark007
Took me ages to work that one out but works great...

Took me ages to work that one out but works great once you do. Wonder why it didn't follow the same rules as VBA intellisense.

For me the macro enable and the ribbon drive me nuts. Particularly...
Forum: Software & Technology 09-05-2007, 07:58 PM
Replies: 18
Views: 2,058
Posted By mark007
Couple of comments: 1. I would always favour...

Couple of comments:

1. I would always favour a button on a worksheet or a custom toolbar over keyboard shortcuts for macros that will be used by anyone but yourself.

2. The interesting thing...
Forum: Pension - Social Security 09-05-2007, 07:32 PM
Replies: 25
Views: 5,202
Posted By mark007
This is interesting. I've not read any of the...

This is interesting. I've not read any of the links or looked into this any detail but it looks to me that they are taking a punt on the fact that they believe the plan to cost less than insurers do....
Forum: Pension - Social Security 09-05-2007, 07:27 PM
Replies: 90
Views: 11,633
Posted By mark007
A little late to this party but oh well! ...

A little late to this party but oh well!

Despite earlier discussions (or, reading WW's reference above, arguments ;-)) I actually have quite a bit of time for LDI but only if it's done for the...
Forum: Careers - Employment 06-14-2007, 09:23 AM
Replies: 22
Views: 2,376
Posted By mark007
Certainly not! I would say showing...

Certainly not!



I would say showing some depth by having some extracurricular activities is essential.

When I was in the position of applying for graduate jobs I can confirm that my...
Forum: Careers - Employment 06-13-2007, 07:47 PM
Replies: 22
Views: 2,376
Posted By mark007
I would add in a 'the', an 's' and a full stop...

I would add in a 'the', an 's' and a full stop i.e.



I agree work experience needs expanding.



Not sure if this is an American thing or not. Whilst I would agree it has to be concise I...
Forum: Software & Technology 06-12-2007, 03:54 PM
Replies: 4
Views: 1,080
Posted By mark007
Depending on the layout of the workbook and what...

Depending on the layout of the workbook and what you are after you could also access it via ADO and SQL.
Showing results 1 to 25 of 141

 

All times are GMT -4. The time now is 03:42 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.24612 seconds with 7 queries