Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Spreadsheet results not agreeing with results page
Old 02-02-2008, 07:26 PM   #1
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Lsbcal's Avatar
 
Join Date: May 2006
Location: west coast, hi there!
Posts: 5,675
Spreadsheet results not agreeing with results page

I'm not quite sure how best to investigate this or report on it. What I'm seeing in FireCalc3 is that it will tell me that some series are going below the minimum portfolio value I set but then when I look at the spreadsheet values the minimums (max drawdowns in a series) are not being hit.

Here is a little more about how I've set this up. When I have run FireCalc in the past I've used the spreadsheet output to see how minimums (max drawdowns) looked for each series. With FireCalc3 I was also using the selection on the investigate tab that reads Leave some money in the portfolio for my estate. By setting a number in here I can find out how many series go below a certain minimum. The report and picture (with colored squiggly lines) seem to agree if I'm eyeballing the squigglies correctly. But the spreadsheet produced does not seem to give me the violated minimum. From past runs I'd expect these violated minimums to occur so I'm guessing the spreadsheet is in error. I use the MIN Excel function to munge the spreadsheet rows to get at the worst case drawdowns.

Any thoughts on this? I think I'm using the tool the same as in the past but I could be doing something wrong.
__________________

__________________
Lsbcal is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Old 02-03-2008, 11:08 AM   #2
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
Lsbcal's Avatar
 
Join Date: May 2006
Location: west coast, hi there!
Posts: 5,675
As a followup I decided to run the old FireCalc and FireCalc version 3 with the same parameters. The spreadsheets did not agree and were not even very close. But the failure rate results on the results page seemed to agree. So the problem may be just in the Version 3 spreadsheet result.

The Version 3 spreadsheet showing inputs and data looked like it had bad values (divide by zero, etc.). Could this be the source of the end-of-year spreadsheet problems or a separate bug?
__________________
Lsbcal is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
why different results? txdakini FIRECalc support 5 02-21-2007 09:24 AM
FIRECalc Results Chince Hi, I am... 4 09-11-2005 04:51 PM

 

 
All times are GMT -6. The time now is 06:38 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.