Senin, 06 April 2015

[smf_addin] Digest Number 3375

2 Messages

Digest #3375


Sun Apr 5, 2015 5:43 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Why not try finbiz and then export the excel file?

From: []
Sent: Saturday, April 04, 2015 12:03 PM
Subject: Re: [smf_addin] How to keep the data without updating all the time?

Please don't download that much data. I don't want the free data sources to change their web pages so the add-in can't access the data. As such, the add-in is designed for ad hoc data retrieval. You should be using available screening tools to winnow down which companies you need to look at before getting more detailed data.
If you need that level of data, you should buy something like AAII's Stock Investor Pro database.
Another excellent stock screener is, which includes a point-in-time backtester.
But if you don't want it to refresh, you'll need to convert the retrieved data to values so that the formulas no longer exist when you re-open the file. You can also set a trigger cell to determine when you want the formulas to calculate, although then they don't retain the previous values. Search "trigger" on the message archives for some examples.

On Sat, Apr 4, 2015 at 5:24 AM, alonch77@... wrote:
How can I download eod data without it to be updated when I save or refresh the excel file?
I want to download a lot of data.. 6000 rows and 630 collums - HLCV and 3 fundumentals of half year and I want it to just download it and save the output
Is it possible?

Sun Apr 5, 2015 5:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The export option is now a subscriber-only option...

On Sun, Apr 5, 2015 at 5:43 PM, 'Kermit W. Prather' kermitp@... wrote:

> Why not try finbiz and then export the excel file?
For the Add-in, Documentation, Templates, Tips and FAQs, visit

Tidak ada komentar:

Posting Komentar