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

ARRAYFORMULA to get stock price on dates from adjacent column using googlefinance in googlesheets

I trying to get the stock price on ceratain dates that are in a colunm A from A2 to A5. The numbers of rows is based on a formula. So I might have dates from A2 to A50. The formula to get the stock price that I am using is…
CoolJack4u
  • 1
  • 1
0
votes
1 answer

How monthly moving average in google sheets?

I am trying to make a system that update moving average from google sheets. Such as 3 months moving average. Average of 2022-03-13, 2022-02-13, 2022-01-13. The problems are below: GoogleFinance function does not provide "monthly" interval. It…
JGPARK
  • 57
  • 6
0
votes
1 answer

Is there any way to define an exchange in Google Finance separately?

I have stocks from US and Canadian Companies. I would like to be able to enter the stock symbol and select the exchange in the adjacent column and put the google finance formula and get the current ticker price. Currently the only way I can get this…
TCH Tank
  • 3
  • 1
0
votes
1 answer

Google Finance Tesco

I am using GoogleFinance() function in Google Sheet for some stocks statistics, but I have problem with some tickers like Tesco (London). If I try GoogleFinance("TSCO", something), I get values of Tractor Supply Company (NASDAQ), because both are…
Martin Galda
  • 3
  • 1
0
votes
2 answers

What is the time unit for "datadelay" attribute on GoogleFinance?

I'm using the GoogleFinance() functions on a Google spreadsheet to keep track of my stocks. With the "datadelay" attribute I can check how long ago the data has been updated for the last time. But it only returns a raw number, like "54000" for one…
Walrus
  • 21
  • 5
0
votes
1 answer

Google-finance : How can I extract historical data in a defined date rance

Im going to back-testing using goolge finance. but it doesn't working. How can i solve this problem. Ticker : B2 Start date : B3 End date : B4 =googlefinance($B$2,"All","b3","b4","daily") enter image description here
Rhys Jung
  • 1
0
votes
2 answers

What formula can I use in Google Sheets to find the lowest historic price of a stock?

I want to use Google Sheets to find the lowest price a stock has reached between two dates, or the lowest it has fallen in its life. I have tried various formulas but none have worked. Is there a way to do this? Thanks, Nick
Nick
  • 29
  • 1
  • 4
0
votes
1 answer

Google Finance Stock Screener - Python (Scrapy)

I am trying to scrape stock prices from google finance using scrapy. The code is not showing any errors but the output file is coming out to be blank. Pasting the code below: import…
Anikan
  • 13
  • 2
0
votes
1 answer

Fetch element using ImportHTML with XPath in Google Sheet

I'm trying to use the google-sheets IMPORTHTML() function to get the text inside of a from a website. What xpath argument do I need, in order to produce the output: Score 50?
Sivakumar Piratheeban
  • 493
  • 4
  • 11
  • 39
0
votes
1 answer

"return52" is invalid for the specified symbol(Google Spreadsheet + Google Finance)

On using GoogleFinance macros in Google Spreadsheet , "return" attributes for 1,4,13,52 week return provides the following error: Code : =GOOGLEFINANCE("AAPL","return52") ERROR: Function GOOGLEFINANCE parameter 2 value is invalid for…
srt111
  • 1,079
  • 11
  • 20
0
votes
2 answers

Pulling current price change % (Google Finance) with Google Apps Script

I'm trying to pull current price change % from Google Finance with Google Apps Script. With the following coding, I couldn't figure out why it doesn't pull current price change % (0.72%), though it retrieves "After Hours" price change % (0.081%). …
Newbie
  • 247
  • 3
  • 11
0
votes
1 answer

Querying Price for a Stock at a Particular Date Time

I can fetch the price of a stock using this: =INDEX(GOOGLEFINANCE("GOOG","price","12/13/2020"),2,2) However how to I query price at a particular date and time. I am open to use anything: GOOGLE, EXCEL etc. etc. I am looking at NSE and BSE exchange.
CuriousDev
  • 1,255
  • 1
  • 21
  • 44
0
votes
1 answer

Financial Data from FinViz using IMPORTHTML

I am trying to export financial data - Net Income, for instance - using FINVIZ on this page: https://elite.finviz.com/quote.ashx?t=A&ty=c&p=d&b=1 I am able to grab other information from this page using the following…
Beth Reynolds
  • 1
  • 1
0
votes
0 answers

The google sheet script is not able to read and paste updated data from GOOGLEFINANCE()

The problem started a month ago, Some of the older sheets, where I get a list of stocks, and calculate moving averages, bollinger band values etc, in form of a table through googlesheets script. It used to do 4-10 stocks per minute when I created…
Finance_Himanshu
  • 1
  • 1
0
votes
1 answer

Can the Yahoo Finance Api retrieve Index data(specifically Nifty)?

I wanted to retrieve Index spot data for indices, however can't find any solutions. Does the Yahoo Finance api provide the ability to do this, and if not are there any viable alternatives?
MrOmnipotent
  • 5
  • 4
1 2 3
…
27 28