Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Dudetooth, Thanks for the updated excel sheet - Now im running into a different error. When I try to download the current days files, I get a "sub function not defined":
Does this have to do with the updated virus definitions/scanner?
Can you help answer these questions from other members on NexusFi?
I doubt it. The last version I posted had the fix for the virus scanners (uses a different routine to download files). I just tried to download the PA2 files using that spreadsheet and received no errors. I suspect that your pc had a hiccup. Try a reboot and then try the download again. Let me know if that doesn't fix the issue.
I didn't find it in the quick summary link, thanks!
Sorry to bother you, I reviewed a few pages of this thread and did not find the link to buy the program.
it looks like the real challenge for me now is to figure out how to use the SPAN:-(
Edit1, I found the link!
Edit2: This link does not show the price for $10.00, it is risk manager for $3000.00, I still need help.
Hi Dudetooth - thanks for all your help. So I figured out what the issue was. I was getting the same error as before for "64-bit code" and I did your modification you mentioned here, which got rid of the error but then it deleted the download function for the spa files. Anyways a quick google search brought me here, and all I did was add the word "PtrSafe" before the declare statements and it worked great.
The previous error with margin calculation of the CL contracts is fixed! Thanks
Now I'm facing two other issues with the new sheet. First, I'm getting a different SPAN margin calculation for my 6E contracts from the prior version: (scan date for both is 9/3/2014)
4b version says $455:
prior version says $461:
The second issue is I'm using the tracking page to track trades in three separate accounts - which have the same contracts but different quantities. When I use the track all button, it states the same position IM for ALL of them (its only correct for with the account with the most contracts). Example below where the Position IM is the same for all three - when its only correct for only 21 contracts:
With your first issue:
$461 per spread is the correct amount. If I remember correctly (and not get too far in the weeds), the reason for the difference in price is that when I made the XLSv3 I did not have it coded properly for the cabinet value. The XLSv4b is grabbing the cabinet value as it is defined in the PA2 file. Since you are using Total Margin the value of the options are added in to the initial margin.
For your second issue:
That is a known issue when running Track All, but I believe I have a work-around for you.
-Replace the TrackAll code in your spreadsheet with the code from the attached text file.
-For any position that you have multiple lines with the same option month and same strike, give it a unique spread number in column F, then when the code is run it will treat it separately and you should see the different results.