4 Messages

Digest #3008

Re: RCHGetYahooHistory Update Issue by boo1712

Re: retrieve previous close by lawleesh

Re: retrieve previous close by "Randy Harmelink" rharmelink

Re: retrieve previous close by lawleesh

Messages

1a

Re: RCHGetYahooHistory Update Issue

Mon Mar 17, 2014 1:00 am (PDT) . Posted by:

boo1712

Hi, Dun know whether this is what you wanted.
You can turn off auto update for your spreadsheet (in formula tab, calculation option, set to to manual)

Then you can manually calculate only the worksheet/s that you want.

You can also use macro to calculate the sheets that you require.

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

2a

Re: retrieve previous close

Mon Mar 17, 2014 4:21 pm (PDT) . Posted by:

lawleesh

Hi Randy
When I change the security, how come the price doesn't come out?
=smfConvertData(smfstrExtr(smfGetTagContent("http://www.marketwatch.com/investing/Stock/c6L/analystestimates?countrycode=SG","p",1,">Previous Close"),"~","<"))
thanks
LL

Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^

2b

Re: retrieve previous close

Mon Mar 17, 2014 4:51 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your smfGetTagContent() function is returning:

<span class="currency">$</span> 10.20

Your smfStrExtr() function says to extract data from the beginning of that
to the first "<". Instead, it looks like you should extract from the
"span>" to the end of the string. So, this should work:

=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/c6L/analystestimates?countrycode=SG","p",1,">Previous
Close"),"span>","~"))

The difference is that your UK extraction had the currency code AFTER the
amount, while the US extraction has the currency code BEFORE the amount. It
appears a universal extraction would need to remove the currency type --
not trivial. But these appear to work:

=smfConvertData(SUBSTITUTE(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/c6L/analystestimates?countrycode=SG","p",1,">Previous
Close"),"<span"&smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/c6L/analystestimates?countrycode=SG","p",1,">Previous
Close"),"<span","span>")&"span>",""))

=smfConvertData(SUBSTITUTE(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK","p",1,">Previous
Close"),"<span"&smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/3IN/analystestimates?countrycode=UK","p",1,">Previous
Close"),"<span","span>")&"span>",""))

On Mon, Mar 17, 2014 at 4:21 PM, <lawrence.leesh@gmail.com> wrote:

>
> When I change the security, how come the price doesn't come out?
>
> =smfConvertData(smfstrExtr(smfGetTagContent("
> http://www.marketwatch.com/investing/Stock/c6L/analystestimates?countrycode=SG","p",1,">Previous
> Close"),"~","<"))
>
>