Rabu, 10 September 2014

[smf_addin] Digest Number 3174

15 Messages

Digest #3174
4b
Re: smfGetTagContent for title returning error by "Randy Harmelink" rharmelink

Messages

Wed Sep 10, 2014 4:57 am (PDT) . Posted by:

"David Rossien" drrossien

This may be what you're looking for:
http://investexcel.net/all-yahoo-finance-stock-tickers/

Wed Sep 10, 2014 8:26 am (PDT) . Posted by:

joshi_mandar

Hi Randy


I believe you had changed the add-in tool to handle non-standard options quotes from yahoo. Because of that change, I was able to use following formula in my spreadsheet.


=smfGetOptionQuotes("faz1 Jan 15 13 call","l",0,"Y")



However, for past few days above formula has not been working. I suspected the problem was at yahoo's end. Because other option quotes work fine. Just the non-standard ones don't work. Could you confirm that the problem is at yahoo's end?


Following formula still works. But it is little bit cumbersome to use that formula.


=RCHGetTableCell("http://finance.yahoo.com/q/op?s=FAZ&m=2015-01",1,"FAZ1150117C00013000")







Wed Sep 10, 2014 8:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. I don't have an error that I can investigate. Your formula works fine
for me:

=smfGetOptionQuotes("faz1 Jan 15 13 call","l",0,"Y")

It returns the value I see on the web page. What version of the add-in are
you using:

=RCHGetElementNumber("Version")

On Wed, Sep 10, 2014 at 8:24 AM, joshi_mandar@...wrote:

>
> I believe you had changed the add-in tool to handle non-standard options
> quotes from yahoo. Because of that change, I was able to use following
> formula in my spreadsheet.
>
> =smfGetOptionQuotes("faz1 Jan 15 13 call","l",0,"Y")
>
> However, for past few days above formula has not been working. I
> suspected the problem was at yahoo's end. Because other option quotes work
> fine. Just the non-standard ones don't work. Could you confirm that the
> problem is at yahoo's end?
>
> Following formula still works. But it is little bit cumbersome to use
> that formula.
>
> =RCHGetTableCell("http://finance.yahoo.com/q/op?s=FAZ&m=2015-01
> ",1,"FAZ1150117C00013000")
>
>

Wed Sep 10, 2014 8:50 am (PDT) . Posted by:

joshi_mandar

I am using this:

Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\SMF Add-In; 1)



Wed Sep 10, 2014 8:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "non-standard" options changes were made in June of 2013, so your
version wouldn't have those changes...

You would need to install a later version of the add-in.

On Wed, Sep 10, 2014 at 8:50 AM, joshi_mandar@... wrote:

>
> I am using this:
>
> Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\SMF Add-In; 1)
>
>

Wed Sep 10, 2014 9:20 am (PDT) . Posted by:

joshi_mandar

Thanks Randy. I have updated the version of the add-in. That worked in my test excel spreadsheet. However, I am getting following error now in my main excel spreadsheet where I am using arrays for getting stock quotes.

"Sorry, the Yahoo Finance system limits quotes to 200 ticker symbols at a time, and your request included 498ticker symbols. Please adjust your request to include 200 or less."


Is that check a recent addition to the add-in? I didn't get that error before.

Wed Sep 10, 2014 9:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

No. Yahoo has always limited the CSV file to 200 ticker symbols. At least
as long as I've been using it (15 years?). That CSV file is used by
RCHGetYahooQuotes().

I don't know why you wouldn't have gotten the error before. That message
comes from Yahoo, not from the add-in.

Just create multiple function invocations, 200 per invocation.

On Wed, Sep 10, 2014 at 9:20 AM, joshi_mandar@...wrote:

>
> Thanks Randy. I have updated the version of the add-in. That worked in
> my test excel spreadsheet. However, I am getting following error now in my
> main excel spreadsheet where I am using arrays for getting stock quotes.
> "Sorry, the Yahoo Finance system limits quotes to 200 ticker symbols at a
> time, and your request included 498ticker symbols. Please adjust your
> request to include 200 or less."
>
> Is that check a recent addition to the add-in? I didn't get that error
> before.
>

Wed Sep 10, 2014 9:20 am (PDT) . Posted by:

ronaldutrecht

Hi,


I succeed in downloading stock prices for 1 stock but I want to get more stocks directly.


I use the excel addin 'financedatatoexcel' but I get an error when I select more stocks.


Thanks in advance,


Ronald

Wed Sep 10, 2014 9:48 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but that's not my add-in.

My add-in has the RCHGetYahooQuotes() function, which allows you to get
multiple data items on up to 200 ticker symbols (a Yahoo limitation) in a
single Internet access.

On Wed, Sep 10, 2014 at 9:20 AM, r.kok@... wrote:

>
> I succeed in downloading stock prices for 1 stock but I want to get more
> stocks directly.
>
> I use the excel addin 'financedatatoexcel' but I get an error when I
> select more stocks.
>
>

Wed Sep 10, 2014 10:01 am (PDT) . Posted by:

ronaldutrecht

Hi Randy,

Thanks, sorry my mistake.


Do you maybe have a working excel file me to check it?


I can't find it in the templates.


Thanks in advance,


Ronald

Wed Sep 10, 2014 10:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Several:

http://ogres-crypt.com/SMF/Templates/#RCHGetYahooQuotes%28%29

On Wed, Sep 10, 2014 at 10:01 AM, r.kok@... wrote:

>
> Do you maybe have a working excel file me to check it?
>
> I can't find it in the templates.
>
>

Wed Sep 10, 2014 1:41 pm (PDT) . Posted by:

ronaldutrecht

Hi Randy,

I already found out, I also had my Add in in the wrong folder.


Regards,


Ronald

Wed Sep 10, 2014 10:53 pm (PDT) . Posted by:

gz_cp

I am trying to get the title of http://www.quandl.com/CHRIS/ICE_B4


But =smfGetTagContent("http://www.quandl.com/CHRIS/ICE_B4","title",1)
returns "Error".


May I know why?
Thanks.


Wed Sep 10, 2014 11:04 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's because you have the wrong URL. The URL you are using gets redirected
to a different URL. This works:

=smfGetTagContent("
https://www.quandl.com/CHRIS/ICE_B4-Brent-Crude-Futures-Continuous-Contract-4-B4
","title",1)

On Wed, Sep 10, 2014 at 10:52 PM, gz_cp@... wrote:

> I am trying to get the title of http://www.quandl.com/CHRIS/ICE_B4
> But =smfGetTagContent("http://www.quandl.com/CHRIS/ICE_B4","title",1)
>
> returns "Error".
>
> May I know why?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 23.04

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)