7 Messages
Digest #3972
Messages
Tue Apr 18, 2017 4:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yahoo items now require JSON extraction:
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketPrice"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketChange"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketChangePercent"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketTime"":"),":",","))
Just change the "post" to "pre" to get the pre-market values. The times are
UNIX times. To convert to EXCEL serial date/time:
=(F2-18000)/86400+ 25569
...but you may have to adjust for daylight savings time?
Google items, post-market:
=smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"span",-1,"_el""",,,,1)
=smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"span",-1,"_ec""",,,,1)
=smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"span",-1,"_ecp""")
=smfstrExtr(smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"div",-1,"_elt"""),"~","<")
On Tue, Apr 18, 2017 at 3:46 PM, dustinsmoak@
...wrote:
>
> I am trying to use an older sheet that I used to use the following to grab
> after-hours quotes from Yahoo and Google (formulas below), but they appear
> not to work. Can anyone point me to a formula that does work, or an
> alternative method of grabbing these prices within SMF? (I have just
> updated to the latest version of the add-in). Thanks.
>
> =smfGetTagContent("http://finance.yahoo.com/q?s="&D40,"
> span",-1,"yfs_l86_","")
>
> =
>
> smfGetTagContent("http://www.google.com/finance?q="&D40,"
> span",-1,"_el"">")
>
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketPrice"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketChange"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketChangePercent"":"),"""raw"":",","))
=smfConvertData(smfstrExtr(RCHGetWebData("http://finance.yahoo.com/quote/
"&$B2,"""postMarketTime"":"),":",","))
Just change the "post" to "pre" to get the pre-market values. The times are
UNIX times. To convert to EXCEL serial date/time:
=(F2-18000)/86400+ 25569
...but you may have to adjust for daylight savings time?
Google items, post-market:
=smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"span",-1,"_el""",,,,1)
=smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"span",-1,"_ec""",,,,1)
=smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"span",-1,"_ecp""")
=smfstrExtr(smfGetTagContent("http://www.google.com/finance?q=
"&$B10,"div",-1,"_elt"""),"~","<")
On Tue, Apr 18, 2017 at 3:46 PM, dustinsmoak@
...wrote:
>
> I am trying to use an older sheet that I used to use the following to grab
> after-hours quotes from Yahoo and Google (formulas below), but they appear
> not to work. Can anyone point me to a formula that does work, or an
> alternative method of grabbing these prices within SMF? (I have just
> updated to the latest version of the add-in). Thanks.
>
> =smfGetTagContent("http://finance.yahoo.com/q?s="&D40,"
> span",-1,"yfs_l86_","")
>
> =
>
> smfGetTagContent("http://www.google.com/finance?q="&D40,"
> span",-
>
Tue Apr 18, 2017 5:03 pm (PDT) . Posted by:
for30sqn
I have a 4 x 22 array that stopped working yesterday .The code in the array is =RCHGetYahooHistory(A2,,,,,,,,"DHLC") Blank cells now show up.
Other Smf-Addin functions continue to return good values , for example =RCHGetYahooQuotes(A2,"l1c1") =RCHGetYahooQuotes(A2,"r"), or =RCHGetYahooQuotes(A2,"n")
The spreadsheet computes Chandelier stops for me and I'd like to get it operating once again.
Repair suggestions would be appreciated.
Allen
Other Smf-Addin functions continue to return good values , for example =RCHGetYahooQuotes(
The spreadsheet computes Chandelier stops for me and I'd like to get it operating once again.
Repair suggestions would be appreciated.
Allen
Tue Apr 18, 2017 5:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you updated to the new version of the add-in that was announced two
days ago?
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31666
On Tue, Apr 18, 2017 at 5:03 PM, for30sqn@
...wrote:
> I have a 4 x 22 array that stopped working yesterday .The code in the
> array is =
>
> RCHGetYahooHistory(A2,,,,,,,,"DHLC";) Blank cells now show up.
>
> Other Smf-Addin functions continue to return good values , for example
> =RCHGetYahooQuotes(A2,"l1c1") =RCHGetYahooQuotes(A2,"r"), or
> =RCHGetYahooQuotes(A2,"n")
>
> The spreadsheet computes Chandelier stops for me and I'd like to get it
> operating once again.
>
> Repair suggestions would be appreciated.
>
days ago?
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/31666
On Tue, Apr 18, 2017 at 5:03 PM, for30sqn@
...wrote:
> I have a 4 x 22 array that stopped working yesterday .The code in the
> array is =
>
> RCHGetYahooHistory(
>
> Other Smf-Addin functions continue to return good values , for example
> =RCHGetYahooQuotes(
> =RCHGetYahooQuotes(
>
> The spreadsheet computes Chandelier stops for me and I'd like to get it
> operating once again.
>
> Repair suggestions would be appreciated.
>
Tue Apr 18, 2017 5:36 pm (PDT) . Posted by:
sirons1962
Randy thanks for all that you do with this add-in and keeping up with the changes.
The other day you updated some of the Yahoo elements in the elements-2 file and I had noticed elements 609-612 were coming up as ERROR on a sheet that I use. It is because Yahoo change the title from THIS YEAR to CURRENT YEAR.
I manually changed my elements-2 file and it now works. Thought you'd like to know to update the one that gets distributed.
Kind regards,
Steve
The other day you updated some of the Yahoo elements in the elements-2 file and I had noticed elements 609-612 were coming up as ERROR on a sheet that I use. It is because Yahoo change the title from THIS YEAR to CURRENT YEAR.
I manually changed my elements-2 file and it now works. Thought you'd like to know to update the one that gets distributed.
Kind regards,
Steve
Tue Apr 18, 2017 6:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks for the heads up. They'll be updated next time I upload the
definitions.
I also had to obsolete the PEG and P/E ratios, because they were dropped
from the web page
On Tue, Apr 18, 2017 at 5:36 PM, sirons1962@
...wrote:
> Randy thanks for all that you do with this add-in and keeping up with the
> changes.
>
> The other day you updated some of the Yahoo elements in the elements-2
> file and I had noticed elements 609-612 were coming up as ERROR on a sheet
> that I use. It is because Yahoo change the title from THIS YEAR to CURRENT
> YEAR.
>
> I manually changed my elements-2 file and it now works. Thought you'd like
> to know to update the one that gets distributed.
>
>
definitions.
I also had to obsolete the PEG and P/E ratios, because they were dropped
from the web page
On Tue, Apr 18, 2017 at 5:36 PM, sirons1962@
...wrote:
> Randy thanks for all that you do with this add-in and keeping up with the
> changes.
>
> The other day you updated some of the Yahoo elements in the elements-2
> file and I had noticed elements 609-612 were coming up as ERROR on a sheet
> that I use. It is because Yahoo change the title from THIS YEAR to CURRENT
> YEAR.
>
> I manually changed my elements-2 file and it now works. Thought you'd like
> to know to update the one that gets distributed.
>
>
Tue Apr 18, 2017 6:52 pm (PDT) . Posted by:
mokwit
Can anybody tell me how to change this to get it working again under new Yahoo protocol
=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & A1 & "&annual",1,"Period Ending","Adjustments To Net Income",,,,"Add to Portfolio")
everything using element numbers seems restored with new add in. Many thanks Randy
=RCHGetTableCell("https://ca.finance.yahoo.com/q/cf?s=" & A1 & "&annual"
everything using element numbers seems restored with new add in. Many thanks Randy
Tue Apr 18, 2017 7:00 pm (PDT) . Posted by:
mokwit
Just to add: I will try and work it out for myself but as I am in a 12 hour diametrically opposed time zone I thought I would ask the group before the US goes to sleep - just in case I can't work it out. TIA.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar