Calculate dynamic field in a table
Hello, I have data fed from an excel sheet of an investment portfolio, this table contains columns like (Investment, type, purpose, value..etc) In the type column, I have 3 categories (Properties, Stocks, and cash). What we want to achieve is to pull daily stock prices from the internet (which I managed to do that), then I have to calculate the networth by sum the values of properties, cash as well as the stock value (based on the current stock price) I am still a begginer, and I have managed to pull the stock prices, however I am stuck in creating a table that have those nearly static values (properties and cash) as well as a field for those dynamic wealth (stocks) and display that using pie charts and stuff. what should I do, please help