The last time I wrote an article about tracking the stock market, I used Power BI, but it had been unsuccessful because the data can't update itself automatically every day.

 

I tried to solve the problem by using the "GOOGLEFINANCE" module in google excel, which will give me the daily stocks on the dates.

​

There is the stock market of Tesla, from "2010/6/29 (the day that Tesla has its own stock market) to today.