Early Retirement Forums tag -->

Go Back   Early Retirement Forums > General > FIRECalc support
Reply
 
Thread Tools Search this Thread Display Modes
Old 02-02-2008, 06:26 PM   #1
Recycles dryer sheets
 
lsbcal's Avatar
 
Join Date: May 2006
Posts: 463
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
Old 02-03-2008, 10:08 AM   #2
Recycles dryer sheets
 
lsbcal's Avatar
 
Join Date: May 2006
Posts: 463
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 On
Refbacks are Off
Forum Jump

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


All times are GMT -6. The time now is 08:15 PM.

Other Social Knowledge forum communities:
Cooking Forum - Sailing Forum - Early Retirement
Airstream Trailer Forum - Aquarium & Reef Forum
Royal Forum - Book and Reader Forum - Yoga Forum
Volkswagen Touareg Forum - Jeep Wrangler Forum
Whitewater Kayaking & Rafting Forum - Yoga Forum
Interference - U2, Pop Culture & Social Responsibility
Social Knowledge Networks
Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0