NexusFi: Find Your Edge


Home Menu

 





PC-SPAN


Discussion in Options

Updated
      Top Posters
    1. looks_one Dudetooth with 218 posts (213 thanks)
    2. looks_two ron99 with 116 posts (55 thanks)
    3. looks_3 CafeGrande with 30 posts (4 thanks)
    4. looks_4 BlueRoo with 24 posts (5 thanks)
      Best Posters
    1. looks_one Dudetooth with 1 thanks per post
    2. looks_two SMCJB with 1 thanks per post
    3. looks_3 ron99 with 0.5 thanks per post
    4. looks_4 BlueRoo with 0.2 thanks per post
    1. trending_up 188,781 views
    2. thumb_up 317 thanks given
    3. group 75 followers
    1. forum 610 posts
    2. attach_file 159 attachments




 
Search this Thread

PC-SPAN

  #431 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ItalianBmT View Post
I am using the version 5a and i had tested it across mutliple dates.

thanks in advance

Sorry, I meant can you give me specific dates that you tried so I can see if I can reproduce the error.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
NexusFi Journal Challenge - April 2024
Feedback and Announcements
Exit Strategy
NinjaTrader
Deepmoney LLM
Elite Quantitative GenAI/LLM
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Get funded firms 2023/2024 - Any recommendations or word …
61 thanks
Funded Trader platforms
39 thanks
NexusFi site changelog and issues/problem reporting
26 thanks
The Program
18 thanks
Battlestations: Show us your trading desks!
18 thanks
  #432 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0

I tried using 10 april, 15 and most recently 26 april

Reply With Quote
  #433 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274



ItalianBmT View Post
I tried using 10 april, 15 and most recently 26 april

Can you get to these links through your browser?
https://ftp://ftp.cmegroup.com/pub/span/data/cme/cme.20170426.s.pa2.zip
https://www.ice.com/publicdocs/span_files/icus/2017/04/NYB0426F.csv.zip

I tried April 10 and 26 in ver.05a and was able to download without that error. I'm wondering if you are being affected by a firewall.

Reply With Quote
  #434 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0

Hi Dudetooth,
I am able to download both links. Clicking through the excel sheet still fails. Not sure what should I do next?

Reply With Quote
  #435 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ItalianBmT View Post
Hi Dudetooth,
I am able to download both links. Clicking through the excel sheet still fails. Not sure what should I do next?

I'm not really sure what is going on. At this point, it's going to be kind of difficult to troubleshoot without seeing what's going on.

I'm sorry I couldn't be more of a help, but if you'd like we could see about getting together online where you could share your screen and I could see if I can fix things for you. Just message me if you'd like to set something up.

Reply With Quote
  #436 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0

It is ok no worries. You have been great help to everyone here thus far. Just by any chance could this be an issue with 64 bit office?

Maybe you could guide me to do more trouble shooting ie. Looking at debugger on the vba?

Reply With Quote
  #437 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ItalianBmT View Post
Just by any chance could this be an issue with 64 bit office?

Not that I am aware of.


ItalianBmT View Post
Maybe you could guide me to do more trouble shooting ie. Looking at debugger on the vba?

That error message was programmed into the code to be used only if the request for the downloaded file came up empty.

I'm not sure how comfortable you are with VBA, but the sub that you would be looking to check would be the SaveRiskFiles() in the Download module. If you step and take note of where you are in the code when that error show up for you that might help.

The only thing I can think of would be the date. The only way that I can get the spreadsheet to give me that error is if the date is incorrect. Can you confirm for me that if you go to the Track tab, enter "20170426" into cell A1, and you click Download that you still get the error "Unable to download Risk files from servers"?

Note: The date should be entered as YYYYMMDD in cell A1, but it should remain formatted as General ... make sure Excel does not format that cell into a date.

Reply With Quote
  #438 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0


Dudetooth View Post
Not that I am aware of.


That error message was programmed into the code to be used only if the request for the downloaded file came up empty.

I'm not sure how comfortable you are with VBA, but the sub that you would be looking to check would be the SaveRiskFiles() in the Download module. If you step and take note of where you are in the code when that error show up for you that might help.

The only thing I can think of would be the date. The only way that I can get the spreadsheet to give me that error is if the date is incorrect. Can you confirm for me that if you go to the Track tab, enter "20170426" into cell A1, and you click Download that you still get the error "Unable to download Risk files from servers"?

Note: The date should be entered as YYYYMMDD in cell A1, but it should remain formatted as General ... make sure Excel does not format that cell into a date.

I got the date in the format above, and it is also format as general. Strange that it diesnt work for me somehow

Reply With Quote
  #439 (permalink)
 Dudetooth 
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
Posts: 266 since Sep 2012
Thanks Given: 30
Thanks Received: 274


ItalianBmT View Post
I got the date in the format above, and it is also format as general. Strange that it diesnt work for me somehow

What version of Windows do you have (7 or 10 ... 32 bit or 64 bit)? What version of Office (2010, 2013, or 2016 ... 32 bit or 64 bit)? Maybe there is some compatibility issue.

Reply With Quote
  #440 (permalink)
 ItalianBmT 
Java/IN
 
Experience: Beginner
Platform: TOS
Trading: gold
Posts: 13 since Nov 2013
Thanks Given: 2
Thanks Received: 0


I am using windows 10. 64 bit running on office 2016 64 bit as well..

Reply With Quote




Last Updated on September 23, 2021


© 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
no new posts