trading software that connects to SQL db

antiseptic

antiseptic

I found this: https://www.elitetrader.com/et/thre...-millisecond-chart.199423/page-5#post-2848647 but it's ten years old.

I'm looking for a trading software program that can connect to a PostgreSQL database, and allows you to script your own indicators, candlestick charts, and watchlists. I don't need data, real time or otherwise, I have data in an sql database.

I search for technical analysis software, and either it is geared towards institutions, or it doesn't fit my needs, or web based, or it's stuff I could do with python.
 
Last edited:
Would a Rithmic or CTS-T4 or TT API help?
 
antiseptic said:
I found this: https://www.elitetrader.com/et/thre...-millisecond-chart.199423/page-5#post-2848647 but it's ten years old.

I'm looking for a trading software program that can connect to a PostgreSQL database, and allows you to script your own indicators, candlestick charts, and watchlists. I don't need data, real time or otherwise, I have data in an sql database.

I search for technical analysis software, and either it is geared towards institutions, or it doesn't fit my needs, or web based, or it's stuff I could do with python.
More...
What are your other requirements besides a SQL database as a data source?
 
fan27 said:
What are your other requirements besides a SQL database as a data source?
More...
Sort of like, thinkorswim, but instead of using Ameritrade data I'd use my own. But it doesn't need all the scanning and backtesting, ondemand stuff. Just pure charting. I have data, and I can analyse this data, it's just I don't want to go through the trouble of creating charting software when there probably is something already available. Yea, I could just go to yahoo, but then there might be errors in my data that I would never see. Looking at OHLCV data in csv format, you'd have to have inhuman skills to see errors.

Yea, there's matplotlib, but that doesn't do stock data very well. I suppose if there was another python module/library that would be acceptable as well.
 
antiseptic said:
Sort of like, thinkorswim, but instead of using Ameritrade data I'd use my own. But it doesn't need all the scanning and backtesting, ondemand stuff. Just pure charting. I have data, and I can analyse this data, it's just I don't want to go through the trouble of creating charting software when there probably is something already available. Yea, I could just go to yahoo, but then there might be errors in my data that I would never see. Looking at OHLCV data in csv format, you'd have to have inhuman skills to see errors.

Yea, there's matplotlib, but that doesn't do stock data very well. I suppose if there was another python module/library that would be acceptable as well.
More...
Another option is to write a python utility to export your SQL data to CSV and then find an off the shelf charting application you like that supports CSV.
 
Do some google on Amibroker. Not a programmer or tech guy so not sure how SQL works/is.

Quick google on Amibroker/SQL turned up lots of forum topics/official info. They have an ASCII importer I’ve used plenty of times to import data in whatever configuration I wanted. Many programmers on the forum are always building their own custom plug in/scripts to do whatever they need.
 
You must log in or register to reply here.
Back
Top