Kevalo 

@Dudetooth OK, got it. Was a misunderstanding on my side. I changed the code accordingly but now there is a new compilation error because the variable "lngRetVal" is not defined. How and where can it be defined? I think it should be working after that definition. Thanks again!

@Kevalo,

Add "Dim lngRetVal As LongPtr" to Function SaveWebFile so it reads:

Private Function SaveWebFile(URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As LongPtr
lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then SaveWebFile = True
End Function

Dudetooth 

@Kevalo, Add "Dim lngRetVal As LongPtr" to Function SaveWebFile so it reads: Private Function SaveWebFile(URL As String, LocalFilename As String) As Boolean Dim lngRetVal As LongPtr lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0) If lngRetVal = 0 Then SaveWebFile = True End Function

@Dudetooth

When I started a risk file download after the changes above, the whole Excel-Application crashed without any further messages. I restarted Excel and tried downloading several times but Excel keeps crashing. To be sure I edited everything correctly here is the complete code of that section that causes the crash.

But please don't invest too much of your time on that. As I said, I am grateful for the time and work you spent already. Thanks again.

Kevalo 

@Dudetooth When I started a risk file download after the changes above, the whole Excel-Application crashed without any further messages. I restarted Excel and tried downloading several times but Excel keeps crashing. To be sure I edited everything correctly here is the complete code of that section that causes the crash. But please don't invest too much of your time on that. As I said, I am grateful for the time and work you spent already. Thanks again.

@Kevalo,

I'm going to chalk this up to just being a nut I can't crack. Thanks for trying.

Dudetooth 

@Kevalo, I'm going to chalk this up to just being a nut I can't crack. Thanks for trying.

@Dudetooth

OK, no problem. Thanks again.

ron99 

Those margins quoted by Dudetooth are exchange minimum margins or SPAN margins. Nobody can have lower margins. Some have higher margins. I use DeCarley Trading. Excellent customer service. https://www.decarleytrading.com/

Do you know any option broker in Australia that offer SPAN margin on options on future contracts? Thanks.

What is the latest version of the sheet that works with Win10-64 bits ?

mosalem2003 

What is the latest version of the sheet that works with Win10-64 bits ?

@mosalem2003,

XLS-SPAN (05d), found on post #570.

It will work on Win10 64-bit, but may not work correctly if you are using it on the 64-bit version of Excel.

Dudetooth 

@mosalem2003, XLS-SPAN (05d), found on post #570. It will work on Win10 64-bit, but may not work correctly if you are using it on the 64-bit version of Excel.

Using Excel 64 bits , it has an issue as enclosed:

Is there a work-around or instructions for excel usage?

mosalem2003 

Using Excel 64 bits , it has an issue as enclosed: Is there a work-around or instructions for excel usage?

@mosalem2003,

Unfortunately no. Posts #586-603 cover the same error you are seeing. I do not have the 64-bit version of Excel, so I really can't effectively troubleshoot problems with that version VBA.

If you use an alternate means to download the risk files it may work for the analysis, but I suspect it is likely that there would be other issues where the VBA doesn't translate properly from 32-bit to 64-bit.

I'm not sure if anyone else has any luck converting the VBA.

Sorry.

Quoting 

In late 2021, CME Group will begin migrating products on CME Group markets to an enhanced margin framework, the SPAN 2TM framework. Beginning with NYMEX Energy products, this new framework will be introduced across all CME Group products in a phased approach over the next few years and eventually will replace SPANŽ.

Quoting 

PC SPAN software will not be updated to include the SPAN 2 methodology but will continue to support products in the legacy SPAN framework. However, to assist users in this transition, CME Group has enhanced our online margin calculator, CME CORE, with the most commonly used PC SPAN functionality, and the new UI is now live for futures and options users.

https://go.cmegroup.com/webmail/502091/1002934459/394f7032988bc7df65d3fbf91dd8e1b741a9041364f5dd853dc6b17f66e5b477