Sorry, but no. Looks like the data is inaccessible to the add-in now.

On Wed, Apr 1, 2015 at 5:44 AM, carmine.nicoletta@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Does this still work after log-in and creating the IE security cookie?
> Thanks.
>

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

2a

WSJ Market Data

Wed Apr 1, 2015 5:59 am (PDT) . Posted by:

carmine288

How would I grab the 52wk high (211 stocks) and the 52wk low (68 stocks) for a given day:

http://online.wsj.com/mdc/public/page/2_3021-newhinyse-newhighs-20150318.html?mod=mdc_pastcalendar http://online.wsj.com/mdc/public/page/2_3021-newhinyse-newhighs-20150318.html?mod=mdc_pastcalendar

Thanks,
Carmine

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

2b

Re: WSJ Market Data

Wed Apr 1, 2015 8:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfStrExtr(RCHGetTableCell("
http://online.wsj.com/mdc/public/page/2_3021-newhinyse-newhighs-20150318.html?mod=mdc_pastcalendar",0,"New
52-Week Highs:"),":","~"))

=smfConvertData(smfStrExtr(RCHGetTableCell("
http://online.wsj.com/mdc/public/page/2_3021-newhinyse-newhighs-20150318.html?mod=mdc_pastcalendar",0,"New
52-Week LOws:"),":","~"))

On Wed, Apr 1, 2015 at 5:59 AM, carmine.nicoletta@... wrote:

> How would I grab the 52wk high (211 stocks) and the 52wk low (68
> stocks) for a given day:
>
>
> http://online.wsj.com/mdc/public/page/2_3021-newhinyse-newhighs-20150318.html?mod=mdc_pastcalendar
>
>

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

2c

Re: WSJ Market Data

Wed Apr 1, 2015 8:33 pm (PDT) . Posted by:

carmine288

Thanks Randy!

Your suggestion does grabs how many stocks hit 52 week high and lows.

But, I would like to be able to download the 211 52 wk hi tickers and 68 wk low tickers.

Thanks

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

2d

Re: WSJ Market Data

Wed Apr 1, 2015 9:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They're all in the same table, so this should work:

=RCHGetHTMLTable("
http://online.wsj.com/mdc/public/page/2_3021-newhinyse-newhighs-20150318.html
","Highs:",-1,"",1)

On Wed, Apr 1, 2015 at 8:33 PM, carmine.nicoletta@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> But, I would like to be able to download the 211 52 wk hi tickers and 68
> wk low tickers.
>
>

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

3a

OptionsTracker entry issue

Wed Apr 1, 2015 5:11 pm (PDT) . Posted by:

aconcogua98

When using the OptionsTracker spreadsheet, how would one go about selling 4 shares of a stock where you own 164 shares?

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

3b

Re: OptionsTracker entry issue

Wed Apr 1, 2015 5:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Do you have the correct Yahoo group?

On Wed, Apr 1, 2015 at 5:08 PM, aconcogua98@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> When using the OptionsTracker spreadsheet, how would one go about selling
> 4 shares of a stock where you own 164 shares?
>