Internal database format? - Trading Software

Internal database format?

Stefan Kroscen
2010-08-14 16:41:54

I was wondering what the internal database format is, and if it is possible to run sql against it. It would help in verifying the
integrity of the data. For instance, I am in the process of testing a new downloader, and it downloads many thousands of rows. I am spot checking
to see if my mapping function that takes text and assigns it a corresponding number is missing any possible text values. I will be unable to hand verify
every row and am sure to miss some. With sql, I could run a query and find them immediately.

Thanks!

QuantShare
2010-08-14 20:04:03

Best Answer

The application uses two types of compression and therefore you cannot access data using sql.

However, you can use the global scripting to verify the data (Tools -> Script Editor).
Use the "Databases.GetDatabasesData" function to access the data and "Global.Trace" to write to the output window (View -> Output).

Stefan Kroscen
2010-08-16 20:16:11

Ok, I'll try that. Thanks!

Get more messages

No more messages

Back


Trading Items Earnings database Lagged Data From a Custom Database Percentage of Nasdaq 100 stocks that closed above their 10 day mo... U.S. Stock Market Indonesia Stock Exchange - Historical data	How-to Lessons How to quickly select stocks based on the last value of a databas... How to display the number of notes per stock How to quickly download the most recent EOD data for your stocks How to download Portfolio123 data into QuantShare How to display notes/commentaries on a chart
Related Forum Threads Export to CSV the whole database including symbols Database File Locked Delete symbols from Database Deleting Data From The Database Backtest/Optimizing speed vs Size of Database & Vector vs loo...	Blog Posts QS Trading Software: Database Optimization 4 indicators to create adaptive trading systems Creating Stock & Market Short Interest Ratios using Historical Sh... Trading Items: Data Download using .Net Scripts 4 different weighted index calculation methods