smfGetYahooPortfolioView possible incorrect data returned

[ClimberMel]

I've just tried version 02.09 but it seems to produce incorrect results. For example here is a formula I am using to calculate the avg. annual return for VTSAX for the past 10 years:

 =(@smfGetYahooPortfolioView("VTSAX","15",,0)/@smfGetYahooHistory("VTSAX","2013-02-07","2013-02-08", "w","C",0,0))^(1/10)-1

It evaluates to 10.2% but it should produce 12.3% instead (checking against Morningstar and another financial information website).

Any thoughts?

Marek

[ClimberMel]

[ClimberMel]

I thought it was pulling adj close in the other routines, so I will have to check why it isn't when called from this module.

[ClimberMel]

While investigating this module, I did note that smfGetPortfolioView makes multiple calls to Yahoo to get the data one ticker at a time. The sURL that is created gets a json file for the entire request. I need to check if it is actually retrieving the data again, or using cached data as some of the modules are able to do. If it is using cached data, that is fine if it just loops through the results:0 through xx

[ClimberMel]

This is appears related to the mix up over the C = adjusted close and U = unadjusted close issue with smfGetYahooHistory since Marek's formula also called smfGetYahooHistory. There is no issue currently with smfGetYahooHistory.