PC-SPAN - futures io
futures io futures trading



PC-SPAN


Discussion in Options

Updated by peternguyen
      Top Posters
    1. looks_one Dudetooth with 216 posts (211 thanks)
    2. looks_two ron99 with 115 posts (54 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.0 thanks per post
    2. looks_two SMCJB with 1.0 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 98,094 views
    2. thumb_up 314 thanks given
    3. group 73 followers
    1. forum 604 replies
    2. attach_file 158 attachments




Welcome to futures io: the largest futures trading community on the planet, with well over 100,000 members
  • 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 and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

 
Search this Thread
 

PC-SPAN

(login for full post details)
  #591 (permalink)
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
 
Posts: 264 since Sep 2012
Thanks: 30 given, 272 received


Kevalo View Post
@Dudetooth

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.


@Kevalo,


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

Thanks



Reply With Quote
The following user says Thank You to Dudetooth for this post:

Can you help answer these questions
from other members on futures io?
Horizontal Line Indicator
Platforms and Indicators
EQIX - Digital REITs - any experiences?
Stocks and ETFs
Looking freelancer for MT4 Indicator
Platforms and Indicators
help to convert from thinkscript to ninjascript
NinjaTrader
IB Bracker Order
Platforms and Indicators
 
 
(login for full post details)
  #592 (permalink)
Germany
 
Experience: Advanced
Platform: AgenaTrader, TWS
Broker: IB, Saxo
Trading: Stocks, Options
 
Posts: 12 since Feb 2011
Thanks: 63 given, 3 received

@Dudetooth

I have changed the code in the 64-bit Version as shown in your image.

There is still a compilation error. This time It says „Sub or Function not defined“, again highlighting the expression "URLDownloadToFileA" as shown:
Private Function SaveWebFile(URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then SaveWebFile = True
End Function
BTW, how can I insert an image between the text lines? Copy and paste didn't work. And the import image function requires a URL.

Reply With Quote
 
(login for full post details)
  #593 (permalink)
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
 
Posts: 264 since Sep 2012
Thanks: 30 given, 272 received



Kevalo View Post
@Dudetooth

I have changed the code in the 64-bit Version as shown in your image.

There is still a compilation error. This time It says „Sub or Function not defined“, again highlighting the expression "URLDownloadToFileA" as shown:
Private Function SaveWebFile(URL As String, LocalFilename As String) As Boolean
Dim lngRetVal As Long
lngRetVal = URLDownloadToFileA(0, URL, LocalFilename, 0, 0)
If lngRetVal = 0 Then SaveWebFile = True
End Function
BTW, how can I insert an image between the text lines? Copy and paste didn't work. And the import image function requires a URL.

@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 simple fix.




For the images, when you go to respond, click on the attach file:


Browse for the image to upload. Once you click Upload and it is complete you can select Embed … wherever your cursor is in the message it will insert the image:


You can move the html line "[IMG]https://futures.io/attachment.php?attachmentid=*****[/IMG]" to wherever you'd like the image to appear in your response.


Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
(login for full post details)
  #594 (permalink)
Germany
 
Experience: Advanced
Platform: AgenaTrader, TWS
Broker: IB, Saxo
Trading: Stocks, Options
 
Posts: 12 since Feb 2011
Thanks: 63 given, 3 received


Dudetooth View Post
@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 simple fix.

@Dudetooth

No, I certainly don’t mind. I am very grateful to you and also @ron99 for your outstanding work here and your willingness to help with the 64-bit problem. I wished I could give back more but I am no programmer (not even close). Thank you also for your info about importing images.

I added an „A“ to URLDownloadToFile. The code in my Excel now looks as shown below:




Now there is again the old type mismatch compilation error (My Excel is the German version. The error message translates to „type mismatch“)


Reply With Quote
The following user says Thank You to Kevalo for this post:
 
(login for full post details)
  #595 (permalink)
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
 
Posts: 264 since Sep 2012
Thanks: 30 given, 272 received


Kevalo View Post
No, I certainly don’t mind …
Now there is again the old type mismatch compilation error (My Excel is the German version. The error message translates to „type mismatch“)

@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:



Then let's see if it works.

Thanks.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
(login for full post details)
  #596 (permalink)
Germany
 
Experience: Advanced
Platform: AgenaTrader, TWS
Broker: IB, Saxo
Trading: Stocks, Options
 
Posts: 12 since Feb 2011
Thanks: 63 given, 3 received


Dudetooth View Post
@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:



Then let's see if it works.

Thanks.

@Dudetooth

No more compilation errors with those changes! However, no risk files can be downloaded. After starting the download the normal message „Saving … risk files“ changes to „Unable to download risk files from server“ after a few seconds.

I already checked my parameter settings and tried various dates. No download possible. The risk files can be downloaded on my wife’s system, on which a 32-bit version of Excel is installed, so there is no problem at CME.

Thanks!

Reply With Quote
The following user says Thank You to Kevalo for this post:
 
(login for full post details)
  #597 (permalink)
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
 
Posts: 264 since Sep 2012
Thanks: 30 given, 272 received


Kevalo View Post
@Dudetooth

No more compilation errors with those changes! However, no risk files can be downloaded. After starting the download the normal message „Saving … risk files“ changes to „Unable to download risk files from server“ after a few seconds.

I already checked my parameter settings and tried various dates. No download possible. The risk files can be downloaded on my wife’s system, on which a 32-bit version of Excel is installed, so there is no problem at CME.

Thanks!

@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) [SOLVED]) and then you would need to make a small change to the function SaveWebFile (drop A so it reads URLDownloadToFile).


If this doesn't work, I'm really at a loss.

Reply With Quote
The following user says Thank You to Dudetooth for this post:
 
(login for full post details)
  #598 (permalink)
Germany
 
Experience: Advanced
Platform: AgenaTrader, TWS
Broker: IB, Saxo
Trading: Stocks, Options
 
Posts: 12 since Feb 2011
Thanks: 63 given, 3 received

@Dudetooth

Thanks, Dudetooth, but I cannot find any info on how to drop the 64-bit check in your link. The moderator posted the code for the 64-bit conversion of the URLDownloadToFile Function, that was already included in your last changes. Have I overlooked something?

Reply With Quote
 
(login for full post details)
  #599 (permalink)
Steubenville Ohio
 
Experience: Intermediate
Platform: OX, OEC, RJO
Trading: Options on Futures
 
Posts: 264 since Sep 2012
Thanks: 30 given, 272 received


Kevalo View Post
@Dudetooth

Thanks, Dudetooth, but I cannot find any info on how to drop the 64-bit check in your link. The moderator posted the code for the 64-bit conversion of the URLDownloadToFile Function, that was already included in your last changes. Have I overlooked something?

@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.

The screenshot I included was showing proposed change to the code at the top of the Download module … if you change the code from looking like the pic in post #595 to the pic in post #597 you will remove the 64-bit check.

Reply With Quote
 
(login for full post details)
  #600 (permalink)
Germany
 
Experience: Advanced
Platform: AgenaTrader, TWS
Broker: IB, Saxo
Trading: Stocks, Options
 
Posts: 12 since Feb 2011
Thanks: 63 given, 3 received



Dudetooth View Post
@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.

The screenshot I included was showing proposed change to the code at the top of the Download module … if you change the code from looking like the pic in post #595 to the pic in post #597 you will remove the 64-bit check.

@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!


Reply With Quote


futures io Trading Community Traders Hideout Options > PC-SPAN


November 20, 2019


Upcoming Webinars and Events
     



Copyright © 2020 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
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.
no new posts