search

ClimberMel / SMF_Add-in

Stock Market Functions for Excel using VBA
https://climbermel.github.io/SMF_Add-in/
14 stars 5 forks source link

smfGetOption Expirations - Subscript out of range #49

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

Module: modGetOptionExpirations Function: smfGetOptionExpirations

I have removed all the obsolete code for various sources such as OX, 888, Google BC since Yahoo is the only one of them currently working.

While testing, I noticed that it would never return an Option ticker like it was supposed to if PutCall and Strike were provided Found the issue here For iRow = 1 To 50
If I had 8 rows to fill, it would continue on and then get a Subscript out of range error since vData was dimentioned to 8 rows and 1 column. Changed code as follows and it works fine: For iRow = 1 To kRows

ClimberMel commented 1 year ago

I will also create an updated Documentation page for the web site.