Click here to Login





                                                   External Database

  1

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


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
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
Industry Name of an External Symbol

How-to Lessons
How to quickly select stocks based on the last value of a databas...
How to use QuantShare with Metastock data
How to plot the ratio of two stocks
How to plot the number of stock tweets per day
How to export trading data to a CSV file

Related Forum Threads
Database File Locked
Delete symbols from Database
Stale quotes database
Is it possible to delete database data through a script?
Error in connecting to Metastock database

Blog Posts
Speed Up Optimizations by Saving Ranking Data into a Custom Datab...
QS Trading Software: Database Optimization
How to create custom databases in your trading software
Diversify your portfolio by investing in stocks from various indu...
4 original breadth indicators you should consider in your market ...









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