Questions tagged [google-finance]

For questions about Google Finance - service focusing on business news and financial information. Can be applied also on Google Sheets' GOOGLEFINANCE function.

Filter by
Sorted by
Tagged with
2 votes
1 answer
192 views

Append Current Stock Stock Price to Historical Prices

I'm looking to append the current share price of a stock to the end of a period with changing durations. My current formula for the historical prices is (where cell B3 is a duration of days to ...
Catalyx's user avatar
  • 227
0 votes
0 answers
91 views

How can I solve this formula?

=index(importhtml(concatenate("https://finance.yahoo.com/quote/";A6;"/key-statistics?p="A6";"EN_US");1;2) A6 is tiker: MO I need Dividend date: Oct 10, 2022 Original ...
Mateus's user avatar
  • 23
0 votes
0 answers
705 views

Google Finance Sheets: Dividends and Stock Splits

I am building a Google Finance Spread Sheet for my portfolio and curious about a few things. Generally, I am trying to calculate the monthly returns for each month and essentially outputted the ...
P. Chau's user avatar
0 votes
1 answer
209 views

How to make formula based off a withholding table?

I have been attempting to make a formula to easily calculate federal income tax rates. The picture attached is the withholding table that I've transferred onto a sheet. These are the thresholds I am ...
John's user avatar
  • 1
3 votes
1 answer
1k views

What ticker symbol to use for the crude oil price?

Which ticker symbol can I use for the crude oil price for the GOOGLEFINANCE function? Nasdaq Brent oil is "BZ:NMX" https://www.nasdaq.com/market-activity/commodities/bz:nmx Nasdaq Crude oil ...
Russell England's user avatar
0 votes
0 answers
460 views

Google Finance returns currency for US stocks but not others (for example UK)

Google Finance, in Google Sheets, works for US stocks but not others (for example UK). US stock: msft =GOOGLEFINANCE("msft","price") works =GOOGLEFINANCE("msft","...
D.L's user avatar
  • 101
0 votes
1 answer
80 views

How do I retrieve historical currency exchanges rates (USDEUR) in Google Sheets?

I am not quite sure how to get historical exchange rates from Google Sheets. It is the start date and number of days, daily/weekly that is confusing to me. I was able to get the current exchange rate, ...
Sun's user avatar
  • 870
0 votes
0 answers
68 views

How to create a google sheets formula to return a value based on % values in other cells & weighted average formula? (FIXED)

I've been trying to create a scoring system for expected stock market returns - Sheet I'm having problems creating a formula to firstly give stocks a score in multiple conditions for example SS I want ...
Cristian Gabriel's user avatar
0 votes
2 answers
2k views

How can I include two formulas in a single cell in Google Sheets?

I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include the daily price and percentage change in a single column. I found a helpful Docs Editors ...
1dareu2mov3's user avatar
2 votes
1 answer
2k views

How do I get GOOGLEFINANCE to return only the date and not the date and time of stock price history?

=GOOGLEFINANCE("NASDAQ:GOOGL","close",date(2021,1,1),today(),1) returns closing history in two columns "Date" and "Close" since Jan. 1, 2021. The date column ...
MrSnrub's user avatar
  • 121
0 votes
1 answer
708 views

google sheets get stock in specific currency

To track stocks I made an overview of bought and sold stocks, and generate a pivot table with the current amount of stocks owned. I want to calculate the total value of my stocks. The problem I have ...
Sven van den Boogaart's user avatar
-1 votes
1 answer
41 views

Smallest number recorded in a cell

A value in a cell that changes automatically (using Google Finance), I want to record the lowest value in another cell.
user274212's user avatar
0 votes
1 answer
3k views

How to get a YTD dynamically in Google Sheets (Google Finance)?

I want to display the YTD of a stock listed in C. =(GOOGLEFINANCE(C5,"price")/INDEX(GOOGLEFINANCE(C5,"close","01/01/2021", today()),2,2))-1 I do not want to change "...
Cold Avenue's user avatar
0 votes
1 answer
550 views

How to Run a Query in Google Sheets for New 26-Week Highs 2 of Last 4 Days Using GOOGLEFINANCE Function

I already have a query that returns a list of 26-Week Highs (from a sheet with my list of stocks (Column A), column of today's high (Column B), column of 26-Week High (Column C)). I'd like to have a ...
Jeff's user avatar
  • 1
0 votes
1 answer
191 views

To fetch stock price day's high and low for a range of days including today

For shares listed on NSE I am unable to get Day's high and low while using below query if the start day and end date is same or today. High: =MAX(QUERY(GOOGLEFINANCE("NSE:INFY", "ALL&...
Himanshu Shekhar's user avatar
2 votes
1 answer
869 views

GOOGLEFINANCE in Google Sheets to get high & low and timestamp of high/low from the day I took trade

I wanted to keep a track of high/low of a trade from the day I took the trade. For a day I am able to get high/low but how to get from the date I took my trade which is stored in one of cell. =IFERROR(...
Himanshu Shekhar's user avatar
0 votes
1 answer
731 views

SPX 500 Monthly Return Google Finance

I need to formulate the SPX500 return from "x start date" to "x end date". I have managed to figure out "x start date" to current date (year to date return) but I cant ...
Connor Worrall's user avatar
1 vote
1 answer
307 views

Get historical stock price in another currency

This formula returns the daily stock prices of A1 in the last two years: =GOOGLEFINANCE(A1,"Price",today()-(365*2),today(),"DAILY") This formula returns the daily conversion rate ...
Simone Romeo's user avatar
0 votes
1 answer
268 views

How to get AUD price of bitcoin at a particular date using GOOGLEFINANCE

I am trying to find out how to get the price of bitcoin, ethereum, litecoin and bitcoin cash in AUD at a particular date. I have a table as follows +------------+-------+ | Date | Price | +------...
James's user avatar
  • 101
0 votes
1 answer
187 views

Appending current Share Price to Historic Daily Share Price on Google Sheet GOOGLEFINANCE Function Sparkline

I have a sparkline for the daily price for the last 30 days for a share in google sheets using the following formula (F1): F1 =SPARKLINE(GOOGLEFINANCE("GOOG","price",Today()-30,...
Alex Harrison's user avatar
1 vote
0 answers
738 views

Google Finance in historical mode (WEEKLY): extra rows and not always aligned to Fridays

I am trying to use GOOGLEFINANCE function to query the weekly close price of an instrument (SP500, ticker ".INX"), for the last 52 weeks. I first tried using the following formula: ​...
pablolo's user avatar
  • 11
2 votes
1 answer
4k views

How do I pulling in historical daily trade volume data in Google Sheets with Google Finance?

If I try =GOOGLEFINANCE(A1,"volume",A2) where A1 is the stock code and A2 is the date I'm querying, it comes back printing 'date' and 'volume' on one line as headers and then the data on the ...
Charlie's user avatar
  • 21
1 vote
1 answer
355 views

How to link cell within googlefinance formula

I'm trying to get the googlefinance formula to work for multiple country exchanges. e.g. Tencent is listed on Hong Kong stock exchange, the code is 0700. If I put =googlefinance(HKG:0700,"price"), ...
Alex Teo's user avatar
1 vote
1 answer
1k views

Google Finance Historical Data with Multiple Attributes? (Dates, high, low, close,)

I'm using this formula: =ARRAY_CONSTRAIN(GOOGLEFINANCE("NYSE:"&A4, "all", DATE(2020,4,1), DATE(2020,4,30), "DAILY"), 2, 4) I'm only getting one column for April 1, 2020. I would like to get ...
Jorge Arbelaez's user avatar
1 vote
0 answers
160 views

Script to send email when a cell value is changed automatically by GOOGLEFINANCE function

I have a column of values that pulls data from GoogleFinance using the =GOOGLEFINANCE function in Google Sheets. When the function is working, the column will return a series of figures. Occasionally, ...
David M's user avatar
  • 11
0 votes
0 answers
92 views

List with all cryptocurrencies available in the GOOGLEFINANCE formula?

I tried to find some documentation on what cryptocurrencies are retrievable with the GOOGLEFINANCE formula, but I couldn't find any. There's only this general helpsheet on the topic, which doesn't ...
Paul Razvan Berg's user avatar
0 votes
0 answers
324 views

Currency Conversion, Array Formula, Google Sheets

I was hoping to use array formula in conjunction with Google Finance to convert currencies on specific dates. I've been using a google form to enter basic expense information and the form adds a new ...
Galeano's user avatar
0 votes
1 answer
2k views

How can I get GoogleFinance to see the return of a stock from a specified date range?

How can I see the percentage of return from a stock from a specified date range to today? For example: February 19, 2020 to today = -31.93%. So far I have: =GOOGLEFINANCE("GOOG","price") / index(...
Jordan's user avatar
  • 11
0 votes
1 answer
781 views

How can I get stocks' historical high, low, and close prices?

How can I retrieve historical stock prices in Google Sheets? I'd like to be able to return historical weekly and monthly high, low and close prices.
Dan's user avatar
  • 1
1 vote
1 answer
114 views

Google Finance function returns Date not Currency Conversion

I am trying to calculate the USD:AUD conversion from M3 and show the result of the current conversion rate in the next cell, but it is only resolving the date I am trying to get cell M3 to convert to ...
Shelby's user avatar
  • 11
2 votes
1 answer
190 views

how to get max high of the given days excluding weekly off days

Can any one help how to get maximum high of given days excluding weekly off days (sat/sunday) from google finance. I am using formula like: =query(GOOGLEFINANCE("NSE:"&Y3,"high",(TODAY()-55),...
Prodip 's user avatar
0 votes
2 answers
2k views

Google Sheets - Historical Data not returning yesterday

The formula below is been used to get the historical data until today: =GOOGLEFINANCE("GOOG","ALL",DATE(YEAR(TODAY())-1,1,1),"12/05/2019","DAILY") Unfortunately I don't receive today's data (until ...
FabianoLothor's user avatar
1 vote
2 answers
3k views

Why does close price results have a date shift (one day off) while using GOOGLEFINANCE in a Query

I want to get last 40 days close price of stocks. I used below formula for the same but the result not showing the last day close price. =QUERY( GOOGLEFINANCE("nse:"&B2,"all",$A$2-80,81),...
Altaf's user avatar
  • 11
0 votes
2 answers
395 views

Having trouble outputting GOOGLEFINANCE data

My wish is to create a table in Google sheets looking something like this: price day A B C D ... Z 1997-01-02 132.54 . . . . 1997-01-...
Daniel's user avatar
  • 1
0 votes
1 answer
1k views

Google sheet formula for previous 7 day high

Need a formula for previous 7 working day high for a share =INDEX(GOOGLEFINANCE("nse:"&A2, "high", TODAY()-3.3), 2, 2) Used the above formula but I need only workday formula.
Arun kumar's user avatar
1 vote
1 answer
2k views

GOOGLEFINANCE in Google Sheets to get high & low and timestamp of high/low

I'm using Google Finance calls in Google Sheets for some calculations. I've got 2 formulas, one to find the low price, and one to find the high price from a certain date: =MIN(INDEX(GOOGLEFINANCE("...
mainstringargs's user avatar
-1 votes
1 answer
434 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
James Blake's user avatar
0 votes
4 answers
15k views

Google Sheets formula to find previous day high of a share price

Need previous day high/low price of a share. This formula gives answer =googlefinance("nse:"&columno.,"high",today()-2.1) This gives an answer with date and time in separate columns. But I need ...
Arun kumar's user avatar
3 votes
1 answer
5k views

Google Finance Historical Data with Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($N$2)),TODAY(),"DAILY") The above code returns OHLC data for specified days with the date column. What I want are only high, low and close columns. =...
Bhavesh Pamecha's user avatar
1 vote
1 answer
116 views

Fetch value of a cell based on dropdown menu items results on another sheet

I have 2 Sheets named as Sheet1 and Sheet2... Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column. Sheet2: ...
Rahul's user avatar
  • 11
2 votes
1 answer
45 views

Google Exchange Rates build

I am trying to make a currency exchange rate Google sheet. I want a cell to give me a value of conversion based on the value of another cell. Currency type can be selected from the Dropdown List and ...
sub0's user avatar
  • 59
0 votes
1 answer
33 views

How can I have a 2nd function start in the cell after the output of the 1st function?

So the problem I am trying to solve is where I have Google finance fetching the price of a stock and outputting it, but the length of cells of its price history is increased by 1 each day. In the ...
Sam's user avatar
  • 1
1 vote
1 answer
4k views

How to import historical open price in Google Sheets with GOOGLEFINANCE?

For some reason, I can't get the google finance function to work with any open-price lookups I do. For example: =GOOGLEFINANCE("AAPL","priceopen", DATE(2019,4,12)) comes back as #N/A with message: ...
dlight's user avatar
  • 113
3 votes
2 answers
2k views

I want to get rid of google finance disclaimer

I want to get rid of Google finance disclaimer. I used the =GOOGLEFINANCE formula in a sheet. It triggered the display of a disclaimer at the bottom of the sheet that says: Quotes are not sourced ...
ridertiger's user avatar
2 votes
1 answer
5k views

How can I use GOOGLEFINANCE to return a share price in a certain currency?

I have shares in different currencies that I want to track in only a single currency. I currently have a cell that returns the currency and one that returns the price, I then multiply them. However, I'...
Eric's user avatar
  • 21
0 votes
2 answers
7k views

How to get price of specific cryptocurrencies at specific times?

I have an assortment of cryptocurrency transactions over time. Various currency pairs at various prices. I need to figure out what the price of those currencies was, in Bitcoin, at the time that I ...
JVC's user avatar
  • 1,212
1 vote
2 answers
4k views

Import Bitcoin price in EUR using the IMPORTXML fucntion

Hello does anybody know how to import the Bitcoin price in euro into a Google Sheets document by using the IMPORTXML function? I am as far as I get the Bitcoin USD price - =IMPORTXML("https://...
Mr.Man's user avatar
  • 13
3 votes
3 answers
4k views

Automatic currency conversion in Google Sheets

I have a personal accounting sheet that is mainly accounting in Euros, but for every manual Euro (EUR) entry I do, I want to have that entry converted to USD in the previous column next to it ...
Ryan Smith's user avatar
1 vote
0 answers
497 views

How to see Sparkline for Mutual Funds using googlefinance?

In Google sheets when I try to plot the mutual fund price for the last one year using sparkline function, I keep getting an error. When evaluating GOOGLEFINANCE, the query for the symbol: ...
Manuj's user avatar
  • 11
2 votes
1 answer
4k views

How can I get ''OHLC'' data rather the Close only?

=GoogleFinance("CURRENCY:EURUSD","all","1/23/2005","50") The code above just fetch the close rate and leaves the other columns blank. How to fix that?
Rana's user avatar
  • 21