4 Messages
Digest #4141
1b
Re: Google Finance Historical Data Issue - last data Sept. 5, 2017 by "Randy Harmelink" rharmelink
Messages
Fri Sep 8, 2017 1:30 am (PDT) . Posted by:
burtonice00
No data for the past two days. https://www.google.com/finance/historical?q=NASDAQ:MSFT https://www.google.com/finance/historical?q=NASDAQ:MSFT
Anyone know if this is permanent?
I've been using smfGetCSVFile for google finance historical data.
Anyone know if this is permanent?
I've been using smfGetCSVFile for google finance historical data.
Fri Sep 8, 2017 1:52 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They've also removed the link for "Historical quotes" on the stocks' main
pages:
https://finance.google.com/finance?q=MSFT
On Fri, Sep 8, 2017 at 1:30 AM, burtonice00@
...
wrote:
> No data for the past two days. https://www.google.com/
> finance/historical?q=NASDAQ:MSFT
>
> Anyone know if this is permanent?
>
> I've been using smfGetCSVFile for google finance historical data.
>
pages:
https://finance.google.com/finance?q=MSFT
On Fri, Sep 8, 2017 at 1:30 AM, burtonice00@
...
wrote:
> No data for the past two days. https://www.google.com/
> finance/historical?
>
> Anyone know if this is permanent?
>
> I've been using smfGetCSVFile for google finance historical data.
>
Fri Sep 8, 2017 12:01 pm (PDT) . Posted by:
a.bereziuk
Hello,
GetYahooQuotes func can extract values of SMA50 and SMA200. Is it possible to extract the value of SMA90 ?
GetYahooQuotes func can extract values of SMA50 and SMA200. Is it possible to extract the value of SMA90 ?
Fri Sep 8, 2017 12:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32418
Personally, I don't use the Yahoo values. They compute them based on
unadjusted closing prices for the number of calendar days, not trading days.
Note that the cited solution would include the current day's closing price,
if Yahoo has that as the first day's "history". You could specify an ending
date if you want to avoid that. But don't use a volatile date function or
it will recalculate with every change to the worksheet -- see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31789
But then you also have to worry about whether the market is open or closed.
:(
The cited solution will also require an Internet access for each moving
average you compute.
I usually use the smfPricesByDates() function and look at price changes
instead. After all, the day-to-day change in moving averages is just a
change in one value -- the oldest day is just replaced by the newest day.
So the moving average only changes based on their difference, because all
the other prices stay the same.
TMI? Sorry. The devil is in the details...
On Fri, Sep 8, 2017 at 12:01 PM, a.bereziuk@
...
wrote:
>
> GetYahooQuotes func can extract values of SMA50 and SMA200. Is it possible
> to extract the value of SMA90 ?
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32418
Personally, I don't use the Yahoo values. They compute them based on
unadjusted closing prices for the number of calendar days, not trading days.
Note that the cited solution would include the current day's closing price,
if Yahoo has that as the first day's "history". You could specify an ending
date if you want to avoid that. But don't use a volatile date function or
it will recalculate with every change to the worksheet -- see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31789
But then you also have to worry about whether the market is open or closed.
:(
The cited solution will also require an Internet access for each moving
average you compute.
I usually use the smfPricesByDates(
instead. After all, the day-to-day change in moving averages is just a
change in one value -- the oldest day is just replaced by the newest day.
So the moving average only changes based on their difference, because all
the other prices stay the same.
TMI? Sorry. The devil is in the details...
On Fri, Sep 8, 2017 at 12:01 PM, a.bereziuk@
...
wrote:
>
> GetYahooQuotes func can extract values of SMA50 and SMA200. Is it possible
> to extract the value of SMA90 ?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar