Selasa, 01 Maret 2016

[smf_addin] Digest Number 3652

1 Message

Digest #3652
Re: Morningstar question by "Kermit W. Prather" kermitpra


Mon Feb 29, 2016 10:19 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

As Randy has pointed out numerous times, this add-in is not meant for mess retrieval of data I'd say 800 tickers is an overuse.
If everyone does that then website will start finding ways to block the add-in thus making it useless for all of us that follow the rules.
I now limit myself to 100 tickers. When I want more then I'll make multiple runs over a few days and then merge it into a single spreadsheet.
It's a lot more work but it works for me.
Mass screen scraping is one of the main reasons that more and more sites are going to java scripting the webpage.

From: []
Sent: Saturday, February 27, 2016 2:22 PM
Subject: Re: [smf_addin] Morningstar question

The way the add-in works is that is saves a copy of the web page you're extracting data from, then extracts the data from that saved copy of the web page. That way, if you're extracting 10 items from the web page, the web page only needs to be retrieved once, instead of once per formula that extracts data from it.
However, there are only 1000 slots for saving web pages. So any session that accesses over 1000 web pages will get "Error" for any additional web pages.
The smfForceRecalculation macro does purge those 1000 slots. However, any formulas that recalculate would just go right back and get the web pages again. So it doesn't allow you to "restart" a workbook retrieval process unless all previously retrieved items have been converted to values first.

On Sat, Feb 27, 2016 at 12:06 PM, mff3429@... wrote:

i keep a spreadsheet of info on stocks, pulling data from IBD, Yahoo and others laces. i have ~800 tickers. i recently decided to pull info from Morningstar also, ala what's done in the mstar templates. i find that after pulling info for about 100 tickers or so, i start getting no more info. if i close my spreadsheet and restart, i can continue. is there any way via VBA to reset the pulling of mstar info? accomplish the same thing that closeing my file does. this appears unlike the ibd website where there's a daily limit of 300 stock checkups.

For the Add-in, Documentation, Templates, Tips and FAQs, visit

Tidak ada komentar:

Posting Komentar