Senin, 10 Agustus 2015

[smf_addin] Digest Number 3480[1 Attachment]

5 Messages

Digest #3480
3a
Re: Ebay options by sushiwaitress
3b
Re: Ebay options by "Randy Harmelink" rharmelink

Messages

Sun Aug 9, 2015 8:33 am (PDT) . Posted by:

sjagers

On each Friday, I track prices for each of the stocks in the S&P 500.

I track today's Open, High, Low, Close and Volume, and the Closing prices for yesterday, 2 days ago, 5 days ago, 10 days ago, 20 days ago, and 50 days ago. A snapshot of a portion of my spreadsheet is attached.

Any suggestion on which one, or combination, of the Stock Market functions would be the fastest to retrieve these? (GetYahooHistory, PricesByDate, Last Price, etc.)

Thanks for your help.


Steve

Attachment(s) from
1 of 1 Photo(s)

Sun Aug 9, 2015 8:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I think the fastest would be:

-- Three RCHGetYahooQuotes() functions to get the current day's information
(200 tickers per function).
-- 500 smfPricesByDates() functions, one for each ticker symbol.

On Sun, Aug 9, 2015 at 8:33 AM, sjagers@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> On each Friday, I track prices for each of the stocks in the S&P 500.
>
> I track today's Open, High, Low, Close and Volume, and the Closing prices
> for yesterday, 2 days ago, 5 days ago, 10 days ago, 20 days ago, and 50
> days ago. A snapshot of a portion of my spreadsheet is attached.
>
> Any suggestion on which one, or combination, of the Stock Market functions
> would be the fastest to retrieve these? (GetYahooHistory, PricesByDate,
> Last Price, etc.)
>

Sun Aug 9, 2015 2:47 pm (PDT) . Posted by:

sushiwaitress

Randy, Bill,
I've noticed that in the past couple days I'm unable to fetch pricing for nonstandard options (e.g. EBAY Jan 2016 Calls, post the PayPal spinoff).

I can't even find the data on Yahoo Finance or Google Finance, although I did find it on the Nasdaq website.
EBAY Option Chain http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3

http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3

EBAY Option Chain http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3 eBay Inc. (EBAY) Options Chain - Get free stock options quotes including option chains with call and put prices, viewable by expiration date, most active, and mo...



View on www.nasdaq.com http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3
Preview by Yahoo



I saw the other messages in this thread (re: hard-coding the behavior of the RCHGetOptionsQuotes function) and wondered if there's a way to do the same using the NASDAQ URL that contains the data.

Any ideas?

Ruth

Sun Aug 9, 2015 2:47 pm (PDT) . Posted by:

sushiwaitress

Aha. Yes, I have the same problem.

I found the data on the NASDAQ website, but it's not on Yahoo or Google finance.

That's a good point about waiting a little longer. Maybe they'll eventually get the data. I didn't think about that. I just automatically assumed I'd have to wait until the option expires in order to get my spreadsheet to work again..

EBAY Option Chain http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3

http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3

EBAY Option Chain http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3 eBay Inc. (EBAY) Options Chain - Get free stock options quotes including option chains with call and put prices, viewable by expiration date, most active, and mo...



View on www.nasdaq.com http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3
Preview by Yahoo



Is there any way to add Nasdaq in as a data source? (or is that complex/costly/time-consuming?)

Sun Aug 9, 2015 4:09 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That web page would be a terror to automate. It uses a dateindex instead of
a date, so you'd need to know how many expiration dates the equity has, and
how your desired expiration date fits into them sequentially. And it uses
multiple pages instead of a single scrolling page. It would be easier to go
to the individual contract web page:

http://www.nasdaq.com/symbol/ebay/option-chain/160115C00060000-ebay1-call

For example, last price would be:

=smfConvertData(smfGetTagContent("
http://www.nasdaq.com/symbol/ebay/option-chain/160115C00060000-ebay1-call","b",1,">Last
Sale"))

That web page also has the greeks for the contract...

On Sun, Aug 9, 2015 at 12:21 PM, ruth_debardeleben@...wrote:

>
> Aha. Yes, I have the same problem.
>
> I found the data on the NASDAQ website, but it's not on Yahoo or Google
> finance.
>
> That's a good point about waiting a little longer. Maybe they'll
> eventually get the data. I didn't think about that. I just automatically
> assumed I'd have to wait until the option expires in order to get my
> spreadsheet to work again..
>
> EBAY Option Chain
> <http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3>
> [image: image]
> <http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3>
> EBAY Option Chain
> <http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3>
> eBay Inc. (EBAY) Options Chain - Get free stock options quotes including
> option chains with call and put prices, viewable by expiration date, most
> active, and mo...
> View on www.nasdaq.com
> <http://www.nasdaq.com/symbol/ebay/option-chain?money=all&dateindex=3>
> Preview by Yahoo
>
>
> Is there any way to add Nasdaq in as a data source? (or is that
> complex/costly/time-consuming?)
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.15

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)