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

Change smfGetYahooJSONField() function to get data using "crumb" code #55

Closed Bruce-95 closed 10 months ago

Bruce-95 commented 11 months ago

People are posting saying they are not getting data for some elements. Many of these elements are in the smf-elements-2.txt file using the smfGetYahooJSONField() function. Currently the function is trying to get url data without the "crumb" code.

Near the end of the smfGetYahooJSONField() function in the modGetYahooJSONData module, please change

......... s1 = smfGetWebPage(sURL) to ... s1 = smfGetWebPage(sURL, 4)

ClimberMel commented 11 months ago

Bruce can you create a spreadsheet with all the elements from elements2.txt, then make any of the changes and forward the file here? I can then post it for everyone. Probably should go with issue 52.

Bruce-95 commented 11 months ago

As requested here's the updated smf-elements-2.txt and a spreadsheet containing all those elements . And yes the update includes those reported in issue #52. (The spreadsheet I sent you earlier was one I used for testing issue #56. My bad. )

smf-elements-2.txt smf-elements-2.xlsx

ClimberMel commented 10 months ago

Adding to new release