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)
I think the version you have is slightly outdated ... try this one XLS-SPAN v.05d that was added 7/6/18 with a minor fix for downloading from CME after they restructured their archives.
I've tried to make sure that the most recent version is always on the first page in the Quick Summary Post.
Let me know if that doesn't work for you.
Can you help answer these questions from other members on NexusFi?
I am new to this thread and there is a lot to read, so apologies in advance if this question has already been asked and/or answered.
I use PC-SPAN for margin requirements on a portfolio of S&P 500 futures options. I am trying to create and intraday/live SPAN model in order to see how putting on a new option spread position would affect my margin requirement. For example, if I am short the 2DG9C 2780 and add a 1x4 call spread at let's say 2730/2750 and the current ESH9 futures is trading at 2680 what would be my margin and how would this new trade affect my current margin requirement.
I am not sure if this is doable, but I would have a live futures price feeding into the model and need to know what the margin impact would be on my current portfolio when I add a new trade.
PS. I am only trading options on the S&P 500 futures currently
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals, U308 and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,059 since Dec 2013
Thanks Given: 4,410
Thanks Received: 10,226
I trade NG and CL futures spreads I have a spreadsheet that I enter my positions into. I then run a macro that creates a position file with my position in it combined with about 100 other scenario's/new possible position. I then load that position file into span, run the margin calculations and then I can see what the effect of each scenario would be on my margin position.
I don't trade S&P options. Doing this calculation for options is a lot more complicated as the margin changes every day, which isn't the case with futures.
Technically, I could be possible, but to get the most accurate intraday calculations you would need to use the intraday risk files created by CME. Right now PC-SPAN is using the previous day's risk files and is not coded to download or use the intraday risk files. In most cases there may not be much of a difference, but on days where there are spikes your calculations could be off by quite a bit.
I'm not positive, but it looks like URLDownloadToFile is generating the error when it tries to execute the code in the 64-bit version of Excel you are running. Unfortunately, I have the 32-bit version of Excel, so I can't really troubleshoot the issue. I tried to address it previously with the code at the top of the Download Module where it checks if you have the 32 or 64-bit version of Excel and runs the appropriate URLDownloadToFile code, but I have no idea if it actually works.
First let me thank you for your great work on PC SPAN. It helped me a lot.
I changed the code as shown in your image above in an Excel 2016 64-bit Version. Unfortunately there is still the same "compile error: type mismatch" highlighting the expression „URLDownloadToFileA“.
Edit:
There is no problem running it on Excel 2016 32-bit.