5 New Messages

Digest #2308

ETF Put Option Prices by "adam_sommers" adam_sommers

Re: ETF Put Option Prices by "Randy Harmelink" rharmelink

Reuters by "tldavidson1" tldavidson1

Re: Reuters by "Randy Harmelink" rharmelink

Excel Worksheet by "ufdn16" ufdn16

Messages

1a

I have been using the smfGetYahooOptionQuote function to pull put option prices into my worksheet, but this morning, all of the stock put prices came in, but the ETF put pricing did not. Any ideas? I'm trying to pull put prices for SPY, XLE, XLK, etc. It has worked for years...is it Yahoo, or is it me?

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

1b

Re: ETF Put Option Prices

Wed Aug 8, 2012 1:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would suspect it was a problem with Yahoo, but without specific examples
it would be impossible to tell.

Are you still having problems?

I quite often have issues with Yahoo on the weekly options, since they
don't update as they become available.

On Wed, Aug 8, 2012 at 9:42 AM, adam_sommers <adam@sommersfinancial.com>wrote:

> I have been using the smfGetYahooOptionQuote function to pull put option
> prices into my worksheet, but this morning, all of the stock put prices
> came in, but the ETF put pricing did not. Any ideas? I'm trying to pull
> put prices for SPY, XLE, XLK, etc. It has worked for years...is it Yahoo,
> or is it me?
>

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

2a

Reuters

Wed Aug 8, 2012 2:20 pm (PDT) . Posted by:

"tldavidson1" tldavidson1

Is anyone else having trouble with the Reuters Website Data. Even if I use the simple formula from the reuters template below I get an error.

I am using Version 2.1.2012.07.12

=RCHGetElementNumber(Ticker,13626)where Ticker="F"

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

2b

Re: Reuters

Wed Aug 8, 2012 2:28 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's a problem with Reuters -- hopefully a temporary one -- if you look at
this page:

http://www.reuters.com/finance/stocks/financialHighlights?symbol=F

Note that none of the "Valuation Ratios", "Dividends", "Financial
Strengths", etc. sections have been filled in with data...

On Wed, Aug 8, 2012 at 2:20 PM, tldavidson1 <Tom@davidson-engineering.com>wrote:

> Is anyone else having trouble with the Reuters Website Data. Even if I
> use the simple formula from the reuters template below I get an error.
>
> I am using Version 2.1.2012.07.12
>
> =RCHGetElementNumber(Ticker,13626)where Ticker="F"
>

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

3 Excel Worksheet

Thu Aug 9, 2012 3:50 am (PDT) . Posted by:

"ufdn16" ufdn16

I'm using an excel worksheet with many references to element numbers. It works just fine but when I open the file it begins to recalculate. This process takes a few minutes. Is there a way to speed this process up.