NexusFi: Find Your Edge


Home Menu

 



Showing results 1 to 25 of 216
Search: Posts Made By: Dudetooth
Forum: Options March 6th, 2021, 05:51 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
mosalem2003, Unfortunately no. Posts...

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...
Forum: Options March 5th, 2021, 06:38 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
mosalem2003, XLS-SPAN (05d), found on post...

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.
Forum: Options April 8th, 2019, 01:41 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, I'm going to chalk this up to just...

Kevalo,

I'm going to chalk this up to just being a nut I can't crack. Thanks for trying.
Forum: Options April 8th, 2019, 12:57 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, Add "Dim lngRetVal As LongPtr" to...

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
...
Forum: Options April 8th, 2019, 11:15 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, That link was just to the forum...

Kevalo,

That link was just to the forum where someone had posted the solution to getting URLDownloadToFile working on a 64-bit version of Excel so you could see how they posted the solution.
...
Forum: Options April 8th, 2019, 09:59 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, One last thing I can think of …...

Kevalo,

One last thing I can think of … let's drop the check of the 64-bit version on your machine. This is exactly how it is shown on Excel Forum (URLDownloadToFile (API + 64 bit version)...
Forum: Options April 8th, 2019, 06:28 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, Let's try this … about half-way...

Kevalo,

Let's try this … about half-way through the Download module, find the function SaveWebFile and move it up just under the Option Explicit section and make the following changes:
...
Forum: Options April 7th, 2019, 04:39 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, If you don't mind trying, add an "A"...

Kevalo,

If you don't mind trying, add an "A" to Private Declare PtrSafe Function URLDownloadToFile so it reads Private Declare PtrSafe Function URLDownloadToFileA … that last error might be a...
Forum: Options April 6th, 2019, 05:02 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Kevalo, Could you try editing the code as...

Kevalo,


Could you try editing the code as shown in this image and see if it works for the 64-bit?

Thanks


https://nexusfi.com/attachment.php?attachmentid=264754
Forum: Options April 4th, 2019, 06:08 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
"compile error: type mismatch"

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...
Forum: Options March 28th, 2019, 02:47 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
I'd need some more details to provide any help. ...

I'd need some more details to provide any help. What line of the code is generating the error? Are you using 32-bit or 64-bit version of Offcie/Excel?
Forum: Options February 6th, 2019, 03:37 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Technically, I could be possible, but to get the...

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...
Forum: Options December 30th, 2018, 05:17 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
tinaturner, I think the version you have is...

tinaturner,

I think the version you have is slightly outdated ... try this one XLS-SPAN v.05d (https://nexusfi.com/attachments/251542d1530924680) that was added 7/6/18 with a minor fix for...
Forum: Options December 30th, 2018, 03:25 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
tinaturner, Not sure what is going on ... I...

tinaturner,

Not sure what is going on ... I don't get the same issue when I download and unzip that you are seeing.

Can you either send me a copy of your spreadsheet or a screen-shot of your...
Forum: Options August 11th, 2018, 04:12 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
It appears to apply, but since it is an...

It appears to apply, but since it is an inter-commodity spread there's no real discount. If you were doing a futures spread long the ES and short the YM the margin would be $2667 … $1860 for the ES...
Forum: Options July 6th, 2018, 08:53 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Ron, thanks for the info. I've updated the...

Ron, thanks for the info.

I've updated the code for the new CME archive ftp. Don't be surprised if it won't download 20140419 ... that span file is unavailable on the ftp site.

On a side note,...
Forum: Options June 6th, 2018, 04:47 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
jefforey, Make sure that on the Parameters...

jefforey,

Make sure that on the Parameters tab you have the default path to where you want the SPAN files maintained (cell B1) before you click the download button. If you did not modify this to...
Forum: Options May 6th, 2018, 05:21 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
It is the formatting changes you made to the...

It is the formatting changes you made to the Strike, Futures Price and/or Option Price. I am not positive where in the code it is being affected by the format changes (I think it is when it is...
Forum: Options May 6th, 2018, 04:19 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Put the spreadsheet into a zip file and upload...

Put the spreadsheet into a zip file and upload the zip ... that should be considered a valid file type.
Forum: Options May 6th, 2018, 07:14 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Can you attach a screenshot of the issue on the...

Can you attach a screenshot of the issue on the scan or track you were trying to run ... or attached the spreadsheet after running so that I can try to figure out what is going on?
Forum: Options May 6th, 2018, 06:25 AM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
Here's the results for 5-1 (the same day as your...

Here's the results for 5-1 (the same day as your attached example with the same parameters).

It appears as though customizations you made to your copy of the spreadsheet are causing the issues. ...
Forum: Options April 23rd, 2018, 04:49 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
New Currency Codes

tinaturner,

I noticed your post on the Selling Options on Futures thread. The new codes for currency options are EUU, GBU, CAU, JPU and ADU. The last version of XLS-SPAN (5d) will handle these. ...
Forum: Options February 22nd, 2018, 05:38 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
tinaturner, I don't think I'll be able to be...

tinaturner,

I don't think I'll be able to be much of a help in this case. It is difficult to troubleshoot old versions of the spreadsheet, but most importantly I don't have Excel 64-bit to test...
Forum: Options February 16th, 2018, 05:18 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
One of the procedures didn't get copied over when...

One of the procedures didn't get copied over when I was coding it. This should do the trick ... let me know if you have any other issues.
Forum: Options February 16th, 2018, 01:19 PM
Replies: 610
Sticky: PC-SPAN
Views: 191,438
Posted By Dudetooth
I'll try to troubleshoot that tonight (I think I...

I'll try to troubleshoot that tonight (I think I know what the issue is).
Showing results 1 to 25 of 216

What unexpected challenges have you encountered while trading on a "Funded Trader" platform?

 


 
 


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top