Click here to Login





                                                   Create and Export each database for each market

  0

0
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

  0

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

  0

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


tomshortt
2012-12-10 14:00:32

  0

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

  0

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

  0

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

  0


No more messages
0




Reply:

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"










QuantShare

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...









QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright 2019 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
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.