Exporting Databases - Trading Software

Exporting Databases

Graeme Smith
2012-02-07 09:20:52

Hi.

I know that the Databases.GetDatabasesData(symbol, databaseName, fieldName) function can be used to get the data belonging to a database,
but in order to use this, I was wondering if there is any way to programatically get a list of the field names belonging to a database.
Also to get a list of Databases for an Account, although I guess that could just be done by looking in the directory of the Account.

Essentially what I would like to do is

Foreach Database in Account.Databases
Foreach Field in Database.Fields
...

Or can this only be done by hard coding a list of each database and field?

Thanks,

Graeme

QuantShare
2012-02-07 09:56:54

Best Answer

Currently, it is not possible to get databases and fields programmatically. We will add two functions in the next release.

Yes, you can hard code these lists.

Hashtable hash = new Hashtable();
ArrayList fields1 = new ArrayList();
fields1.Add("Field 1");
fields1.Add("Field 2");
hash.Add("Database 1", fields1);

foreach(string database in hash.Keys)
{
ArrayList fields = (ArrayList)hash[database];
foreach(string field in fields)
{
MessageBox.Show(database + " - " + field);
}
}

Get more messages

No more messages

Back


Trading Items Advanced Quotes and Custom Databases Function Lagged Data From a Custom Database Equity Export To Excel Vilnius, Tallinn and Riga stock exchanges U.S. Stock Market	How-to Lessons How to backup your databases (EOD, Intraday, Tick and Custom) and... How to create a mobile database/account How to export trading data to a CSV file How to quickly select stocks based on the last value of a databas... How to plot news on a chart?
Related Forum Threads Exporting various data Multiple quote databases with same symbols? Exporting optimization results Exporting All symbols of a watchlist in seperate CSV (name -wise)... Exporting optimized test data from trading report	Blog Posts Reading and Exporting Data from QuantShare to Excel Programmatica... How to create custom databases in your trading software How to download the history of dividend payments for stocks in th... Charting, Backtesting and Trading using Fundamental Data 4 Links to Download Free Historical Stock Prices Data by Date