[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: How to remove all fundamental data ???



PureBytes Links

Trading Reference Links

If you want to reset all fundamental values to zero, for a large number of symbols, you will have to make up a CSV file with all of the symbols in your database (you can get a txt list by exporting them from AB or AQ) ... then make all of the columns up with zeros ... the same number of columns as in the AQFN and AQFE Format file ..... then ASCII import using the above format files as the mask.... all of the zeros will overwrite any old funda data you have in your database.

Maybe skip the close column.

Make a backup copy of your database.
Try one symbol first to see what happens before you try it in bulk.


--- In amibroker@xxxxxxxxxxxxxxx, "brian_z111" <brian_z111@xxx> wrote:
>
> Hello gmorlosky,
> 
> Not sure where you are going but since you seem to be hitting the wall:
> 
> I have to do some guessing here:
> 
> - last time I checked AB fundamental data import it worked exactly as Tomasz explained it in his recent post
> - fdata is not stored historically ... only the current value which is overwritten each time you import again
> - fdata is stored at the binary level but we don't see it in QuoteEditor
> - files in the AQ folder are irrelevant once data is in AB
> - from memory I think you can elect to overwrite them, or not, each time you download from Yahoo
> - they are only ASCII files ..... if you elect not to auto import and you have overwrite selected you can go in there and manually change values to zero before electing to export from AQ to AB (manually import) ... at least you can do that with data files so probabaly it works for funda files as well. 
> 
> 
> 
> 
> --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> >
> > TJ - I have deleted the existng folders and yet when I look at a stock, part of the fundamental data is still there. (using local database - Yahoo EOD). 
> > Statistics has share info, Financials have 60% of it's data, and Dividends has 50% of it's data.
> > 
> > 
> > Thanks
> > 
> > --- In amibroker@xxxxxxxxxxxxxxx, "gmorlosky" <gmorlosky@> wrote:
> > >
> > > I have removed all my ticker price data by removing all folders in the database, and cleaned out any *.aqh or *.aqfe or *.aqn files, leaving only the 3 base files of broker.*, but I can't get the fundamental to go away. Where is that stored ?
> > >
> >
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/