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
0 answers

Google Finance stock market functions update time

I use a Google Finance function to call the SP500 close. I collected with this method the historical data going back a year. The data fills in daily and for every date the function is called. The issue is what time it updates. The market closes at…
Mike T
  • 13
  • 6
0
votes
2 answers

Suppress date and column heading in googlefinance historical data

I'm attempting to get a column of data which represents the highest stock price for a given stock beginning on an arbitrary date, through today. I have a column of ticker symbols in column A, and a purchase date in column B. I want to populate…
Jim Baker
  • 3
  • 3
0
votes
2 answers

How do I calculate the monthly income when taking into account 1 time but also payment in 3 installments

I have a situation where I am receiving payments. There are 2 types of payments 1. Payment in full and 2. Payment in 1-2-3-4 installements. Here you can find an Example sheet of data. I only have the first payments of the installments so for example…
Scraper2022
  • 41
  • 6
0
votes
0 answers

Google sheets - How to import revenue from Google Finance

I have a gsheet, where in the column A there are plenty of listed companies' (from different stock exchanges) tickers. In column B and C I need to have a data regarding Market Capitalization and Revenue for each company respectively. For Market Cap…
Radek19972009
  • 1
0
votes
2 answers

Mismatch Range error on using IFs in sheets

I am using the formula below and getting an error "IFS has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 2, column count: 2." The code is to ignore Sat/Sun and pick High values of Thurs/Fri in case of…
Rinku
  • 81
  • 2
  • 14
0
votes
1 answer

reverse Googlefinance Values - I want descending from the newest to the oldest

I want to get the list of weekly close Values of a Ticker. But they should begin with the newest date. =GOOGLEFINANCE(XYL; "price"; $F$31;HEUTE();"WEEKLY") or =GOOGLEFINANCE(XYL; "price"; HEUTE(); $F$31;"WEEKLY") show the same result. With this code…
Max
  • 25
  • 5
0
votes
2 answers

Google Finance does not show last closing price after market hours. It just shows last *traded* price instead of *closing*

My query is on stock market of India where I fetch the quotes from =googlefinance function in my google sheet. I was very disappointed to know that the function does not show last closing price. Instead, it shows the last traded price. Lets take an…
Sabha
  • 621
  • 10
  • 32
0
votes
1 answer

Google Finance fetch DATE of high and low

I am trying to fetch the dates of the high/low of the last 11 days using the following formula =TO_DATE(INDEX(SORT(GOOGLEFINANCE("nse:BAJFINANCE", "high", today()-11,today(),"DAILY"), 2, 0), 2,1)) =(TO_DATE(INDEX(SORT(GOOGLEFINANCE("nse:BAJFINANCE",…
Rinku
  • 81
  • 2
  • 14
0
votes
1 answer

Finding the average of monthly closing price on Google Finance

With Google Finance, I'm trying to calculate the 12-month moving average of a ticker. For example, I want to retrieve end-of-month closing price for a ticker for the last 12 months and find the average of these values. I've tried to refer to this…
jy2da
  • 45
  • 5
0
votes
1 answer

How would you get 3 month Average Volume for a stock in google sheet?

I am trying to find a more efficient way to calculate the last 3 month volume for a given stock but I cant seem to find a function that would let me do. The other approach was get all volume data and add them and import it in the google sheet but it…
Debuggingnightmare
  • 73
  • 1
  • 9
0
votes
0 answers

Trying to run macro to add formula onto the end of an entire google sheet column

I have recorded a macro that adds formula onto the end of a cell function addpricemultiplier() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('H5:1000').activate(); …
Jesse
  • 1
0
votes
2 answers

How to get price without a sign €/l?

I use this formula to get the data: importXML("https://at.fuelo.net/fuel/type/gasoline?lang=en"; "//table[@class=('table')]//tr") How to get price without a sign €/l?
Tomash Prudków
  • 33
  • 5
0
votes
0 answers

Google sheets: How to get Implied volatility data for stock for given date range

Using the formula below, I am successfully able to find daily stock data for any ticker for a given date range. Is there some way to get (or calculate) the daily implied volatility for the this downloaded data? GOOGLEFINANCE("GOOG", "open",…
Sinha
  • 431
  • 1
  • 5
  • 12
0
votes
1 answer

What column should I assign to parse_dates while working with google finance?

I wrote a code to show a graph from google finance but i got this error: ValueError: Missing column provided to 'parse_dates': 'Date' This was my code: from bokeh.plotting import Figure, output_file, show data =…
Personal Account
  • 13
  • 2
0
votes
1 answer

Appending GoogleFinance while copy data from source sheet to target sheet

I am copying source sheet data to target sheet by using following code (Thanks to Iamblichus). How to append the target sheet data with "=GOOGLEFINANCE(A1,price)" for all rows respectively. I want to copy formula not value of the formula, so that I…
NSW
  • 13
  • 4
1 2 3
…
27 28