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
1
vote
1 answer

Change Google Finance Result from row to column in Google Sheets

I am pulling data from google finance to google sheet using below formula: =GOOGLEFINANCE("NASDAQ:AAPL","price",TODAY()-10,TODAY()) and the result is like below what i want the result to be like is below so that when i put new stock in next row…
Zac
  • 323
  • 7
  • 14
1
vote
1 answer

How to pull 1 January 2021 stock price data with google finance

I'm trying to pull 1/1/2021 stock price data with google finance but it gives an error. I can do it for 2020 or any other time but not 2021. Please write if you know how to solve. =index(GOOGLEFINANCE("AAPL","close",DATE(YEAR(TODAY()),1,1)),2,2)
Semi
  • 11
  • 2
1
vote
2 answers

How to check stock market is open with Google finance (sheets)

Hi I'm using the GOOGLEFINANCE command in google sheets to return stock prices which is working but when the market is closed it still returns a value (last trade price) - I only want to return a price when the market is open. (this could be USA…
coder787
  • 21
  • 5
1
vote
1 answer

How can I use Google Sheets, Google Finance, and Sparkline to create a networth chart based on my current holdings?

Right now I am using a google sheet that keeps track of my stock investments. What I would like to do is methodically calculate what my networth would be over time given my current holdings. Obviously this isn't a true historical networth but it…
ryanmavilia
  • 205
  • 2
  • 6
1
vote
0 answers

Google Finance formula in Google Sheets sometimes results in N/A until refreshed

As the title states, my formula results in N/A randomly until refreshed. This is a problem because I have multiple formulas that are dependent on this one googlefinance() formula, as well as automatons running that pull information from google…
cactusboat
  • 778
  • 2
  • 7
  • 15
1
vote
1 answer

Cannot properly array googlefinance formula with dates

I am trying to convert money amounts in USD to EUR, but I want to do it in relation to date of transaction taking place due to dyncamic exchange rates. Idea is to use googlefinance function with index function, along with date function, which will…
NadanSHA
  • 77
  • 6
1
vote
2 answers

How to fetch price for a specific date from GoogleFinance?

I tried below syntax to fetch the close price of specific date: =GOOGLEFINANCE(,"price","07/09/2020") While it works perfectly for US stocks, the result for Indian stocks are incorrect. For example: if you query for July 9th, the stock…
snehil kamal
  • 13
  • 1
  • 3
1
vote
2 answers

Can you write Google finance directly to an array?

Can googlefinance write results directly to an array? I am currently writing it to a sheet first and then pulling the sheet range into the array. It would save a lot of processing if I could write it directly to an array so I am investigating. If…
Scott Fitzpatrick
  • 41
  • 4
1
vote
1 answer

Google sheets googlefinance query not working within if statement

In google sheets the following formula works fine =GOOGLEFINANCE("Currency:" & H6 & I6) * G6 If I try to use it within a IF-statement it gives a parsing error. =IF(H6! = "USD", GOOGLEFINANCE("Currency:" & H6 & I6) * G6, "fail") Must be a syntax…
bsparks
  • 61
  • 2
1
vote
1 answer

How to Show Google Finance like data in Wordpress

Is there a way to show index prices by specific date like in google finance on wordpress?
Fede Ricchezza
  • 11
  • 1
1
vote
1 answer

How do I get Google Sheets (Google Finance) to show the what date the lowest stock price was within a date range?

Currently I have the following formula: =MIN(INDEX(GOOGLEFINANCE(B2, "low",DATE(2020,2,19),TODAY()),0,2)) This gives me the lowest price for my stock but I want to know what date this lowest price was as well. Can anyone help me out?
goodone05004
  • 11
  • 1
1
vote
1 answer

Google Finance query last 5 trading days excluding weekends

I have the following google and yahoo finance queries that generate a simple graph for the last 5 days. How would I go about modifying it to look at last 5 trading days. Simply Monday to Friday only. =IFERROR(sparkline(query(googlefinance($A16,…
domid
  • 33
  • 7
1
vote
1 answer

Google Sheets (Google Finance) - Get stock price once and track

I would like to, upon data being entered into a new row (from external sheet - date, time, stock ticker), use google finance to get the current price of the stock into a cell and then no longer update the price in that cell. In the cell next to it,…
Jake Allen
  • 11
  • 3
1
vote
2 answers

In GoogleFinance what formula should i use to get a 1 week return, 2 week return and so on of a stock from a specific date?

In Google Finance, none of the the returns are working for me. "return1" - One-week total return. "return4" - Four-week total return and so on are not working. I'm wondering if there's a formula that can spit out the same information. For example:…
David S
  • 21
  • 1
  • 2
1
vote
1 answer

Build Dynamic Google Search Link Using Google Sheets

I am hoping to create a column in Excel that links to a Google search for a specific stock depending on the stock symbol in column A. For instance if column A1 = AAPL, b1 would be: Using the Symbol in A1, cell b1 will create a link that makes…
westman2222
  • 663
  • 1
  • 12
  • 30
1 2 3
…
27 28