Messages In This Digest (3 Messages)

1a.: Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a From: ro.valen

2a.: Re: 600 stock data (quarterly earnings and dates) from Zacks Media s From: V. Shankar
2b.: Re: 600 stock data (quarterly earnings and dates) from Zacks Media s From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Re: Maxing Out on Data Downloads using SMF Add-in... Any solutions a

Posted by: "ro.valen" ro.valen@yahoo.com ro.valen

Tue Dec 6, 2011 3:58 pm (PST)

Thank you kindly for taking the time to provide an explanation, Marty. Happy New Year to you.

Sincerely,

rovalen

--- In smf_addin@yahoogroups.com, Martin Topper <mtopper@...> wrote:
>
> Randy has set a limit of 1,000 web pages stored by the addin in excel.Â This is to allow for data extractions but not abuse the free providers.
>
> Yahoo also has a limit of 200 symbols that can be retrieved at once (through the CSV retrieve which Randy uses for the Yahoo Quotes function)
>
>
>
> I assume you are running into one of these issues.
>
> best
>
>
> marty
>
>
>
> ________________________________
> From: ro.valen <ro.valen@...>
> To: smf_addin@yahoogroups.com
> Sent: Tuesday, December 6, 2011 1:05 PM
> Subject: [smf_addin] Maxing Out on Data Downloads using SMF Add-in... Any solutions around this?
>
>
> Â
> Hello All,
>
> I have built a spreadsheet using Mr. Harmelink's fantastic SMF Add-in that analyzes fundamental data on a couple hundred ticker symbols. However, after data has been retrieved on the first hundred or so, I get an error message telling me I have pretty much reached the maximum allowable download for the session and I am subsequently prevented from downloading further data until I do a full system restart and begin anew.
>
> Does anyone know how to get around this data limitation without having to restart my computer?
>
> Thanks in advance for your suggestions.
>
> Sincerely,
>
> rovalen
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

2a.: Re: 600 stock data (quarterly earnings and dates) from Zacks Media s

Posted by: "V. Shankar" tarakayan@yahoo.com tarakayan

Wed Dec 7, 2011 12:50 am (PST)

Randy,

I just started going thru files section and installed smf add-in. Although I have been using msn money central web query for quite some time with my limited VBA codes, it's amazing to see the assistance you have been providing. It's great!

As this group has been here for quite some, is it a good start with "files section" to see what's going to be useful for you and to get used to add-ins instead of going thru messages? In other words, what's your advice for a newcomer?

Do you have addins for Morningstar (for finding out a stock's sector, industry, stock style, stock type) which I use for portfolio analysis?

many thanks,
Shankar V

>________________________________
> From: V. Shankar <tarakayan@yahoo.com>
>To: "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com>
>Sent: Tuesday, December 6, 2011 11:51 PM
>Subject: Re: [smf_addin] 600 stock data (quarterly earnings and dates) from Zacks Media site
>
>
>
>Oh ok. I was wondering if Vista is needed. Will try it out.
>
>
>thanks.
>
>
>
>>________________________________
>> From: Randy Harmelink <rharmelink@gmail.com>
>>To: smf_addin@yahoogroups.com
>>Sent: Tuesday, December 6, 2011 8:08 PM
>>Subject: Re: [smf_addin] 600 stock data (quarterly earnings and dates) from Zacks Media site
>>
>>
>>
>>I'm not sure I understand the question. I originally wrote the add-in when I had EXCEL 2002/XP and now I have EXCEL 2007/Vista. But the add-in isn't target for a specific version of EXCEL under a Windows platform.
>>
>>
>>On Tue, Dec 6, 2011 at 5:54 AM, V. Shankar <tarakayan@yahoo.com> wrote:
>>
>>
>>>
>>>I was going thru the files and link area for add-ins. Are there versions available for excel 2007/XP professional?
>>>
>>
>>
>>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
2b.: Re: 600 stock data (quarterly earnings and dates) from Zacks Media s

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Dec 7, 2011 1:56 am (PST)

The add-in can be used with a variety of data providers. It's primarily
just a collection of user-defined functions that extract data from the
source code of web page. Some MorningStar pages are dynamically generated,
so the data isn't within the source code of the web page, so the add-in has
difficulty there. Some web pages aren't bookmarkable (i.e use a URL to get
directly to the necessary date), so the add-in can't help there.

For learning, I'd suggest a visit to the "Documentation" folder of the
"Files" area and a browse through the "Links" area of the group for tips
and FAQ. Be sure to try out some of the examples in the documentation of
the functions so you can get some idea of what the function might be doing.

On Wed, Dec 7, 2011 at 1:44 AM, V. Shankar <tarakayan@yahoo.com> wrote:

>
> I just started going thru files section and installed smf add-in.
> Although I have been using msn money central web query for quite some time
> with my limited VBA codes, it's amazing to see the assistance you have been
> providing. It's great!
>
> As this group has been here for quite some, is it a good start with "files
> section" to see what's going to be useful for you and to get used to
> add-ins instead of going thru messages? In other words, what's your advice
> for a newcomer?
>
> Do you have addins for Morningstar (for finding out a stock's sector,
> industry, stock style, stock type) which I use for portfolio analysis?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)