Delete the Quotes and keep the Symbol/Watchlists in my DB

howto
Tags: #<Tag:0x00007f2d7ae83100>

#1

I have an ASCII DB that i have imported and have WatchLists associated with that DB. I can update the DB by importing new data. However, I noticed that there are many bad dates in the DB which I have cleaned up in a new ASCII folder but when I re-import the data, if a bad date is present in the existing DB but not in the new DB, the bad date is not deleted from the file.

How can I delete all files in the existing ASCII DB in AmiBroker and still keep the Datalists of symbols?

Thanks,

Mike


#2

hello Mike

ASCII data base for me means an .txt or .csv file. So your question is no correct.

Also i think this is a dublicate post like this one. sorry

One more addition of how to delete Quote is go to Amibroker Menu -> Symbol -> Quote Editor


#3

I have 10,000 plus securities in my AmiBroker DB so the Quote editor it not efficient way to handle.

I think my question correctly states that I imported an ASCII DB to AmiBroker not that I am working with an ASCII DB is AmiBroker. The data is imported and Watchlists created from the imported DB.

If I can’t delete the data and re-import a new DB with all the same symbols as those in the created WathLists the efficient solution will be to copy all the symbols in each Watchlist as file, then delete/remove the symbols, import and create a new DB, and then recreate the WatchLists.

Since the imported DB is static, an option to overwrite all data on the import would be helpful. As if now, it seems you can import data and it will overwrite the data if a date if the date exists in the new & old file, but if the date exists in the old file and not in the new file, the old date and data is kept and not deleted.

Thanks for your reply.

Mike


#4

Hello Mike.
this is what i read " How can I delete all files in the existing ASCII DB"
Any way i don’t think there is a better way of what @Tomasz answer already on the other post

Yes I understood your problem is “how to delete the dates that are not exist in your ASCII data file“

if you like visit that links also
https://www.amibroker.com/guide/h_workspace.html
https://www.amibroker.com/guide/h_watchlist.html

Good luck Mike.
i hope there is another solution

edit:
I never try but I just saw with right click on watch list and then export…


#5

As explained in manual
http://www.amibroker.com/guide/x_files.html

You can keep broker.master and broker.workspace files and it will keep all your symbols without keeping quotes.

Of course direct manipulation / deletion of files in AmiBroker database when done incorrectly will lead to data loss.


#6

Hi Tomasz,

I reviewed your link but do not see any direct instructions on how to do it correctly. I did see a highlight that “in most cases you should not touch files in an AmiBroker database” and your comment above re direct manipulation does give me pause. I do see all the files and folders in the AmiBroker “data” folder, including broker.master and broker.workspace. Can all files except broker.master and broker.workspace simply be deleted manually?

If not I think my safest course of action is to copy the symbols from each Watchlist and then create a new DB with the corrected data, and then create the watchlists again. Is there a simple way to export all the symbols in a watchlist to a txt file?

Thanks,

Mike


#7

The document I pointed in previous reply says this:

Data - default database folder, contains broker.master, broker.workspace, 0-9, A-Z, ‘_’ symbol data subfolders and Layouts subfolder. Read this to learn more about AmiBroker database concepts

So you just can delete: 0-9, A-Z, ‘_’ symbol data subfolders
This will delete quotes and annotations, without touching anything else.


#8

Tomasz,

OK, will give give it a shot.

Thank you!!

Mike


#9

Tomasz,

Worked perfectly!

Thanks again,

Mike