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 [email protected], "brian_z111" <brian_z...@...> 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 [email protected], "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 [email protected], "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 ? > > > > > >
