Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 12:24:04 +0000



[Programming Help] - importing data from PostgreSQL

View Count: 594

[2020-02-05 16:09:50]
Chad - Posts: 231
Hi,
I'm exploring ways to import alternative data sets into SC - after searching the Board a bit, I came across three threads that seemed relevant:
1) 'Import SCID files into R' (where you noted an email for Jim@sierrachart as possible help)
2) 'SQLite Connexion'
3) 'Connecting to external MySQL database server' (I emailed user 'ChrisR' and asked about user 'enemyspy' as well, but no response)

I am storing most of my data in a local PostgreSQL database, and would want to import as either a time series in a new Chart window, or more preferably a subgraph for the symbol in a current Chart to reference more directly.

Worth noting that the frequency of most of these external sets are daily at-best, but more often weekly/monthly (e.g. US DoE oil inventories). In context of a higher-frequency chart for oil futures, I assume each weekly data point could 'roll' forward as a constant value until the next data point is found, then that rolls forward, and so on.

Aside from a direct (& preferable) connection from ACSIL, my first idea is to first export these from the db as CSV files, then import those per your documentation. Still, seems the solution touched on in the 3rd thread noted above is best, but I want to confirm.

Can you provide some tips on the most appropriate way to do this?
Date Time Of Last Edit: 2020-02-05 16:10:51

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account