I am new to algo trading. But I have bit of coding experience in SQL. Now I am planning to develop a Algorithmic Trading system. In here I am storing all the historical data in Database (PostgreSQL DB).
Initially I was planning to code all the technical indicators and strategies in Python. But as I am using a Database now I am in confusion whether to write the code for technical indicators in Python or should I calculate those values in SQL only and store in the Database.
Please provide your thoughts, pros and cons and also any other suggestions.