2 Messages
Digest #4397
1a
Re: smfPricesByDates delivers "adjusted Close" / yahoos "Close" also by "Randy Harmelink" rharmelink
Messages
Mon Sep 10, 2018 4:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your mention of an array-entered formula got me curious. This array-entered
formula gets me the unadjusted closing prices for the two dates in cells
B18:B19 and the ticker symbol in cell E17:
=INDEX(smfGetYahooHistory(E$17,,,,,,,20000,11),MATCH($D18:$D19,INDEX(smfGetYahooHistory(E$17,,,,,,,20000,11),,1),0),7)
That last parameter value, of 7, indicates which of the standard columns to
retrieve of those returned by smfGetYahooHistory().
Here's an example of what I got:
*Date* *MMM* *IBM*
2018-09-05 $211.83 $146.66
2018-08-27 $208.33 $146.69
However, unlike the smfPricesByDates() function, only actual trading days
would be found.
On Sat, Sep 8, 2018 at 2:17 PM stan_12@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> 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.
>
>
>
formula gets me the unadjusted closing prices for the two dates in cells
B18:B19 and the ticker symbol in cell E17:
=INDEX(smfGetYahooHistory(E$17,,,,,,,20000,11),MATCH($D18:$D19,INDEX(smfGetYahooHistory(E$17,,,,,,,20000,11),,1),0),7)
That last parameter value, of 7, indicates which of the standard columns to
retrieve of those returned by smfGetYahooHistory().
Here's an example of what I got:
*Date* *MMM* *IBM*
2018-09-05 $211.83 $146.66
2018-08-27 $208.33 $146.69
However, unlike the smfPricesByDates() function, only actual trading days
would be found.
On Sat, Sep 8, 2018 at 2:17 PM stan_12@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> 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
> "smfGetYahooHi
> 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
>
> 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.
>
>
>
Tue Sep 11, 2018 5:20 am (PDT) . Posted by:
stan_12@ymail.com
thanks, I will have a closer look at this soon.
Based on your message before I have been able to find a good solution.
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM
gives the Dividends and the Year-End yields (based on Split but not Div adjusted Prices).
Then the Year-End Prices (similar to yahoos Unadjusted Closes) can be calculated from that.
In addition there is a quick way to get to Year-End (and other) OHLC-Prices using for example RCHGetTableCell in combination with this:
http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
thanks again for your support!
Based on your message before I have been able to find a good solution.
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM
gives the Dividends and the Year-End yields (based on Split but not Div adjusted Prices).
Then the Year-End Prices (similar to yahoos Unadjusted Closes) can be calculated from that.
In addition there is a quick way to get to Year-End (and other) OHLC-Prices using for example RCHGetTableCell in combination with this:
http://performance.morningstar.com/perform/Performance/stock/price-history.action?&t=MMM&culture=en-US&cur=&ops=clear&pd=10y&sd=&ed=&freq=a&pg=0&pgsz=20
thanks again for your support!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar