Do It Yourself – Tutorials – Python Quant Tutorial: How To Build Your Own Stock Database In PostgreSQL

by | Jun 6, 2021 | 0 comments

Do It Yourself – Tutorials – Python Quant Tutorial: How To Build Your Own Stock Database In PostgreSQL

by | Jun 6, 2021 | Do It Yourself - Build Your Own Website | 0 comments

Do It Yourself – Website Tutorials



In this video, I will show you how to build your own stock pricing database in PostgreSQL using Python. Building your own database is critical so that you can have fast and easy access to market data and ultimately become a self-sufficient algo-trader.

The process I will show you to get started is fairly simple. I’ll be using a couple of popular Python libraries, SQLAlchemy and Panadas, and will get this done with less than 100 lines of actual code, which you can of course also copy from my GitHub page at:

GitHub:
https://github.com/aspromatis/Stock-Database

This topic was suggested by a viewer in the comments sections of one of my videos, and I’m taking some inspiration from a chapter in Andreas Clenow’s book Trading Evolved. But frankly, I’ll show you how to do it a little better and with a more robust open-source database. Feel free to grab a copy of his book from this link, which goes to support my channel:

Trading Evolved Book:
https://amzn.to/2HCp7ch

Connect with me on LinkedIn: https://www.linkedin.com/in/erolaspromatis/

Connect with me on Twitter: https://twitter.com/aspromatis

source

0 Comments

Submit a Comment

What Our Clients Are Saying

North Burnaby Boxing Club

Thanks so much for all the great work you have done in developing our website Leland!

Manny, North Burnaby Boxing Club

Dieno Digital Marketing Services
5
2018-04-27T01:06:02+00:00

Manny, North Burnaby Boxing Club

Thanks so much for all the great work you have done in developing our website Leland!

JB Consulting

Leland built us a great site at a great price. We can’t say enough about how pleasant it was dealing...

Dave, JB Consulting

Dieno Digital Marketing Services
5
2018-04-27T01:06:57+00:00

Dave, JB Consulting

Leland built us a great site at a great price. We can’t say enough about how pleasant it was dealing with him!

Kelicor Logistics

Leland created my website for my new venture. I found his service to be excellent,was always available to answer my...

Colin, Kelicor Logistics Solutions

Dieno Digital Marketing Services
5
2018-04-27T01:07:34+00:00

Colin, Kelicor Logistics Solutions

Leland created my website for my new venture. I found his service to be excellent,was always available to answer my questions and was always prepared to go the extra mile, in order to ensure my website conveyed it's intended message,, And the cherry on top was it was most affordable. Would definitely recommend. Thanks Leland !

McNeney McNeney Spieker LLP

Dieno Digital has been providing our firm with what we like to call the Royal Package in customer service for...

M, McNeney McNeney Spieker LLP

Dieno Digital Marketing Services
5
2018-04-27T01:08:19+00:00

M, McNeney McNeney Spieker LLP

Dieno Digital has been providing our firm with what we like to call the Royal Package in customer service for over 3 years now. The knowledge and skills Leland brings to the table has increased our business and streamlined our social media platform. Our requests are always dealt with in a timely manner and we are always given options and alternatives to better reach potential new clients. We highly recommend Dieno Digital to increase your life social media presence.
5
4
Dieno Digital Marketing Services
[newsletter_form]
<div class="tnp tnp-subscription"> <form method="post" action="https://www.dienodigital.com/?na=s"> <input type="hidden" name="nlang" value=""><div class="tnp-field tnp-field-firstname"><label for="tnp-name">First name or full name</label> <input class="tnp-name" type="text" name="nn" value=""></div> <div class="tnp-field tnp-field-email"><label for="tnp-email">Email</label> <input class="tnp-email" type="email" name="ne" value="" required></div> <div class="tnp-field tnp-field-button"><input class="tnp-submit" type="submit" value="Subscribe" > </div> </form> </div>