Stack Overflow
Stack Overflow

Questions tagged [google-finance]

Google Finance is a service used to track stock and portfolio information. Originally had a public API, but the API was shutdown. Use with tags(eg: [google-sheets-formula]), where the service is involved.

Google Finance is a service used to track stock and portfolio information. Originally had a public API, but the API was shutdown. However the service is still running. Limited programmatic access is also available through

Official Website

417 questions
0
votes
2 answers

How to get last closing price of a stock in google finance (In a non-trading day)

I tried using =INDEX(GOOGLEFINANCE("NASDAQ:MSFT","price",TODAY(), 2),2,2) And saw that on some days (e.g. 12/6/2021, a Saturday) the function failed to return value. I assume that it is because there was no trading on that day. Is there a way for me…
yuvalm2
  • 866
  • 2
  • 10
  • 27
0
votes
3 answers

How can you get financial data from Google Finance (or yahoo finance) into Google Sheets?

I'm struggling to get financial data into google sheets. I read some answers here and tried this: =importhtml("https://www.google.com/finance?q="&B2&"&fstype=ii&ei=viASWOnfNsfEeqqUnMgG","table",3) Yet it always shows this error: Imported content…
Mxritz Flr
  • 9
  • 3
0
votes
1 answer

How to parse and capture Dividend Value from in Google Sheets

Objective: Capture $ or % dividend value for a given stock. Using Google Sheets, the following worked perfectly fine =SPLIT(INDEX(IMPORTHTML(concatenate("https://finance.yahoo.com/quote/",G14),"table",2),6,2)," ") where G14 is a stock symbol, like…
James Raitsev
  • 92,517
  • 154
  • 335
  • 470
0
votes
1 answer

How to get Google Sheets (Google Finance) to show today's close value

I am able to get todays high / low / open with below formula correctly. =INDEX(GOOGLEFINANCE("NSE:CIPLA", "HIGH")) // considering changing second param but I cant get the today's close with below formula. =INDEX(GOOGLEFINANCE("NSE:CIPLA",…
codingHack
  • 21
  • 3
0
votes
3 answers

WTI price in Google Sheets

Hi I'm trying to get the current WTI (West Texas Intermediate) price but GoogleFinance doesn't recognize it. Has anybody had luck with this?
Mitchell Bivens
  • 97
  • 2
  • 12
0
votes
0 answers

Grouping cells in Google sheet possible?

Is there a certain method (would be better if it doesn't require some custom script) that I can create a group for a list of cells? So that I don't have to click-to-select every time, there are like 100 cells in total non-adjacent/non-consecutive to…
decompluse
  • 7
  • 4
0
votes
1 answer

Google finance: get YTD high

I am trying to get the YTD high of a ticker using =max(INDEX(GOOGLEFINANCE("AAPL";"high";"01/01/2020"; today();"DAILY"))) but it does not work. Any tip?
seralouk
  • 30,938
  • 9
  • 118
  • 133
0
votes
1 answer

Google Sheets / Google Finance return the day a stock hit its max or lowest price

I am finding the max of a stocks price from a starting date to 3 months after that date and I want to get the date that the stock hits its max so I compare it to SPY over that same time. My current formula for finding the stock's max…
Connor Gasgarth
  • 21
  • 3
0
votes
1 answer

How to work around GOOGLEFINANCE failures?

I need historical data of currency exchange rates for my gooogle sheet and GOOGLEFINANCE function is just what i need. Here is the sheet with GOOGLEFINANCE data I copied from my…
stekatk
  • 13
  • 1
  • 8
0
votes
1 answer

Change the colour (green or red) of the cell depending if stock price is up today

I am creating a google sheets stock tracker and the problem i have is that i create a command that change the colour of the cell that has the stock price depending if its up or down today. For example if Amazon stock is up on Monday to make the cell…
starboi
  • 11
  • 1
0
votes
0 answers

Google Finance Rounding up Penny Stocks

How do I get Google Finance to stop Rounding up Penny Stocks? I import a stock in to google sheets using the google finance option and it takes .0162 and makes it .16 Any Help Please!
AliB
  • 1
0
votes
1 answer

Google Finace change a number to negative if another column is marked sell

Currently working on making a portfolio tracker. im looking probably for a if statement that will change my Quantity of shares held to a negative if another column is labeled as 'SELL'. You can see from the image provided, the right column is what…
Peter
  • 45
  • 7
0
votes
1 answer

How to calculate total value of a column containing mixed currencies

Given the following columns, where A is the currency and B is a monetary value in that currency: A B USD 50 USD 150 EUR 200 EUR -150 AUD 300 How can I use the GOOGLEFINANCE function to return the sum the of entire value of column…
Dan
  • 6,265
  • 8
  • 40
  • 56
0
votes
1 answer

Why is the result of my GOOGLEFINANCE formula always the same?

I wrote a script with Apps Script for my Google Sheet, in order to have a record of stock prices at a given time. The script is executed every hour by a time-driven trigger. function logStockPrices() { var ss =…
pfra
  • 5
  • 1
  • 5
0
votes
2 answers

GoogleFinance for Price Open on a specific date

I can only get a price open for a stock on the latest trade day? =GOOGLEFINANCE("BB","priceopen") However, adding a date returns #NA. =GOOGLEFINANCE("BB","priceopen", "2020/12/17")
Mauro
  • 307
  • 4
  • 8
1 2 3
…
27 28