1 Message
Digest #4395
Message
Sat Sep 8, 2018 5:02 am (PDT) . Posted by:
stan_12@ymail.com
Hi Randy,
thanks for your quick answer.
My aim is to calculate the average Dividend/Price- Ratio. If I divide the Dividend through the Div-Adjusted Close the historic Div/Price-Ratios are getting higher than they really were at that time. That's why I would prefer the unadjusted Close.
Can you recommend another function to get to the unadjusted close? I tried "smfGetYahooHistory" but it was very slow as I have 200+ symbols. I probably got the configuration wrong.
I have the year-end dates for the last 10 years in the columns, and symbols in the rows.
Example:
=smfGetYahooHistory("IBM",,"12/31/2007",,"U",0)
In the Temp Internet FIles I could see that for every date a new file was created, hence the slowliness.
Probably array-entering something is the solution, but i could figure out how.
Best Regards ... Stan
thanks for your quick answer.
My aim is to calculate the average Dividend/Price- Ratio. If I divide the Dividend through the Div-Adjusted Close the historic Div/Price-Ratios are getting higher than they really were at that time. That's why I would prefer the unadjusted Close.
Can you recommend another function to get to the unadjusted close? I tried "smfGetYahooHi
I have the year-end dates for the last 10 years in the columns, and symbols in the rows.
Example:
=smfGetYahooHistory
In the Temp Internet FIles I could see that for every date a new file was created, hence the slowliness.
Probably array-entering something is the solution, but i could figure out how.
Best Regards ... Stan
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar