Sabtu, 27 Oktober 2012

[smf_addin] Digest Number 2385

4 New Messages

Digest #2385

Messages

Fri Oct 26, 2012 4:24 am (PDT) . Posted by:

"zbgb952" zbgb952

Hello Randy,

This value still exists at msn stock scouter..see example below.
Do you have a rchgetelement number for this? I couldn't find it.
thanks.

http://investing.money.msn.com/investments/stockscouter-top-rated-stocks?sco=10

Fri Oct 26, 2012 4:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

An element wouldn't make sense there, since the page isn't generated by
ticker symbol.

That page used to work, then stopped working, but appears to work again.

You can retrieve the entire table with:

=RCHGetHTMLTable("
http://investing.money.msn.com/investments/stockscouter-top-rated-stocks?sco=10","
Company Name ",1,"",2)

On Thu, Oct 25, 2012 at 11:43 PM, zbgb952 <mb0329@msn.com> wrote:

>
> This value still exists at msn stock scouter..see example below.
> Do you have a rchgetelement number for this? I couldn't find it.
> thanks.
>
>
> http://investing.money.msn.com/investments/stockscouter-top-rated-stocks?sco=10
>

Fri Oct 26, 2012 10:56 am (PDT) . Posted by:

"David" copthornelabs

Randy,

Two questions:
1. How do I get this table to actually return prices using =smfGetOptionQuotes("",D$7,1)in the array?
2.If i want put prices as well as calls hw best to set up the sheet?

aapl   <=== Ticker Symbol of Underlying Equity
ox   <=== Data Source to use for Retrieving Data

2012-11-17 <=== Option expiration to use for table below

l b a
Tickers Last Price
AAPL 11/17 2012 $575.00 Call
AAPL 11/17 2012 $580.00 Call
AAPL 11/17 2012 $585.00 Call
AAPL 11/17 2012 $590.00 Call
AAPL 11/17 2012 $595.00 Call
AAPL 11/17 2012 $600.00 Call
AAPL 11/17 2012 $605.00 Call
AAPL 11/17 2012 $610.00 Call
AAPL 11/17 2012 $615.00 Call
AAPL 11/17 2012 $620.00 Call

$595.00 <=== Strike price to use for table below

l b a
Tickers Last Price
AAPL 10/26 2012 $595.00 Call
AAPL 11/2 2012 $595.00 Call
AAPL 11/17 2012 $595.00 Call
AAPL 12/22 2012 $595.00 Call
AAPL 1/19 2013 $595.00 Call
AAPL 2/16 2013 $595.00 Call
AAPL 3/16 2013 $595.00 Call
AAPL 4/20 2013 $595.00 Call

Fri Oct 26, 2012 11:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

As per the documentation:

=smfGetOptionQuotes(_tickerrange_, _itemrange_, , _datasource_)

How you want to get puts would depend on how you want to see them relative
to the calls. You can either do them side-by-side with the calls or stacked
on top of the calls.

On Fri, Oct 26, 2012 at 10:56 AM, David <davecharlaff@hotmail.com> wrote:

>
> Two questions:
> 1. How do I get this table to actually return prices using
> =smfGetOptionQuotes("",D$7,1)in the array?
> 2.If i want put prices as well as calls hw best to set up the sheet?
>
> aapl <=== Ticker Symbol of Underlying Equity
> ox <=== Data Source to use for Retrieving Data
>
> 2012-11-17 <=== Option expiration to use for table below
>
> l b a
> Tickers Last Price
> AAPL 11/17 2012 $575.00 Call
> AAPL 11/17 2012 $580.00 Call
> AAPL 11/17 2012 $585.00 Call
> AAPL 11/17 2012 $590.00 Call
> AAPL 11/17 2012 $595.00 Call
> AAPL 11/17 2012 $600.00 Call
> AAPL 11/17 2012 $605.00 Call
> AAPL 11/17 2012 $610.00 Call
> AAPL 11/17 2012 $615.00 Call
> AAPL 11/17 2012 $620.00 Call
>
> $595.00 <=== Strike price to use for table below
>
> l b a
> Tickers Last Price
> AAPL 10/26 2012 $595.00 Call
> AAPL 11/2 2012 $595.00 Call
> AAPL 11/17 2012 $595.00 Call
> AAPL 12/22 2012 $595.00 Call
> AAPL 1/19 2013 $595.00 Call
> AAPL 2/16 2013 $595.00 Call
> AAPL 3/16 2013 $595.00 Call
> AAPL 4/20 2013 $595.00 Call
>
Diposting oleh EXCEL FEED LEARNING di 02.57

1 komentar:

Federico mengatakan...

There are also other sources for great stock tips. Look around in the web. One, for instance, is the following: http://www.mystocktobuy.com.

Kind regards, Fredrick

10 Mei 2013 pukul 02.49

Posting Komentar

Langganan: Posting Komentar (Atom)