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... Lagged Data From a Custom Database Survivorship bias-free S&P 500 database downloader 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 download and use U.S. stocks earnings data How to quickly add a ticker symbol How to display notes/commentaries on a chart
Related Forum Threads Export to CSV the whole database including symbols Deleting Data From The Database Backtest/Optimizing speed vs Size of Database & Vector vs loo... Adding data to database through script Is it possible to delete database data through a script?	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 Pick the Best Trend Indicators Fundamental Screen based on Stock price, ROI and Market capitaliz...