3 Messages
Digest #4057
Messages
Mon Jun 12, 2017 8:20 pm (PDT) . Posted by:
lutherkinchen
Randy you are a genius. Using the shortcut and logging in did the trick.
Thank You!!
Thank You!!
Tue Jun 13, 2017 1:33 pm (PDT) . Posted by:
seongkook_berry
I've just started using this add-in so hopefully this isn't a dumb question. But I one thing I want is monthly high stock prices. So I used this function =RCHGetYahooHistory("BWP",2016,12,1,2017,5,31,"m","h"), which seems to work fine. However, I double checked with google finance historical prices. I looked at the daily high prices for each month and it seems the monthly high stock prices are different. Is there a reason for this or am I doing something wrong?
Tue Jun 13, 2017 2:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo historical quotes are (now) adjusted for dividends and Google's are
not. It's one of the reasons I don't use Google historical quotes.
However, having said that, it looks like the high and closing prices for
May on monthly data is not correct. If I were to guess, I'd say it was
because the $0.10 dividend in May was applied at month end rather to just
prices prior to the ex-dividend date. If you look at the monthly data
displayed on the web site:
https://finance.yahoo.com/quote/BWP/history?period1=1465851030&period2=1497387030&interval=1mo&filter=history&frequency=1mo
...you'll see that the closing price is stated as $18.07, but they state
the adjusted closing price is $17.97, presumably because of the $0.10
dividend on May 9th. However, the closing price is AFTER the dividend was
paid, so there should be no adjustment.
The daily data appears to have the correct adjustments. For example:
https://finance.yahoo.com/quote/BWP/history?period1=1465851030&period2=1497387030&interval=1d&filter=history&frequency=1d
Note that the closing AND adjusted closing price on May 31 are both $18.07,
which is correct.
On Tue, Jun 13, 2017 at 1:29 PM, seongkook_berry@
...
wrote:
> I've just started using this add-in so hopefully this isn't a dumb
> question. But I one thing I want is monthly high stock prices. So I used
> this function =
>
> RCHGetYahooHistory("BWP",2016,12,1,2017,5,31,"m","h"), which seems to
> work fine. However, I double checked with google finance historical prices.
> I looked at the daily high prices for each month and it seems the monthly
> high stock prices are different. Is there a reason for this or am I doing
> something wrong?
>
>
>
not. It's one of the reasons I don't use Google historical quotes.
However, having said that, it looks like the high and closing prices for
May on monthly data is not correct. If I were to guess, I'd say it was
because the $0.10 dividend in May was applied at month end rather to just
prices prior to the ex-dividend date. If you look at the monthly data
displayed on the web site:
https://finance.yahoo.com/quote/BWP/history?period1=1465851030&period2=1497387030&interval=1mo&filter=history&frequency=1mo
...you'll see that the closing price is stated as $18.07, but they state
the adjusted closing price is $17.97, presumably because of the $0.10
dividend on May 9th. However, the closing price is AFTER the dividend was
paid, so there should be no adjustment.
The daily data appears to have the correct adjustments. For example:
https://finance.yahoo.com/quote/BWP/history?period1=1465851030&period2=1497387030&interval=1d&filter=history&frequency=1d
Note that the closing AND adjusted closing price on May 31 are both $18.07,
which is correct.
On Tue, Jun 13, 2017 at 1:29 PM, seongkook_berry@
...
wrote:
> I've just started using this add-in so hopefully this isn't a dumb
> question. But I one thing I want is monthly high stock prices. So I used
> this function =
>
> RCHGetYahooHistory(
> work fine. However, I double checked with google finance historical prices.
> I looked at the daily high prices for each month and it seems the monthly
> high stock prices are different. Is there a reason for this or am I doing
> something wrong?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar