Open fossterer opened 4 years ago
Ticker Name Security Type Quantity Purchase Price Purchase Date
AAPL - - -- -- -- FB - - -- -- -- MSFT - - -- -- -- BO - - -- -- --
An external API call to fetch current Price (https://finnhub.io/docs/api#websocket-trades OR https://finnhub.io/docs/api#quote OR anything else)
Ticker Price_DataStructure (Type = CLOB)
AAPL [price1]
An array or such datastructure --
[price1]
Everytime you fetch this, improve it to
[price1, price2] and so on
Please also include *.sql files for your table definitions whenever they cahnge Stretch goal: https://note.nkmk.me/en/python-pip-install-requirements/ (For easy setup of libraries)
Table-1
Ticker Name Security Type Quantity Purchase Price Purchase Date
AAPL - - -- -- -- FB - - -- -- -- MSFT - - -- -- -- BO - - -- -- --
An external API call to fetch current Price (https://finnhub.io/docs/api#websocket-trades OR https://finnhub.io/docs/api#quote OR anything else)
Table-2
Ticker Price_DataStructure (Type = CLOB)
AAPL [price1]
An array or such datastructure --
[price1]
Everytime you fetch this, improve it to
[price1, price2] and so on