Click here to Login

                                                   Create and Export each database for each market


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



2012-11-27 17:00:57


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

2012-11-27 19:02:45


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

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

2012-12-10 14:02:41


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

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:

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

2012-12-10 16:38:06


No more messages


No html code. URLs turn into links automatically.

Type in the trading objects you want to include: - Add Objects
To add a trading object in your message, type in the object name, select it and then click on "Add Objects"


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?
Export Aggregate Case Results for Optimization

Blog Posts
Different Ticker Symbols for Each Data Source
How to Backtest Your Trading System for Each Industry
How to create buy and sell trading rules based on News Data
6 ways to download free intraday and tick data for the U.S. stock...
How to create a trading system, screen and composite using earnin...

Create an account
Affiliate Program
Contact Us
Trading Forum
How-to Lessons
About Us
Terms of Use

Copyright 2023
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Follow us on Google+
RSS Trading Items

Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.