Selasa, 14 Oktober 2014

[smf_addin] Digest Number 3207

4 Messages

Digest #3207

Messages

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







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....

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....
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar