How to get the stock price of Tesla from Google Spreadsheet

You can get the stock price of Tesla by using Google Finance function in Google Spreadsheet.

 

 

You can import Tesla stocks using Google spreadsheets. And you can manage stock returns and various indicators. You can also take NASDAQ index and use it as a benchmark indicator against NASDAQ index and your portfolio returns.

How to get the NASDAQ index can be found in the following post.

 

2020.05.02 - [Google Finance] - How to get S&P500 and NASDAQ index from Google Spreadsheet

 

 

반응형

 

Apple's iconic figure is Steve Jobs, and Tesla's representative figure is founder and CEO Elon Musk. He was also the motif of the movie's iron man, Tony Stark. Elon Musk's Tesla has redesigned the car from the ground up, making it the leader in electric vehicles and autonomous driving. Tesla become a leader in the future of electric vehicles.Tesla currently has a market cap of $14.81 billion and is the number one automaker in the United States by market cap.If you use the Google Finance function on a cell in a Google Spreadsheet, you can see Tesla's real-time pricing information and past stock prices.

 

 

1. Real-time (real-time price information may be delayed up to 20 minutes)
=GOOGLEFINANCE("NASDAQ:TSLA", "price")

 

2. Closing price on a specific day
=GOOGLEFINANCE("NASDAQ:TSLA", "close", DATE(2020,5,15))