Thanks Joe, yeah I did rename it to Delta1. Unfortunately, the cells that might have referenced it now show =-N/A, so I don’t know what function reference you had in there.
You don’t have an updated version that you would like to share by chance? J I’m a fair VBA programmer and could patch it up if I just understood what it is doing…
Thanks,
Pete
============
"I have no respect for a man who can spell a word only one way." Mark Twain
============
From: ConservativeOptionS
Sent: Wednesday, June 02, 2010 3:13 PM
To: ConservativeOptionS
Subject: [ConservativeOption
pete, that spreadsheet is old....you added more dates, simple....rename the visual basis function delta to something else like delta1,,,,not sure what you mean what the function call looks like? drjoe
--- In ConservativeOptionS
>
>
> Hi,
>
> I just joined the group, and have been trading options for many years.
> I downloaded Dr. Joe's spreadsheet from the files section. It is three
> years or so old, and when it is opened by excel 2007, it says that
> "delta" is now a builtin function of excel, and cancels the equations
> that use it. Also, the date range of options cuts off at 2010.
>
> I had no trouble extending the dates, and renamed the function, but
> don't know what the function call looks like. Also, when I use current
> SPY info, it shows a HUGE (4 digit) IV.
>
> Does anyone have a more recent copy of the spreadsheet? The one that is
> in his folder.
>
> Thanks!
>
> Pete
>
No comments:
Post a Comment