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

Cannot get the function to return quotes for non-stock issues such as Vanguard, Janus, Fidelity (VFIIX as one example) #15

Closed ClimberMel closed 1 year ago

ClimberMel commented 1 year ago

From Fred Urble Feb 13, 2023, 4:26:12 PM (yesterday) to SMF Add-In

Mel,

Thanks so very much for resurrecting the function!

A couple of questions/changes:

  1. Since the begin and end dates are optional, can the default be set to return the most recent date vs. the oldest date in Yahoo history?

  2. I cannot get the function to return quotes for non-stock issues such as Vanguard, Janus, Fidelity (VFIIX as one example). The Yahoo finance page provides quotes and history exactly the same as stocks, and not sure why the same function pulling data wouldn't pick these up as well.

Thanks!

ClimberMel commented 1 year ago

Asked for detail on which function is being used to request data for non-stock issues such as Vanguard, Janus, Fidelity (example VFIIX). If it is displaying on Yahoo, then yes it should be able to be returned.

2 is more of an enhancement request.

If you don't give it a date, it should return from 1970-01-01 (not sure why that is the default start date other than it needs a date and that is close to the oldest for most stocks) to current. There was a default of 2020-12-31 for current but I have changed that to 2024-12-31 for the next release.

ClimberMel commented 1 year ago

Tested with using smfGetYahooHistory and it returns data for VFIIX.