[smf_addin] Digest Number 3207

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3207

1.1

Re: New file uploaded to smf_addin by bushpilote

2a

Re: Getting message that Yahoo Finance limited to 200 ticker symbols by JCHyjun

2b

Re: Getting message that Yahoo Finance limited to 200 ticker symbols by JCHyjun

2c

Re: Getting message that Yahoo Finance limited to 200 ticker symbols by "Randy Harmelink" rharmelink

Messages

1.1

Re: New file uploaded to smf_addin

Mon Oct 13, 2014 6:17 am (PDT) . Posted by:

bushpilote

Thanks for the zip file digsupply.

The source of my problem with the dividends and earnings spreadsheets is the DATEVALUE function.
The function is unstable as it is a hit and miss affair. I'll have to take a look at my "dates"regional settings
in Excel .
If that doesn't do it, I''ll try option 3 suggested here:
Five Minute Lessons http://fiveminutelessons.com/learn-microsoft-excel/convert-text-value-date-excel

http://fiveminutelessons.com/learn-microsoft-excel/convert-text-value-date-excel

Five Minute Lessons http://fiveminutelessons.com/learn-microsoft-excel/convert-text-value-date-excel Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more exam...



View on fiveminutelessons.com http://fiveminutelessons.com/learn-microsoft-excel/convert-text-value-date-excel
Preview by Yahoo

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

2a

Re: Getting message that Yahoo Finance limited to 200 ticker symbols

Mon Oct 13, 2014 7:35 am (PDT) . Posted by:

JCHyjun

Yep, Yahoo has this 200 tickers limit.

Is it a way around? For example for 1000 tickers to specify 5 "super-symbols", each represents 200 tickers, and then apply SMF to these 5 "super-symbols".... Just wondering, I'm not a programmer....

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

2b

Re: Getting message that Yahoo Finance limited to 200 ticker symbols

Mon Oct 13, 2014 7:36 am (PDT) . Posted by:

JCHyjun

Digsupply: What do you try to say?

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

2c

Re: Getting message that Yahoo Finance limited to 200 ticker symbols

Mon Oct 13, 2014 7:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you have a 1000 ticker symbols, just do 5 RCHGetYahooQuotes() functions.
The 200 ticker symbol limit is per request, not per day or per session.

On Mon, Oct 13, 2014 at 7:35 AM, jchyjun@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Yep, Yahoo has this 200 tickers limit.
>
> Is it a way around? For example for 1000 tickers to specify 5
> "super-symbols", each represents 200 tickers, and then apply SMF to these 5
> "super-symbols".... Just wondering, I'm not a programmer....
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 22

• Privacy • Unsubscribe • Terms of Use