6 Messages
Digest #4157
Messages
Mon Sep 25, 2017 8:53 pm (PDT) . Posted by:
holmberg_tommy
Hi Randy,
I'm getting stock prices from Reuters by using following formula:
='https://d.docs.live.net/SMF/RCH_Stock_Market_Functions.xla'!smfConvertData('https://d.docs.live.net/SMF/RCH_Stock_Market_Functions.xla'!smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol="&$G$2;"span";2;"sectionQuoteDetail"))
For some reason the command stopped working couple of days ago. Can you tell me what could be the reason?
BR, Tommy
I'm getting stock prices from Reuters by using following formula:
='https://d.docs.live.net/SMF/RCH_Stock_Market_Functions.xla'!smfConvertData('https://d.docs.live.net/SMF/RCH_Stock_Market_Functions.xla'!smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol="&$G$2;
For some reason the command stopped working couple of days ago. Can you tell me what could be the reason?
BR, Tommy
Mon Sep 25, 2017 10:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This works fine here:
=smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol=
"&$G$2,"span",2,"sectionQuoteDetail",,,,1)
The file locations you have in your formula mean you have location errors
that need to be resolved. I'm not sure you can have the add-in located
where you apparently have it.
On Mon, Sep 25, 2017 at 8:53 PM, holmberg_tommy@
...
wrote:
> I'm getting stock prices from Reuters by using following formula:
>
> ='https://d.docs.live.net/SMF/RCH_Stock_Market_Functions.
> xla'!smfConvertData('https://d.docs.live.net/SMF/RCH_Stock_
> Market_Functions.xla'!smfGetTagContent("http://www.
> reuters.com/finance/stocks/overview?symbol="&$G$2;"span";
> 2;"sectionQuoteDetail"))
>
> For some reason the command stopped working couple of days ago. Can you
> tell me what could be the reason?
>
>
>
=smfGetTagContent("http://www.reuters.com/finance/stocks/overview?symbol=
"&$G$2,"span",2,"sectionQuoteDetail",,,,1)
The file locations you have in your formula mean you have location errors
that need to be resolved. I'm not sure you can have the add-in located
where you apparently have it.
On Mon, Sep 25, 2017 at 8:53 PM, holmberg_tommy@
...
wrote:
> I'm getting stock prices from Reuters by using following formula:
>
> ='https://d.docs.live.net/SMF/RCH_Stock_Market_Functions.
> xla'!smfConvertData('https://d.docs.live.net/SMF/RCH_Stock_
> Market_Functions.xla'!smfGetTagContent("http://www.
> reuters.com/
> 2;"sectionQuot
>
> For some reason the command stopped working couple of days ago. Can you
> tell me what could be the reason?
>
>
>
Tue Sep 26, 2017 2:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Use the smfGetYahooHistory() function. For example, array-entered over a
7-row by 3-column range:
=smfGetYahooHistory("MMM",,,,"dcv")
Date Close Volume
2017-09-25 $210.91 677788
2017-09-22 $210.76 1442900
2017-09-21 $210.44 1382400
2017-09-20 $210.51 2987200
2017-09-19 $213.56 1429700
2017-09-18 $213.76 1272400
But it would be one function invocation for each ticker symbol. You
wouldn't want to do it on a lot of stocks.
On Mon, Sep 25, 2017 at 11:26 AM, ssztaba@
...
wrote:
>
> I'm using the RCHGetYahooQuotes routine to get the last prices on stocks.
>
> Is there a way to get the closing prices (and the corresponding volume)
> for the last 5 or 6 days ??
>
>
7-row by 3-column range:
=smfGetYahooHistory
Date Close Volume
2017-09-25 $210.91 677788
2017-09-22 $210.76 1442900
2017-09-21 $210.44 1382400
2017-09-20 $210.51 2987200
2017-09-19 $213.56 1429700
2017-09-18 $213.76 1272400
But it would be one function invocation for each ticker symbol. You
wouldn't want to do it on a lot of stocks.
On Mon, Sep 25, 2017 at 11:26 AM, ssztaba@
...
wrote:
>
> I'm using the RCHGetYahooQuotes routine to get the last prices on stocks.
>
> Is there a way to get the closing prices (and the corresponding volume)
> for the last 5 or 6 days ??
>
>
Tue Sep 26, 2017 11:37 am (PDT) . Posted by:
ssztaba
If I have 25 - 30 stocks, is there any efficient way to still get the "dcv" data ??
Tue Sep 26, 2017 1:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know of any way to reduce it to less than one Internet access per
equity.
You may be able to get the last 5 to 6 days of quotes (but not just date,
close, volume) from other sources. That may be faster than Yahoo, but not a
lot?
On Tue, Sep 26, 2017 at 11:37 AM, ssztaba@
...
wrote:
>
> If I have 25 - 30 stocks, is there any efficient way to still get the
> "dcv" data ??
>
equity.
You may be able to get the last 5 to 6 days of quotes (but not just date,
close, volume) from other sources. That may be faster than Yahoo, but not a
lot?
On Tue, Sep 26, 2017 at 11:37 AM, ssztaba@
...
wrote:
>
> If I have 25 - 30 stocks, is there any efficient way to still get the
> "dcv" data ??
>
Tue Sep 26, 2017 11:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Because they only show 5 quarters of data on the web site:
https://www.gurufocus.com/financials/MMM
I think they used to show more, when they had fewer annual periods.
If you need more, you can use the CSV file -- it has annual and quarterly
data back to 1987:
=smfGetCSVFile("
https://www.gurufocus.com/download_financials_in_CSV.php?symbol=IBM")
I've considered creating a function that could extract the data items from
that source instead of the web page...
On Tue, Sep 26, 2017 at 7:34 AM, JOSEPH CHUA <yongyap@
<yongyap@yahoo.com>.
..
> wrote:
>
> Why is it that quarterly I can only retrieve for the past 5 quarter using
> smf? It returns me N/A while my yearly data works fine.
>
https://www.gurufocus.com/financials/MMM
I think they used to show more, when they had fewer annual periods.
If you need more, you can use the CSV file -- it has annual and quarterly
data back to 1987:
=smfGetCSVFile("
https://www.gurufocus.com/download_financials_in_CSV.php?symbol=IBM")
I've considered creating a function that could extract the data items from
that source instead of the web page...
On Tue, Sep 26, 2017 at 7:34 AM, JOSEPH CHUA <yongyap@
<yongyap@yahoo.com>.
..
> wrote:
>
> Why is it that quarterly I can only retrieve for the past 5 quarter using
> smf? It returns me N/A while my yearly data works fine.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar