Kamis, 02 April 2015

[smf_addin] Digest Number 3373

10 Messages

Digest #3373
1b
Re: Navellier Stock Grade by "Randy Harmelink" rharmelink
2a
WSJ Market Data by carmine288
2b
Re: WSJ Market Data by "Randy Harmelink" rharmelink
2c
Re: WSJ Market Data by carmine288
2d
Re: WSJ Market Data by "Randy Harmelink" rharmelink
3b
Re: OptionsTracker entry issue by "Randy Harmelink" rharmelink

Messages

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

carmine288

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

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

"Randy Harmelink" rharmelink

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.
>

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

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
>
>

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

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.
>
>

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?


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?
>

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

aconcogua98

its the only group I belong too

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

aconcogua98

Ok, I get it, no help here. the Options tracker spreadsheet must be supported somewhere else on Yahoo...
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar