7 Messages
Digest #4279
Messages
Fri Dec 29, 2017 11:16 pm (PST) . Posted by:
"Ian Rogers" irianr1943
Hi All
Not sure why but when I use RCHGetYahooHistory for Australian stock PME.AX
(I'm also located in Australia) I get
26/12/2017 8.250 8.790 8.250 8.790 95,812.00
27/12/2017 8.900 8.990 8.600 8.790 49,942.00
28/12/2017 8.790 8.830 8.650 8.720 16,977.00
but when I look at https://finance.yahoo.com I get
Dec 29, 2017
8.79
8.83
8.65
8.72
16,977
Dec 28, 2017
8.90
8.99
8.60
8.79
49,942
Dec 27, 2017
8.25
8.79
8.25
8.79
95,812
I am using the latest version of SMF Add-in.
I get the same results when I look at https://au.finance.yahoo.com
I am using the following parameters
*Ticker:* PME.AX
*Start Year:* 2017
*Start Month:* 12
*Start Day:* 1
*End Year:* 2017
*End Month:* 12
*End Day:* 30
*Period:* d
*Items:* DOHLCVA
*Names:* 1
*Adjust:* 1
*Resort:* 1
Does this happen to anyone else or is it just me doing something wrong?
cheers
Ian Rogers
Not sure why but when I use RCHGetYahooHistory for Australian stock PME.AX
(I'm also located in Australia) I get
26/12/2017 8.250 8.790 8.250 8.790 95,812.00
27/12/2017 8.900 8.990 8.600 8.790 49,942.00
28/12/2017 8.790 8.830 8.650 8.720 16,977.00
but when I look at https://finance.yahoo.com I get
Dec 29, 2017
8.79
8.83
8.65
8.72
16,977
Dec 28, 2017
8.90
8.99
8.60
8.79
49,942
Dec 27, 2017
8.25
8.79
8.25
8.79
95,812
I am using the latest version of SMF Add-in.
I get the same results when I look at https://au.finance.yahoo.com
I am using the following parameters
*Ticker:* PME.AX
*Start Year:* 2017
*Start Month:* 12
*Start Day:* 1
*End Year:* 2017
*End Month:* 12
*End Day:* 30
*Period:* d
*Items:* DOHLCVA
*Names:* 1
*Adjust:* 1
*Resort:* 1
Does this happen to anyone else or is it just me doing something wrong?
cheers
Ian Rogers
Sat Dec 30, 2017 3:59 pm (PST) . Posted by:
"Craig Passow" passow
As your investigation confirmed, the add-in can only download what the
data provider makes available. We're all at the mercy of outfits like
Yahoo and that is a recipe for frequent disappointment. You can try
reporting the issue to Yahoo, but I haven't seen any indication that
they pay any attention to such reports.
Here in the US, many of the mutual funds pay out their annual
distributions in December. They can be quite large and cause significant
discontinuities in the adjusted share price data until the data tables
reflect the distributions. That often takes several weeks to occur. It
happens often enough that I've setup a spreadsheet to splice the Yahoo
historical data with distribution information from Morningstar since
their site is updated in a much more timely fashion.
On 12/30/2017 1:16 AM, Ian Rogers irianr43@gmail.com [smf_addin] wrote:
>
> Hi All
>
> Not sure why but when I use RCHGetYahooHistory for Australian stock
> PME.AX <http://PME.AX> (I'm also located in Australia) I get
>
> 26/12/2017 8.250 8.790 8.250 8.790 95,812.00
> 27/12/2017 8..900 8..990 8..600 8..790 49,942.00
> 28/12/2017 8..790 8..830 8..650 8..720 16,977.00
>
>
> but when I look at https://finance.yahoo.com I get
>
>
> Dec 29, 2017
>
>
>
> 8.79
>
>
>
> 8.83
>
>
>
> 8.65
>
>
>
> 8.72
>
>
>
> 16,977
>
> Dec 28, 2017
>
>
>
> 8.90
>
>
>
> 8.99
>
>
>
> 8.60
>
>
>
> 8.79
>
>
>
> 49,942
>
> Dec 27, 2017
>
>
>
> 8.25
>
>
>
> 8.79
>
>
>
> 8.25
>
>
>
> 8.79
>
>
>
> 95,812
>
> *
> *
> I am using the latest version of SMF Add-in.
> I get the same results when I look at https://au.finance.yahoo..com
> <https://au.finance.yahoo.com>
>
> I am using the following parameters
>
> *Ticker:* PME.AX <http://PME.AX>
> *Start Year:* 2017
> *Start Month:* 12
> *Start Day:* 1
> *End Year:* 2017
> *End Month:* 12
> *End Day:* 30
> *Period:* d
> *Items:* DOHLCVA
> *Names:* 1
> *Adjust:* 1
> *Resort:* 1
>
> *
> *
>
> Does this happen to anyone else or is it just me doing something wrong?
>
> cheers
> Ian Rogers
>
>
>
>
>
data provider makes available. We're all at the mercy of outfits like
Yahoo and that is a recipe for frequent disappointment. You can try
reporting the issue to Yahoo, but I haven't seen any indication that
they pay any attention to such reports.
Here in the US, many of the mutual funds pay out their annual
distributions in December. They can be quite large and cause significant
discontinuities in the adjusted share price data until the data tables
reflect the distributions. That often takes several weeks to occur. It
happens often enough that I've setup a spreadsheet to splice the Yahoo
historical data with distribution information from Morningstar since
their site is updated in a much more timely fashion.
On 12/30/2017 1:16 AM, Ian Rogers irianr43@gmail.com [smf_addin] wrote:
>
> Hi All
>
> Not sure why but when I use RCHGetYahooHistory for Australian stock
> PME.AX <http://PME.AX> (I'm also located in Australia) I get
>
> 26/12/2017 8.250 8.790 8.250 8.790 95,812.00
> 27/12/2017 8..900 8..990 8..600 8..790 49,942.00
> 28/12/2017 8..790 8..830 8..650 8..720 16,977.00
>
>
> but when I look at https://finance.yahoo.com I get
>
>
> Dec 29, 2017
>
>
>
> 8.79
>
>
>
> 8.83
>
>
>
> 8.65
>
>
>
> 8.72
>
>
>
> 16,977
>
> Dec 28, 2017
>
>
>
> 8.90
>
>
>
> 8.99
>
>
>
> 8.60
>
>
>
> 8.79
>
>
>
> 49,942
>
> Dec 27, 2017
>
>
>
> 8.25
>
>
>
> 8.79
>
>
>
> 8.25
>
>
>
> 8.79
>
>
>
> 95,812
>
> *
> *
> I am using the latest version of SMF Add-in.
> I get the same results when I look at https://au.finance.yahoo..com
> <https://au.finance.yahoo.com>
>
> I am using the following parameters
>
> *Ticker:* PME.AX <http://PME.AX>
> *Start Year:* 2017
> *Start Month:* 12
> *Start Day:* 1
> *End Year:* 2017
> *End Month:* 12
> *End Day:* 30
> *Period:* d
> *Items:* DOHLCVA
> *Names:* 1
> *Adjust:* 1
> *Resort:* 1
>
> *
> *
>
> Does this happen to anyone else or is it just me doing something wrong?
>
> cheers
> Ian Rogers
>
>
>
>
>
Sat Dec 30, 2017 6:25 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Interesting. I'm just using the raw UNIX dates that are in the JSON data.
However, there is a another JSON field called gmtOffset. For PME.AX, that
value is 39600. For MMM, it's -18000. If I add the gmtOffset to the raw
UNIX date, it advances PME.AX from 11 pm on one day to 10 am on the next
day. Do Australian markets open at 10am? Because if I apply the gmtOffset
to MMM, it changes the raw UNIX date value from 2:30 pm to 9:30 am (when
the American market opens).
For American stocks, this gmtOffset value isn't enough to change the date.
But for Australian stocks, it appear to be important to advance to the
correct trading date.
I'll have to consider how I want to handle this?
On Sat, Dec 30, 2017 at 12:16 AM, Ian Rogers irianr43@gmail.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> Not sure why but when I use RCHGetYahooHistory for Australian stock PME.AX
> (I'm also located in Australia) I get
>
> 26/12/2017 8.250 8.790 8.250 8.790 95,812.00
> 27/12/2017 8.900 8.990 8.600 8.790 49,942.00
> 28/12/2017 8.790 8.830 8.650 8.720 16,977.00
>
> but when I look at https://finance.yahoo.com I get
>
>
> Dec 29, 2017
>
> 8.79
>
> 8.83
>
> 8.65
>
> 8.72
>
> 16,977
>
> Dec 28, 2017
>
> 8.90
>
> 8.99
>
> 8.60
>
> 8.79
>
> 49,942
>
> Dec 27, 2017
>
> 8.25
>
> 8.79
>
> 8.25
>
> 8.79
>
> 95,812
>
> I am using the latest version of SMF Add-in.
> I get the same results when I look at https://au.finance.yahoo.com
>
> I am using the following parameters
>
> *Ticker:* PME.AX
> *Start Year:* 2017
> *Start Month:* 12
> *Start Day:* 1
> *End Year:* 2017
> *End Month:* 12
> *End Day:* 30
> *Period:* d
> *Items:* DOHLCVA
> *Names:* 1
> *Adjust:* 1
> *Resort:* 1
>
>
> Does this happen to anyone else or is it just me doing something wrong?
>
>
>
However, there is a another JSON field called gmtOffset. For PME.AX, that
value is 39600. For MMM, it's -18000. If I add the gmtOffset to the raw
UNIX date, it advances PME.AX from 11 pm on one day to 10 am on the next
day. Do Australian markets open at 10am? Because if I apply the gmtOffset
to MMM, it changes the raw UNIX date value from 2:30 pm to 9:30 am (when
the American market opens).
For American stocks, this gmtOffset value isn't enough to change the date.
But for Australian stocks, it appear to be important to advance to the
correct trading date.
I'll have to consider how I want to handle this?
On Sat, Dec 30, 2017 at 12:16 AM, Ian Rogers irianr43@gmail.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
> Not sure why but when I use RCHGetYahooHistory for Australian stock PME.AX
> (I'm also located in Australia) I get
>
> 26/12/2017 8.250 8.790 8.250 8.790 95,812.00
> 27/12/2017 8.900 8.990 8.600 8.790 49,942.00
> 28/12/2017 8.790 8.830 8.650 8.720 16,977.00
>
> but when I look at https://finance.yahoo.com I get
>
>
> Dec 29, 2017
>
> 8.79
>
> 8.83
>
> 8.65
>
> 8.72
>
> 16,977
>
> Dec 28, 2017
>
> 8.90
>
> 8.99
>
> 8.60
>
> 8.79
>
> 49,942
>
> Dec 27, 2017
>
> 8.25
>
> 8.79
>
> 8.25
>
> 8.79
>
> 95,812
>
> I am using the latest version of SMF Add-in.
> I get the same results when I look at https://au.finance.yahoo.com
>
> I am using the following parameters
>
> *Ticker:* PME.AX
> *Start Year:* 2017
> *Start Month:* 12
> *Start Day:* 1
> *End Year:* 2017
> *End Month:* 12
> *End Day:* 30
> *Period:* d
> *Items:* DOHLCVA
> *Names:* 1
> *Adjust:* 1
> *Resort:* 1
>
>
> Does this happen to anyone else or is it just me doing something wrong?
>
>
>
Sat Dec 30, 2017 10:49 am (PST) . Posted by:
jhfrazer@ymail.com
Hello Randy,
Clearly I am losing my marbles. Is there a reason that this simple function which I have embedded in spreadsheets for years is no longer functioning? What is your current recommendation to grab a last price on a stock or etf.
Sorry to be so dense....
John
Clearly I am losing my marbles. Is there a reason that this simple function which I have embedded in spreadsheets for years is no longer functioning? What is your current recommendation to grab a last price on a stock or etf.
Sorry to be so dense....
John
Sat Dec 30, 2017 11:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It's because Yahoo pulled the plug on the API that the function uses two
months ago. They no longer provide a CSV file of current quotes data. See
the announcements blog:
https://smf-add-in.blogspot.com/
What I would suggest is upgrading the add-in to the latest release and
using the smfGetYahooPortfolioView() function -- documentation and a
template are on the web site (and mentioned in the announcements blog).
Note that if you are using a number of RCHGetYahooQuotes() functions, you
SHOULD get all of your quotes data in a single array-entered range with
smfGetYahooPortfolioView(), instead of getting data cell by cell.
On Sat, Dec 30, 2017 at 11:49 AM, jhfrazer@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Clearly I am losing my marbles. Is there a reason that this simple
> function which I have embedded in spreadsheets for years is no longer
> functioning? What is your current recommendation to grab a last price on a
> stock or etf.
>
> Sorry to be so dense....
>
>
months ago. They no longer provide a CSV file of current quotes data. See
the announcements blog:
https://smf-add-in.blogspot.com/
What I would suggest is upgrading the add-in to the latest release and
using the smfGetYahooPortfolioView() function -- documentation and a
template are on the web site (and mentioned in the announcements blog).
Note that if you are using a number of RCHGetYahooQuotes() functions, you
SHOULD get all of your quotes data in a single array-entered range with
smfGetYahooPortfolioView(), instead of getting data cell by cell.
On Sat, Dec 30, 2017 at 11:49 AM, jhfrazer@ymail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Clearly I am losing my marbles. Is there a reason that this simple
> function which I have embedded in spreadsheets for years is no longer
> functioning? What is your current recommendation to grab a last price on a
> stock or etf.
>
> Sorry to be so dense....
>
>
Sat Dec 30, 2017 2:46 pm (PST) . Posted by:
e_bartsch
Hi Randy:
I have a quick smfStrExtr question.
I'm visiting the barchart cheat-sheet site, found here:
https://www.barchart.com/stocks/quotes/mmm/cheat-sheet https://www.barchart.com/stocks/quotes/mmm/cheat-sheet
https://www.barchart.com/stocks/quotes/mmm/cheat-sheet
That returns data at my browser.
RCHGetWebData, using that site, brings the data into Excel, no problem.
However, when I attempt to pull data out of the string in one step, using this function:
=smfConvertData(smfStrExtr(RCHGetWebData("https://www.barchart.com/stocks/quotes/" & "MMM" & "/cheat-sheet","14 Day RSI at 30%",200),"""rawValue"":","}"))
It returns a blank. It seems like it is breaking at the smfStrExtr level.
Any ideas?
Thanks.
Eric
I have a quick smfStrExtr question.
I'm visiting the barchart cheat-sheet site, found here:
https://www.barchart.com/stocks/quotes/mmm/cheat-sheet https://www.barchart.com/stocks/quotes/mmm/cheat-sheet
https://www.barchart.com/stocks/quotes/mmm/cheat-sheet
That returns data at my browser.
RCHGetWebData, using that site, brings the data into Excel, no problem.
However, when I attempt to pull data out of the string in one step, using this function:
=smfConvertData(smfStrExtr(RCHGetWebData("https://www.barchart.com/stocks/quotes/" & "MMM" & "/cheat-
It returns a blank. It seems like it is breaking at the smfStrExtr level.
Any ideas?
Thanks.
Eric
Sat Dec 30, 2017 6:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The RCHGetWebData() function is returning raw source code, so the double
quotes you're using are "rawValue" aren't there in the source code. The web
page is using an HTML code instead of an actual quote. Try something like
this:
=smfStrExtr(RCHGetWebData("
https://www.barchart.com/stocks/quotes/MMM/cheat-sheet","14 Day RSI at
30%",200),"rawValue":","}",1)
I'm hoping the "& q u o t ;" (take out the blanks) doesn't get substituted
in this message with a double-quote symbol after "rawValue"...
PS: Note that the last "1" parameter in the smfStrExtr() function now does
an automatic conversion attempt, so the smfConvertData() function is no
longer needed. I added this parameter both to smfWord() and smfStrExtr(),
because I found myself using smfConvertData() so often. :)
On Sat, Dec 30, 2017 at 3:46 PM, eabartsch@
<eabartsch@comcast.net>.
..
wrote:
>
> I have a quick smfStrExtr question.
>
> I'm visiting the barchart cheat-sheet site, found here:
>
> https://www.barchart.com/stocks/quotes/mmm/cheat-sheet
>
> <https://www.barchart.com/stocks/quotes/mmm/cheat-sheet>
> That returns data at my browser.
>
> RCHGetWebData, using that site, brings the data into Excel, no problem..
>
> However, when I attempt to pull data out of the string in one step, using
> this function:
>
> =smfConvertData(smfStrExtr(
>
> RCHGetWebData(
>
> "https://www.barchart.com/stocks/quotes/" & "MMM" & "/cheat-sheet","14
> Day RSI at 30%",200),"""rawValue"":","}"))
>
> It returns a blank. It seems like it is breaking at the smfStrExtr level.
>
> Any ideas?
>
>
quotes you're using are "rawValue" aren't there in the source code. The web
page is using an HTML code instead of an actual quote. Try something like
this:
=smfStrExtr(RCHGetWebData("
https://www.barchart.com/stocks/quotes/MMM/cheat-sheet","14 Day RSI at
30%",200),"rawValue":","}",1)
I'm hoping the "& q u o t ;" (take out the blanks) doesn't get substituted
in this message with a double-quote symbol after "rawValue"...
PS: Note that the last "1" parameter in the smfStrExtr() function now does
an automatic conversion attempt, so the smfConvertData() function is no
longer needed. I added this parameter both to smfWord() and smfStrExtr(),
because I found myself using smfConvertData() so often. :)
On Sat, Dec 30, 2017 at 3:46 PM, eabartsch@
<eabartsch@comcast.net>.
..
wrote:
>
> I have a quick smfStrExtr question.
>
> I'm visiting the barchart cheat-sheet site, found here:
>
> https://www.barchart.com/stocks/quotes/mmm/cheat-sheet
>
> <https://www.barchart.com/stocks/quotes/mmm/cheat-sheet>
> That returns data at my browser.
>
> RCHGetWebData, using that site, brings the data into Excel, no problem..
>
> However, when I attempt to pull data out of the string in one step, using
> this function:
>
> =smfConvertData(smfStrExtr(
>
> RCHGetWebData(
>
> "https://www.barchart.com/stocks/quotes/" & "MMM" & "/cheat-
> Day RSI at 30%",200)
>
> It returns a blank. It seems like it is breaking at the smfStrExtr level.
>
> Any ideas?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar