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

Trying to use IMPORTHTML or IMPORTXML to get price value from https://finance.yahoo.com/quote/GSPX.L/ in Google Sheets

I'm trying to use IMPORTHTML or IMPORTXML to get price value from https://finance.yahoo.com/quote/GSPX.L/ or in fact from any site that will give me a relatively up-to-date number. I used to be able to get the value using the GOOGLEFINANCE formula,…
booms
  • 23
  • 5
1
vote
4 answers

GWT - Annotated time line chart with zooming, scrollbar and navigator

I am looking for a GWT extension for displaying a Google finance-like chart. (features like zooming, scroll-bar and navigator are required)I want to stay away from flash. I have looked at GWT Highcharts. Anything else worth considering?
blue01
  • 2,035
  • 2
  • 23
  • 38
1
vote
1 answer

Format weekly currency exchange average

I've looked around for how to format google finance results and I can't seem to find an easy answer. I want to output weekly CX averages for USD to CAD. Google finance outputs a 4-cell response, I simply want the single cell weekly average.. Example…
askon
  • 671
  • 2
  • 10
  • 24
1
vote
1 answer

How to generate a time series of the historical performance of a stock portfolio on Google Sheets?

I'd like to generate a time series of the historical performance of a hypothetical stock portfolio on Google Sheets, considering there will be stock trades made at different times. The desired result would be a p/l curve that can be compared with a…
JNMaven
  • 41
  • 5
1
vote
1 answer

How to use LAMBDA with GOOGLEFINANCE to perform currency conversions in an array?

I'm trying to write a formula that checks the currency of a stock position and performs a currency conversion if it is anything other than USD. I'd like to make column F into an array but the GOOGLEFINANCE formula doesn't work with the arrayformula.…
JNMaven
  • 41
  • 5
1
vote
2 answers

Multiply Parameter exclude header row

I am trying to multiply the number of owned shares by the current price, however, I am getting the following error: Function MULTIPLY parameter 2 expects number values. But 'OWNED SHARES' is a text and cannot be coerced to a…
vohratom
  • 422
  • 7
  • 16
1
vote
1 answer

Filter and Sort the data from another sheet

I have a stock xls with two sheets: TRN HISTORY sheet with DATE, SYMBOL, UNITS, PRICE, TYPE, OWNED…
vohratom
  • 422
  • 7
  • 16
1
vote
1 answer

Automatic filling of Stock price

I have a list of scrips of stock market. When I add a new scrip in a new row, I would like to automatically fill its current price using GoogleFinance function of google sheets. In the attached google sheets, Column A contains the mnemonics of the…
Pravin Kumar Raja
  • 43
  • 4
1
vote
1 answer

How to get the 1-hr, 7-day and 1-month percentage changes of a stock with Google Finance/Sheets

I can currently get the 24hr percent change of a stock in Google Sheets by: =GOOGLEFINANCE("NASDAQ:GOOGL","changepct") How do I get the 1-hr, 7-day and 1-month percent changes of a stock(or even a custom amount)?
steve238
  • 831
  • 1
  • 10
  • 19
1
vote
2 answers

Referencing a date from a cell in google sheets

I am trying to track stock prices with Googlefinance function in Sheets. I can pull the price for a date with =INDEX(GOOGLEFINANCE((B2),"price",date(2019,12,13)),2,2) which is fine but I want to input the date with Column A which has date data. So,…
WeedKiller 420
  • 11
  • 1
1
vote
2 answers

Using GoogleFinance, can you get the previous trading day's closing price of a stock given a date?

I want to use a formula to input a date and get the previous trading day's closing price. I have been unable to find a solution online. When looking, I found the "closeyest" attribute, but it seems this doesn't allow you to enter a date. I have…
Treghlop
  • 13
  • 3
1
vote
0 answers

Creating dataframe from column names list and data which have blank spaces

Using GOOGLEFINANCE() API on Python, I readback response shown in attached snapshot. I would like to arrange this readback response as a dataframe. Using the code below, I extract the columns and data from response. Do notice that columns, as well…
Sinha
  • 431
  • 1
  • 5
  • 12
1
vote
1 answer

How to prevent GOOGLEFINANCE from recalculating?

I'm using a GOOGLEFINANCE formula, but it keeps updating. I would like it to stay a fixed amount once it has been calculated the first time but I can't seem to figure out a way to do that. I tried Googling for the answer but came up empty-handed. I…
user8702720
  • 115
  • 1
  • 9
1
vote
1 answer

Google Sheet QUERY to get last result

Example - https://docs.google.com/spreadsheets/d/12yO_19wa1awqyQ24EZ7wKzYLBdAX8JdnSFw0TZXG9CI/edit#gid=1852644092 i wanted to get the lowest price in the last 90 days then get the date corresponding to that fist i tried =(QUERY(A:D; "SELECT A WHERE…
Bruno Carvalho
  • 183
  • 7
1
vote
1 answer

Convert IMPORTXML data to single currency, export max value via IMPORTRANGE

I'm using IMPORTXML to import prices from a certain website, but they are sometimes in USD and sometimes in GBP. Is there a way for me to import the max value (Converted to EUR) into my main sheet? Here are the sheets in question:…
DoCu99
  • 25
  • 6
1 2 3
…
27 28