Posts

Capturing Stock Prices into a Local Database

-
Image
Goal My aim is to load daily stock prices into a local database. First, I plan to automatically set up the load into the SQL database. This part will be the step that loads the data as strings into the database.  This post will go over the steps on how I'm capturing that data. The API service that is being used, the SQL Server table structure and the loading of data from the API call into the database using python.
Post a Comment
Read more

Transforming Captured Stock Market Index Data

-
Image
 Goal In the first part located here  stock index data was uploaded into a SQL Server database. All the incoming data that was captured from the API call was stored as strings. In this update that data will be transformed into its proper data types.
Post a Comment
Read more

Capturing Stock Market Index Prices into a Local Database

-
Image
  Goal I’m in what will be a very long process of building my own personal database of stock prices and related data. One of the first points of data I aim to collect is daily price data of some of the major indices, i.e., Dow Jones, Nasdaq etc. This post will go over the first steps on how i'm capturing that data. The API service that is being used, the SQL Server table structure and the loading of data from the API call into the database using python. 
Post a Comment
Read more