6 Messages
Digest #4050
Messages
Sun Jun 4, 2017 8:01 pm (PDT) . Posted by:
cb4gusto22
Thanks, Randy! I really appreciate your response. Hopefully Yahoo will get it together at some point soon. I'll be paying attention. Thanks!
Mon Jun 5, 2017 12:57 am (PDT) . Posted by:
ajtalukdar
Hi Randy,
The changes at Yahoo have also affected retrieveal of the Stock Split History data from Yahoo. This was working fine earlier as well.
I therefore tried my hand at fetching stock split data from splithistory.com. The attached Excel file shows my attempt. But I am not able to get it to work for some reason.
Can I request you to look at this and tell me the fix? Appreciate all your efforts and your time to the community.
Best
Abhijit
The changes at Yahoo have also affected retrieveal of the Stock Split History data from Yahoo. This was working fine earlier as well.
I therefore tried my hand at fetching stock split data from splithistory.
Can I request you to look at this and tell me the fix? Appreciate all your efforts and your time to the community.
Best
Abhijit
Attachment(s) from
1 of 1 File(s)
Mon Jun 5, 2017 1:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The first problem is that the string you're searching for doesn't exist
within the source code of the web page. The table header is actually coded
as "IBM Split History</b> Table". However, they've got tables coded within
tables, and RCHGetHTMLTable() is just a simple extraction function, so the
coding is too advanced for it.
You can get the data you want by doing RCHGetTableCell() functions,
grabbing them one cell at a time. For example:
=RCHGetTableCell("https://www.splithistory.com/?symbol=IBM
",1,">Ratio",,,,1,"</table")
=RCHGetTableCell("https://www.splithistory.com/?symbol=IBM
",2,">Ratio",,,,1,"</table")
Just iterate that last "1" parameter from "1" to "n" for the rows of the
table. You'll get "Error" when the table is done.
On Mon, Jun 5, 2017 at 12:57 AM, ajtalukdar@
...
wrote:
>
> The changes at Yahoo have also affected retrieveal of the Stock Split
> History data from Yahoo. This was working fine earlier as well.
>
> I therefore tried my hand at fetching stock split data from
> splithistory.com. The attached Excel file shows my attempt. But I am not
> able to get it to work for some reason.
>
> Can I request you to look at this and tell me the fix? Appreciate all your
> efforts and your time to the community.
>
>
within the source code of the web page. The table header is actually coded
as "IBM Split History</b> Table". However, they've got tables coded within
tables, and RCHGetHTMLTable() is just a simple extraction function, so the
coding is too advanced for it.
You can get the data you want by doing RCHGetTableCell() functions,
grabbing them one cell at a time. For example:
=RCHGetTableCell("https://www.splithistory.com/?symbol=IBM
",1,">Ratio",,,,1,"</table")
=RCHGetTableCell("https://www.splithistory.com/?symbol=IBM
",2,"
Just iterate that last "1" parameter from "1" to "n" for the rows of the
table. You'll get "Error" when the table is done.
On Mon, Jun 5, 2017 at 12:57 AM, ajtalukdar@
...
wrote:
>
> The changes at Yahoo have also affected retrieveal of the Stock Split
> History data from Yahoo. This was working fine earlier as well.
>
> I therefore tried my hand at fetching stock split data from
> splithistory.
> able to get it to work for some reason.
>
> Can I request you to look at this and tell me the fix? Appreciate all your
> efforts and your time to the community.
>
>
Mon Jun 5, 2017 6:27 pm (PDT) . Posted by:
msimmsx
Randy -
Let us know ASAP when the historical quotes in JSON format has stabilized.
Let us know ASAP when the historical quotes in JSON format has stabilized.
Mon Jun 5, 2017 1:27 pm (PDT) . Posted by:
palminha
Hi Randy,
The RCHGetElementNumber 13863 gives error is there any other way to get company name?
Thank You!
The RCHGetElementNumber 13863 gives error is there any other way to get company name?
Thank You!
Mon Jun 5, 2017 5:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Working fine here:
Ticker 13863
MMM 3M Company Common Stock
VFINX Vanguard Index Trust 500 Index
SPY SPDR S&P 500
Definition Yahoo;Company Name;=smfStrExtr(smfGetTagContent("
https://finance.yahoo.com/q?s=~~~~~","title"),"Summary for ","-")
Check your definition, you may need an update of the element definition?
There were changed to "https://" a while back. Otherwise, you can always
use:
=RCHGetYahooQuotes("MMM","n")
On Mon, Jun 5, 2017 at 1:27 PM, palminha@
...
wrote:
>
> The RCHGetElementNumber 13863 gives error is there any other way to get
> company name?
>
>
Ticker 13863
MMM 3M Company Common Stock
VFINX Vanguard Index Trust 500 Index
SPY SPDR S&P 500
Definition Yahoo;Company Name;=smfStrExtr(smfGetTagContent("
https://finance.yahoo.com/q?s=~~~~~","
Check your definition, you may need an update of the element definition?
There were changed to "https:
use:
=RCHGetYahooQuotes(
On Mon, Jun 5, 2017 at 1:27 PM, palminha@
...
wrote:
>
> The RCHGetElementNumber 13863 gives error is there any other way to get
> company name?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar