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
0
votes
1answer
12 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. =MAX(QUERY(GOOGLEFINANCE("NSE:INFY", "ALL",06/...
2
votes
1answer
62 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(...
0
votes
0answers
9 views

Google finance condition to take 1 year return or from listing date

I am using following query to get 1 year price change percentage for a list of stocks,but some stocks were not available 1 year ago ,some got listed during the year. How can I modify the query to ...
0
votes
1answer
29 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 ...
0
votes
0answers
15 views

Google Finance automatic daily updating

I am creating an index that follows several tickers from 2014 to the present (daily data) by using Google Finance in Google Sheets. I want to add all of the tickers' new prices at the end of each of ...
1
vote
1answer
57 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 ...
0
votes
1answer
39 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 | +------...
0
votes
0answers
43 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,...
0
votes
0answers
15 views

Can Google Finance report daily closing historical data across columns rather than across rows?

I have a sheet setup with my STOCKS on each row in column C. I track the market daily and in the past would enter closing data manually. I have a column for each date. I would like to use the ...
1
vote
0answers
55 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: ​...
0
votes
0answers
54 views

How to use Google Finance to query a stock price during a specific time period

I'm trying to get the high and low price for particular tickers during the after market and premarket hours. Is there a way to query google finance for highs and lows between the after hours of 1:00-5:...
0
votes
0answers
28 views

Data from Investing.com to Google Finance

Question is How to get & interface LIVE or DELAYED trading data of any instrument from Investing.com to Google Finance . Used the suggest process already being shared at this site for but unable ...
2
votes
1answer
1k 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 ...
1
vote
1answer
113 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"), ...
1
vote
1answer
448 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 ...
0
votes
0answers
31 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 ...
0
votes
0answers
143 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 ...
0
votes
1answer
427 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(...
0
votes
1answer
73 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 ...
0
votes
1answer
74 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),...
0
votes
2answers
687 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 ...
1
vote
1answer
1k 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),...
0
votes
1answer
326 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-...
0
votes
1answer
347 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.
1
vote
1answer
1k 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("...
-1
votes
1answer
177 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. ...
0
votes
3answers
5k 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 ...
1
vote
1answer
1k views

How to get 15 mins high low data from Google Finance?

I would like to retrieve 15 mins High Low data from Google Finance to Google Sheets. But unable to get any formula. Please guide me.
2
votes
1answer
2k 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. =...
0
votes
1answer
49 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: ...
2
votes
1answer
38 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 ...
0
votes
1answer
23 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 ...
1
vote
1answer
3k 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: ...
2
votes
1answer
814 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 ...
0
votes
1answer
2k 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'...
0
votes
2answers
2k 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 ...
1
vote
2answers
3k 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://...
3
votes
3answers
3k 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 ...
1
vote
0answers
382 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: ...
2
votes
1answer
3k 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?
0
votes
1answer
1k views

Google Spreadsheet Stock Sparkline Trend Conditional Formatting

I am trying to do a Sparkline whose color changes based on the trend and for some reason the if clause which gets its input from google finance isn't working =sparkline(query(googlefinance($C5, "...
0
votes
3answers
3k views

googleFinance calculating the standard deviation of a stock over a time period

Can I calculate the standard deviation of a stock over a time period in GoogleFinance? https://support.google.com/docs/answer/3093281?hl=en-GB
0
votes
1answer
2k views

How to get Google Finance Intraday data into Google Spreadsheet?

I want to import data from following link into Google Spreadsheet https://www.google.com/finance/getprices?q=BANKBARODA&x=NSE&i=900&p=1d&f=v&df=cpct&auto=1&ts=...
3
votes
4answers
16k views

How to get close price for last date market was open?

When using the GOOGLEFINANCE formula to get historical prices and performance for different periods, if the date used in the formula is one where the market was closed the formula returns #N/A. This ...
6
votes
1answer
8k views

Stock Sparkline for today/hourly

I am trying to make a sparkline graph in Google Sheets that tracks the stock price of TODAY using google finance as time progresses. For example, at 8am it would show the opening price, and by close ...
3
votes
2answers
7k views

Automatically store updated GOOGLEFINANCE values with a script

Hello, I want to keep track of the profit of the combination of many stock values. To do that I have my google Spreadsheet with many formulas calculating the profits or losses ratios taking into ...
6
votes
1answer
7k views

Remove Header from GOOGLEFINANCE query [duplicate]

I want to create a graph with different stock values starting and ending at a certain day. To do that I create a table like this: Where the first column is the market and the second one is the ticker ...
1
vote
4answers
44k views

Google Finance API call for stock dividend (Yield)?

Is there an API call to use in a Google Spreadsheet to get a stock's Dividend Yield (% annual yield)
2
votes
1answer
397 views

How to add refreshed data to new column in Google Sheets

I am making a Google Sheets app that reads column A which has a stock symbol and puts the price in the column to the right using =GOOGLEFINANCE I have this refreshing every day and appending to the ...
1
vote
1answer
446 views

Google Finance / Spreadsheets

I have been trying to get Net Assets and 1 Week Return for SPY on Google Spreadsheets but keep ending up with #N/A. I have been following the information from this sheet but have yet to figure out ...