module smfGetOptionQuotes
A member (Bruce) found the issue was with the crumb processing and provided code for processing that.
I have updated the web site https://climbermel.github.io/SMF_Add-in/
A word of caution!
It is always a good idea to back up you C:\SMF Add-In folder before updating.For example: copy C:\SMF Add-In to C:\Old Add-In
That way if it doesn't work as planned you can just copy it back...
Cheers,
MelI am using Excel 2010 for this example. Other versions may differ...
To add a macro button to the toolbar:
Go to the Quick Access Toolbar at the top of the spreadsheet and select the down arrow to bring up the “Quick Access Toolbar Customize” window.
Go to the bottom and select “More Commands ...”.
In the next window under “Choose Commands from:” select “Macros”.
Select “smfForceRecalculation” from the list and click the “Add >>” button between the two boxes. Click OK.
I have added a Stock Review spreadsheet that was originally provided by Duke and I fixed some of the data items that he was getting from a different source.
It pulls data from many places such as:
It is in the template section of the SMF web site.
This new release has fixes for:
smfGetOptionExpiry & smfGetOptionStrikes.
A member found the issue was with the crumb processing and provided code for processing that.
I have updated the web site https://climbermel.github.io/SMF_Add-in/
A word of caution!
It is always a good idea to back up you C:\SMF Add-In folder before updating.For example: copy C:\SMF Add-In to C:\Old Add-In
That way if it doesn't work as planned you can just copy it back...
Cheers,
MelThere have been a number of comments that this is not working. Bruce found that it is due to an invalid crumb. So he has created some code changes that will utilize the Invoke =RCHGetWebData with TYPE(4) param for Yahoo options url.
and Add "?" to end of url if no other params used so "&crumb= ..." can be processed.
I am testing the two code changes and if they have no issues, will build a new add-in and distribute.
This new release has added functionality for smfGetYahooJSONData to work with 64bit Excel.
Thanks again to the growing help from the group. This add-in is definitely becoming a group effort. There are a number of fixed elements that have been submitted and are in the new smf-elements2.txt and smf-elements9.txt
I have updated the web site https://climbermel.github.io/SMF_Add-in/
A word of caution!
If you don't use the function smfGetYahooJSONData or if you don't use 64bit Excel, you may not want to use this change. You can still extract the element files to update those without changing you xla file.
It is always a good idea to back up you C:\SMF Add-In folder before updating.
For example: copy C:\SMF Add-In to C:\Old Add-In
That way if it doesn't work as planned you can just copy it back...
Cheers,
Mel
Just in case you use Zack's web site:
This notice is regarding a prior data breach disclosed by Zacks at https://www.zacks.com/breach/.
We have confirmed that in association with this breach relating to a
smaller subset of customers whose unencrypted passwords were
compromised, the unauthorized third parties also gained access to
encrypted passwords of zacks.com customers, but only in the encrypted
format.
