Create and Export each database for each market

Create and Export each database for each market

Gabriel
2012-11-27 11:08:56

Hello eveyone. First of all I have to say that I found a place to stay. You all are very kind and polite and always there to help us. I know that I am making so many questions,
but they are here because I really didn't find the answers to them still now. I really hope that, we your help, I can, finally, have them answered.
Thank you in advanced...

I'm new here and have searched the knowledge database but I could not figure out how could I do the following:

1 - I wanna create one database for each market ( and put everything for a specific country in it -> all historical quotes, intraday, news, fundamentasl, everything the
software give to us - I will be glad if you can contribute with "best practices" or any other better idea)
2 - Then I want to create a schedule to update each market separately, because each market closes in a different time
2.1 - In this case I would like to know how much time after each market closes, you recommend to download the data ?
2.2 - How can I automatically create a way to split the data when it happens, and if there is a way of correct dividends for all of data also
3 - I want to create a way of exporting each database created in step 1 and their information, to a correspondent Oracle databases (I dont know if the best way of
doing this is generating a CSV file the uploading it or if there is another option )
4 - I would like to know the differences between "Last download date" and "Last Symbol Data" options in the Download items
5 - I would like to know how can update all symbols and news create in step 1, and how often do I need to update historical database quotes
6 - I would like to know if its necessary to have your software running to do all this or if there is a way of doing it by command line for example so it it closes I still
can make everything work

I appreciate your help

thank you in advanced

regards

Gabriel

Gabriel
2012-11-27 17:00:57

If anyone can help me doing these steps, I appreciate. Even if I have to pay for it.

QuantShare
2012-11-27 19:02:45

Just send an email to support [at] quantshare [dot] com and they will help you with this.

tomshortt
2012-12-10 14:00:32

Did you ever get a solution to this? I would like to do the exact same thing except to SQL Server instead of Oracle

QuantShare
2012-12-10 14:02:41

You have to export data in csv format then import the csv data into your SQL Server databases.

tomshortt
2012-12-10 14:11:09

Thanks, that's what I'm doing. My issue is I'm using the script below which I found on the forum to export data and my US database crashes after about 5 years of data so I have to break the database into pieces. Is there a way to modify the script below to select certain dates (Ie, I can update monthly and just export the last month's worth of data)? I can then import that file into SQL. Thanks

From Forum: http://www.quantshare.com/title-95-export-to-csv-the-whole-database-including-symbols#axzz2EeTWX8VH

A whole copy of the database to a CSV file can be performed using the scripting language. Tools -> Script Editor.

Here is the script to perform this:

Symbol[] symbols = Symbols.GetSymbols();
System.Text.StringBuilder text = new System.Text.StringBuilder("");
for(int i=0;i < symbols.Length;i++)
{
Symbol sym = symbols[i];
HistoricalQuotes quotes = Quotes.GetHistoricalQuotes(sym.Name);
for(int j=0;j < quotes.Close.Length;j++)
{
text.AppendLine(sym.Name + ";" + quotes.Date[j].ToString("dd/MM/yyyy") + ";" + quotes.Close[j]+ ";" + quotes.Open[j] + ";" + quotes.High[j] + ";" + quotes.Low[j] + ";" + quotes.Volume[j]);
}
}

System.IO.File.WriteAllText(@"c:\quotes.csv", text.ToString());

- The last line reference the file.
- The format is: Symbol;Date;Close;Open;High;Low;Volume

QuantShare
2012-12-10 16:38:06

The answer is here:
http://www.quantshare.com/title-95-export-to-csv-the-whole-database-including-symbols

Get more messages

No more messages

Back


Trading Items Output metric for each trading year Average Stock Performance for each U.S Exchange Industry and Sector Information for the US Stock Market Random Value for Each Trading Bar Tweet Sentiment Index for the Forex and Stock Market	How-to Lessons How to automatically draw Fibonacci Retracement for each new stoc... How to create and trade a Neural Network model How to create trading rules based on Put and Call volume data How to add future bars to plan for market scenarios How to download EOD quotes for active and valid stocks only
Related Forum Threads Optimize for each symbol and walk-forward test on list Setting stop loss for each trade Dynamic Watchlist update for each time step during a simulation? INTRADAY CHART AND VERTICAL LINE TO SEPARATE EACH DAYS Export Aggregate Case Results for Optimization	Blog Posts Different Ticker Symbols for Each Data Source How to Backtest Your Trading System for Each Industry 6 ways to download free intraday and tick data for the U.S. stock... How to create buy and sell trading rules based on News Data Create indicators, composites and trading systems using QL and CS...