Minggu, 28 Februari 2016

[smf_addin] Digest Number 3651

4 Messages

Digest #3651

Messages

Sat Feb 27, 2016 6:32 am (PST) . Posted by:

stevet99uk

Is it possible to disable smfForceRecalculate? Want to reopen book without updating the links as a reload of the cache takes awhile and in many cases the existing data is adequate

Sat Feb 27, 2016 7:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That isn't something smfForceRecalculation does. If you've closed down and
restarted EXCEL, it will need to retrieve the web pages to extract data
from them. However, if all you did was close the workbook, then reopen it,
the web pages are still saved in the add-in's storage area and would not
need to be retrieved.

On Sat, Feb 27, 2016 at 7:32 AM, stevethompson486@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is it possible to disable smfForceRecalculate? Want to reopen book without
> updating the links as a reload of the cache takes awhile and in many cases
> the existing data is adequate
>

Sat Feb 27, 2016 11:07 am (PST) . Posted by:

mff2805

hi,
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.
thanks much,
Mike


Sat Feb 27, 2016 11:22 am (PST) . Posted by:

"Randy Harmelink" rharmelink

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 http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar