4 Messages
Digest #3951
Messages
Wed Mar 29, 2017 8:23 pm (PDT) . Posted by:
jbsergeant
This is a heads up for any Apple fans on this group. The most recent version of Numbers released in the last couple of days has natives support for stock and option prices as well as a whole host of stock statistics.
More info here:
https://support.apple.com/en-us/HT207109 https://support.apple.com/en-us/HT207109
and here:
https://support.apple.com/en-us/HT207244 https://support.apple.com/en-us/HT207244
More info here:
https://support.apple.com/en-us/HT207109 https://support.apple.com/en-us/HT207109
and here:
https://support.apple.com/en-us/HT207244 https://support.apple.com/en-us/HT207244
Thu Mar 30, 2017 4:19 pm (PDT) . Posted by:
eclipsme
I am trying to grab info from finance.yahoo. You helped me to get this working a while back, and I am grateful for that help!
Unfortunately, it has now stopped working. Although I am careful to log into yahoo finance with IE11, I get a blank sheet.
Here is the formula:
=RCHGetHTMLTable("https://finance.yahoo.com/portfolio/pf_1/view/v1", "VOLUME",-2, "",1 )
I had a -1 where now you have a -2. The only reason I could see for this was perhaps some 'th' markup, but I never did get to the bottom of that. It worked, well enough.
Along these lines, I have changed the range to be -3 and 2 - perhaps it would get something, but no, nothing.
What is the best way to troubleshoot this? Is there a way to see what, if anything, is being returned?
Again, thanks for these formulas and thanks for the help!
Harvey
Unfortunately, it has now stopped working. Although I am careful to log into yahoo finance with IE11, I get a blank sheet.
Here is the formula:
=RCHGetHTMLTable("https://finance.yahoo.com/portfolio/pf_1/view/v1", "VOLUME"
I had a -1 where now you have a -2. The only reason I could see for this was perhaps some 'th' markup, but I never did get to the bottom of that. It worked, well enough.
Along these lines, I have changed the range to be -3 and 2 - perhaps it would get something, but no, nothing.
What is the best way to troubleshoot this? Is there a way to see what, if anything, is being returned?
Again, thanks for these formulas and thanks for the help!
Harvey
Thu Mar 30, 2017 5:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Well, the first thing I notice is that if I click on your URL, I end up on
a different web page, so Yahoo is redirecting it. The Microsoft tool I use
to pull web page source code doesn't work well with redirection. I end up
here:
https://finance.yahoo.com/portfolio/p_0/view/v1
The next thing I do is use the SMF-Quick-Webpage-Examination.xls workbook.
If I go to the "By HTML Tag" worksheet and enter the above URL and ask for
"table" tags to be extracted, I find 3 of them. Then I can go to the "Table
Extract" worksheet and use that same URL, but leave the begin and end
string blank, and use "1" for the begin and end direction. That should
extract the first table. Then I try "2" and then I try "3" for the end
direction. I notice the table you want, but no data. The 2nd table should
be the quotes and the 3rd table is the headlines.
So now I go back to the web page and look at the source code to see if I
can find the problem. Hmmm. The table is there, so there must be something
preventing the add-in from parsing it properly. It's not designed to handle
anything other than simple table structure, so any glitches cause a
problem. Given the way Yahoo is now coding pages, I'm not really keen to
watch the parsing of the table line by line in the VBA code....
Can you parse it out table cell by table cell instead? For example, if I go
to the "By table Cell" worksheet and use the following parameters:
*Web Page: * https://finance.yahoo.com/portfolio/p_0/view/v1
*Find 1: * >SYMBOL
*Find 2: *
*Find 3: *
*Find 4: *
*End: * </table
...it seems to parse it out OK. So, you could use:
=RCHGetTableCell("https://finance.yahoo.com/portfolio/p_0/view/v1
",1,">SYMBOL",,,,1,"</table",,"--")
...varying the first "1" parameter for columns of data and the second "1"
parameter for rows of data.
On Thu, Mar 30, 2017 at 4:19 PM, harvey@
...
wrote:
>
> I am trying to grab info from finance.yahoo. You helped me to get this
> working a while back, and I am grateful for that help!
>
> Unfortunately, it has now stopped working. Although I am careful to log
> into yahoo finance with IE11, I get a blank sheet.
>
> Here is the formula:
> =RCHGetHTMLTable("https://finance.yahoo.com/portfolio/pf_1/view/v1",
> "VOLUME",-2, "",1 )
>
> I had a -1 where now you have a -2. The only reason I could see for this
> was perhaps some 'th' markup, but I never did get to the bottom of that. It
> worked, well enough.
>
> Along these lines, I have changed the range to be -3 and 2 - perhaps it
> would get something, but no, nothing.
>
> What is the best way to troubleshoot this? Is there a way to see what, if
> anything, is being returned?
>
> Again, thanks for these formulas and thanks for the help!
>
>
a different web page, so Yahoo is redirecting it. The Microsoft tool I use
to pull web page source code doesn't work well with redirection. I end up
here:
https://finance.yahoo.com/portfolio/p_0/view/v1
The next thing I do is use the SMF-Quick-Webpage-Examination.xls workbook.
If I go to the "By HTML Tag" worksheet and enter the above URL and ask for
"table" tags to be extracted, I find 3 of them. Then I can go to the "Table
Extract" worksheet and use that same URL, but leave the begin and end
string blank, and use "1" for the begin and end direction. That should
extract the first table. Then I try "2" and then I try "3" for the end
direction. I notice the table you want, but no data. The 2nd table should
be the quotes and the 3rd table is the headlines.
So now I go back to the web page and look at the source code to see if I
can find the problem. Hmmm. The table is there, so there must be something
preventing the add-in from parsing it properly. It's not designed to handle
anything other than simple table structure, so any glitches cause a
problem. Given the way Yahoo is now coding pages, I'm not really keen to
watch the parsing of the table line by line in the VBA code....
Can you parse it out table cell by table cell instead? For example, if I go
to the "By table Cell" worksheet and use the following parameters:
*Web Page: * https://finance.yahoo.com/portfolio/p_0/view/v1
*Find 1: * >SYMBOL
*Find 2: *
*Find 3: *
*Find 4: *
*End: * </table
...it seems to parse it out OK. So, you could use:
=RCHGetTableCell("https://finance.yahoo.com/portfolio/p_0/view/v1
",1,">SYMBOL",,,,1,"</table",,"--")
...varying the first "1" parameter for columns of data and the second "1"
parameter for rows of data.
On Thu, Mar 30, 2017 at 4:19 PM, harvey@
...
wrote:
>
> I am trying to grab info from finance.yahoo. You helped me to get this
> working a while back, and I am grateful for that help!
>
> Unfortunately, it has now stopped working. Although I am careful to log
> into yahoo finance with IE11, I get a blank sheet.
>
> Here is the formula:
> =RCHGetHTMLTable("https://finance.yahoo.com/portfolio/pf_1/view/v1",
> "VOLUME"
>
> I had a -1 where now you have a -2. The only reason I could see for this
> was perhaps some 'th' markup, but I never did get to the bottom of that. It
> worked, well enough.
>
> Along these lines, I have changed the range to be -3 and 2 - perhaps it
> would get something, but no, nothing.
>
> What is the best way to troubleshoot this? Is there a way to see what, if
> anything, is being returned?
>
> Again, thanks for these formulas and thanks for the help!
>
>
Thu Mar 30, 2017 6:39 pm (PDT) . Posted by:
eclipsme
wow! great reply. Thanks. I will have to look at this later and think on it pretty good. One thing I did notice is just now, when I clicked on the link I was also redirected, but the 2nd time I wasn't. I wonder if that has to do with logging in...
Anyway, thanks!
Anyway, thanks!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar