[smf_addin] Digest Number 4006

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4006

1a

Re: WSJ Dividend Declarations by carmine288

1b

Re: WSJ Dividend Declarations by "Randy Harmelink" rharmelink

2a

Last Updated Price - Marketwatch by sluk_2001

2b

Re: Last Updated Price - Marketwatch by "Randy Harmelink" rharmelink

Messages

1a

Re: WSJ Dividend Declarations

Mon May 15, 2017 6:22 am (PDT) . Posted by:

carmine288

I know.

But I wanted to control the date by a changing cell. Say Z1=20170509


Does this work for you?


=RCHGetHTMLTable("http://online.wsj.com/mdc/public/page/2_3022-dividends-"&Z1&".html?mod=mdc_pastcalendar",">INCREASED")



Thanks,

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

1b

Re: WSJ Dividend Declarations

Mon May 15, 2017 9:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your formula works for me, as long as Z1 contains a string (and I fix the
quotation marks). But if Z1 contains an EXCEL serial value, you need to use
the TEXT() function to format that date, as Craig showed you in his
message...

On Mon, May 15, 2017 at 6:22 AM, carmine.nicoletta@
​...wrote:

>
> But I wanted to control the date by a changing cell. Say Z1=
> ​​
> 20170509
>
> Does this work for you?
>
> =
> ​​
> ​​
> RCHGetHTMLTable("http://online.wsj.com/mdc/public/page/2_3022-dividends-
> "&Z1&".html?mod=mdc_pastcalendar",">INCREASED")
>
>
>

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

2a

Last Updated Price - Marketwatch

Mon May 15, 2017 6:40 pm (PDT) . Posted by:

sluk_2001

Hi Randy,


I'm having a hard time getting the last updated price quote and % change from Marketwatch.


I used to use the following formula (=0+smfGetTagContent("http://www.marketwatch.com/investing/fund/"&B10,"p",2,"lastprice")), but it stopped working, since the site changed.


Any clue how I can fix this? Thanks so much for your help!


Cheers,


Stephen

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

2b

Re: Last Updated Price - Marketwatch

Mon May 15, 2017 6:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Another site that has changed over to JSON data. However, the data does
appear to be in the META tags as well, so:

=smfConvertData(smfStrExtr(RCHGetWebData("http://www.
marketwatch.com/investing/fund/"&$D10,"name=""price""",
50),"content=""",""""))

=smfConvertData(smfStrExtr(RCHGetWebData("http://www.
marketwatch.com/investing/fund/"&$D10,"name=""priceChange""",50),"content=""
",""""))

=smfConvertData(smfStrExtr(RCHGetWebData("http://www.
marketwatch.com/investing/fund/"&$D10,"name=""priceChangePercent""",50),"
content=""",""""))

On Mon, May 15, 2017 at 6:40 PM, stephen.luk@
​...wrote:

> I'm having a hard time getting the last updated price quote and % change
> from Marketwatch.
>
> I used to use the following formula (=0+smfGetTagContent("http://
> www.marketwatch.com/investing/fund/"&B10,"p",2,"lastprice")), but it
> stopped working, since the site changed.
>
> Any clue how I can fix this? Thanks so much for your help!
>
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 13

• Privacy • Unsubscribe • Terms of Use