3 Messages
Digest #3092
Messages
Fri Jun 13, 2014 1:11 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
There are a couple of numbers I'd like to have in my spreadsheet from
Gurufocus, but the way they are displayed on the webpage is making it
difficult to get them.
I'd like to grab the F-Score, Z-Score and M-Score, but they are displayed
with a colon, like so: F-Score: x.xx
I can't figure out if the colon is messing things up or the fact that it
looks like the number in question is in the same cell as the descriptor.
www.gurufocus.com/stock/mmm
On the Summary tab. I've tried both of these, and without the colon:
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:<")
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:")
(F43 is the cell with the ticker)
Any ideas please?
Thank you,
Jim
There are a couple of numbers I'd like to have in my spreadsheet from
Gurufocus, but the way they are displayed on the webpage is making it
difficult to get them.
I'd like to grab the F-Score, Z-Score and M-Score, but they are displayed
with a colon, like so: F-Score: x.xx
I can't figure out if the colon is messing things up or the fact that it
looks like the number in question is in the same cell as the descriptor.
www.gurufocus.com/stock/mmm
On the Summary tab. I've tried both of these, and without the colon:
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:<")
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,
(F43 is the cell with the ticker)
Any ideas please?
Thank you,
Jim
Fri Jun 13, 2014 1:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The string and the value are in the same cell, so try:
=smfConvertData(smfstrExtr(RCHGetTableCell("http://www.gurufocus.com/stock/
"&E8,0,">F-Score:"),":","~"))
On Fri, Jun 13, 2014 at 1:11 PM, 'Jim Ranum' amt2100@... wrote:
>
>
> There are a couple of numbers I'd like to have in my spreadsheet from
> Gurufocus, but the way they are displayed on the webpage is making it
> difficult to get them.
>
>
>
> I'd like to grab the F-Score, Z-Score and M-Score, but they are displayed
> with a colon, like so: F-Score: x.xx
>
> I can't figure out if the colon is messing things up or the fact that it
> looks like the number in question is in the same cell as the descriptor.
>
>
>
> www.gurufocus.com/stock/mmm
>
> On the Summary tab. I've tried both of these, and without the colon:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:<")
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:")
>
> (F43 is the cell with the ticker)
>
>
>
> Any ideas please?
>
>
>
=smfConvertData(smfstrExtr(RCHGetTableCell("http://www.gurufocus.com/stock/
"&E8,0,">F-Score:"),":","~"))
On Fri, Jun 13, 2014 at 1:11 PM, 'Jim Ranum' amt2100@... wrote:
>
>
> There are a couple of numbers I'd like to have in my spreadsheet from
> Gurufocus, but the way they are displayed on the webpage is making it
> difficult to get them.
>
>
>
> I'd like to grab the F-Score, Z-Score and M-Score, but they are displayed
> with a colon, like so: F-Score: x.xx
>
> I can't figure out if the colon is messing things up or the fact that it
> looks like the number in question is in the same cell as the descriptor.
>
>
>
> www.gurufocus.com/stock/mmm
>
> On the Summary tab. I've tried both of these, and without the colon:
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:<")
>
> =RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,
>
> (F43 is the cell with the ticker)
>
>
>
> Any ideas please?
>
>
>
Fri Jun 13, 2014 1:48 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Worked perfectly.
Awesome. Thanks Randy.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 13, 2014 4:35 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus question
The string and the value are in the same cell, so try:
=smfConvertData(smfstrExtr(RCHGetTableCell("http://www.gurufocus.com/stock/"&E8,0,">F-Score:"),":","~"))
On Fri, Jun 13, 2014 at 1:11 PM, 'Jim Ranum' amt2100@... wrote:
There are a couple of numbers I'd like to have in my spreadsheet from Gurufocus, but the way they are displayed on the webpage is making it difficult to get them.
I'd like to grab the F-Score, Z-Score and M-Score, but they are displayed with a colon, like so: F-Score: x.xx
I can't figure out if the colon is messing things up or the fact that it looks like the number in question is in the same cell as the descriptor.
www.gurufocus.com/stock/mmm
On the Summary tab. I've tried both of these, and without the colon:
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:<")
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:")
(F43 is the cell with the ticker)
Any ideas please?
Awesome. Thanks Randy.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, June 13, 2014 4:35 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus question
The string and the value are in the same cell, so try:
=smfConvertData(smfstrExtr(RCHGetTableCell("http://www.gurufocus.com/stock/"&E8,0,">F-Score:"),":","~"))
On Fri, Jun 13, 2014 at 1:11 PM, 'Jim Ranum' amt2100@... wrote:
There are a couple of numbers I'd like to have in my spreadsheet from Gurufocus, but the way they are displayed on the webpage is making it difficult to get them.
I'd like to grab the F-Score, Z-Score and M-Score, but they are displayed with a colon, like so: F-Score: x.xx
I can't figure out if the colon is messing things up or the fact that it looks like the number in question is in the same cell as the descriptor.
www.gurufocus.com/stock/mmm
On the Summary tab. I've tried both of these, and without the colon:
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,1,">F-Score:<")
=RCHGetTableCell("http://www.gurufocus.com/stock/"&$F$43,
(F43 is the cell with the ticker)
Any ideas please?
Tidak ada komentar:
Posting Komentar