I started to learn Python two months ago, so I am a newbie developer and need some guidance about requests and databases.
My objective is to save stocks’ historical prices, retrieved from API (Alpha Vantage), on a database (models.py). This database would be used as inputs to process different outputs to users, such as stock returns, volatility, plot charts, and many other features for investors.
My questions are:
How could I save API’s requested content (it returns a JSON content) to a database? Main fields would be: Datetime field, stock ticker (AAPL for Apple, for example), company name, and stock price on that specific date.
How could I make daily requests to update this database automatically?
In addition, could you suggest a specific documentation to learn about these topics?