 |
Dave W.
2014-06-20 11:43:00
|
|
Hello. I'm considering using MySQL or another external database to store and maintain trading data. There are a few reasons for this, including transparency, the ability to have full control over tables and relationships, and the ability to make changes to the data via standard SQL commands and tools.
Other than the ability to 'link' to MetaStock files, is there a method to enable QuantShare to connect to and use data from an external relational database?
If not, I'd appreciate it if you would add it to your 'new feature' list.
|
|
|
 |
QuantShare
2014-06-20 18:26:37
0
|
|
Hi Dave,
It is not possible to use a Mysql database with QuantShare unless a custom plugin is implemented. Unfortunately, we are unlikely to add this as a new feature as it doesn't add any value to QuantShare. Besides, each Mysql database/tables structure would probably need a different plugin.
|
|
|
 |
Alexander Horn
2014-06-20 19:43:40
0
|
|
Let me turn around the question. Is is possible to access the SQLite dbs of quantshare by external tools, e.g. through ODBC driver or other. If yes, which would you recommend? Maybe this would give similar functionality as Dave looks for, e.g. data manipulation outside QS, but access within QS. Have not tried out, just an idea...
|
|
|
|
|
Dave W.
2014-06-20 19:58:22
0
|
|
Alex,
Fair point. About 6 months ago, I was able to use an off-the-shelf, free tool to access the historical QuantShare SQLite DB (I was trying to recover a corrupt DB... unsuccessfully). Unfortunately, some (all?) of the price data is stored in a manner where I was unable to see the information. I can't recall the details, but I'm sure Azouz can provide more info...
|
|
|
|
|
QuantShare
2014-06-21 08:12:30
0
|
|
Best Answer
You can access the database but you can't read the data because it is stored in binary format and it is highly compressed.
But you can export all the data without any problem and see all the information.
As you probably know, the data can also be displayed in QuantShare using "Data -> Edit Databaes".
|
|
|
|
|
QS1
2015-08-17 22:39:42
0
|
|
What about the ability to import data from SQL/MySQL into Quantshare? We bring down data from bloomberg for instance and store into SQL. It would make sense to get Quantshare to pull that data from SQL internally rather than go out to the web.
Can this be done?
|
|
|
|
|
QuantShare
2015-08-18 03:39:57
0
|
|
That would be a custom solution. Contact support if you would like to implement this.
|
|
|
|
|
1
