Import Symbols by file - Trading Software

Import Symbols by file

Juliettpapa
2011-04-07 11:40:54

I exported German MDAX50 form Yahoo to a CSV. Only the Name (ARL.DE) and Long Name (Aareal Bank)
This file i have imported into QS with wrong settings....

Now I have in the Bulk Updater:

"ARL.DE;Aareal Bank" in the field name, nothing in the rest of the fields
"BNR.DE;Brenntag AG" in the field name, nothing in the rest of the fields
50 Symbols...

OK. Now i have made a CSV with all relevant data and want to "overwrite".

Symbol-Add-File-Filename....
"Some symbols will not be added. Reasons: Duplicate symbols...."

Hm.
Would be nice if I had the chance to "overwrite" the duplicate symbols.
How can I import my MDAX values without sitting 5 hours of writing..... ???
Or deleting manual (lasts long too)

thx
jp

QuantShare
2011-04-07 11:51:05

Best Answer

In the Bulk Updater, you can check symbols and bulk delete them.
You can check all symbols or some symbols manually or using the Symbols Filter.

To import symbols, select "Symbol" then "Create a list of symbol from a file".
Set the appropriate separator (example: ";")
Click "Load file" and select your CSV file.
Click on "Create List".
Select "Symbols" then "Add/Remove from list of symbols".
Click "Select List"
Select your list then click on "Add".

Juliettpapa
2011-04-07 12:26:46

perfect!

Five stars for the support.
Not standard these days.....

jp

Get more messages

No more messages

Back


Trading Items US Options symbols A-M US delisted symbols IMF Commodity Symbols US Options symbols N-Z Futures, Forex and Indices Symbols	How-to Lessons How to import trading data from CSV files How to import your own list of stocks/symbols How to import trades into a portfolio How to import trading items from other accounts How to export trading data to a CSV file
Related Forum Threads How to asci import file with date in this format YYYYMMDD Export to CSV the whole database including symbols Importing portfolio from a comma delimted file ASCII IMPORT -HOW CANCWE DELETE DATA FOR A WRONG DATE How to import to database from a csv file?	Blog Posts How to Create a List of Ticker Symbols Same chart, different symbols How to search for a download item How to Send Commands to QuantShare from Excel or Other Applicatio... How to make sure your Historical Price Data is Split Adjusted