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 Dow Jones U.S. Technology Sector Index Fund survivorship bias-fre... Survivorship bias-free S&P 500 database downloader Lagged Data From a Custom Database IBS - Internal Bar Strength	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 debug a downloader How to quickly download the most recent EOD data for your stocks How to display notes/commentaries on a chart
Related Forum Threads Database File Locked Delete symbols from Database Can we create a custom database that without a Symbol relationshi... Monthly/weekly summation for a custom database field Composite tickers under custom database	Blog Posts Speed Up Optimizations by Saving Ranking Data into a Custom Datab... QS Trading Software: Database Optimization How to make sure your Historical Price Data is Split Adjusted How to use date components in your trading rules Charting, Backtesting and Trading using Fundamental Data