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
7
votes
4 answers

Possible to use Google Spreadsheet functions in Google App Script?

I just discovered Google App Scripts, and I'm stumped on something already... I am trying to write a script for a Google Spreadsheet which finds certain historical stock prices. I found that the FinanceApp service within Google App Scripts has been…
marko
  • 73
  • 1
  • 4
7
votes
3 answers

How to work with Google Finance?

I want to develop a small application to get stock price from Google Finance automatically and store it in my local machine for future analysis. Can anyone give me some clue how to get started? I know some C#. Will it be suitable for this…
Edward D.
  • 1,431
  • 3
  • 11
  • 5
6
votes
2 answers

How to integrate GOOGLEFINANCE results in an array formula?

Following ARRAYFORMULA is giving me an error "parameter 1 value is invalid." =ARRAYFORMULA(IF(ISBLANK(B2:B), "", GOOGLEFINANCE(B2:B, "price"))) B column of my sheet contains the stock symbols whose value I wish to fill in my sheet. Example…
Varun Bhatia
  • 4,326
  • 32
  • 46
6
votes
1 answer

Ticker symbols supported by googlefinance function

The GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument. https://support.google.com/docs/answer/3093281?hl=en However, the documentation for which symbols it supports is sparse. For…
Dijkstra
  • 2,490
  • 3
  • 21
  • 35
6
votes
3 answers

ArrayFormula with GoogleFinance dynamic date

First of all, i'm not a powerful sheets user :) I'm trying to use GOOGLEFINANCE to calculate amounts in multiple currencies. I use this formula: =IF($A2; IF( $C2:C; $C2:C; IF( $D2:D; …
valentin.mu
  • 93
  • 1
  • 8
6
votes
1 answer

Improving a function to get stock news data from google in R

I've written a function to grab and parse news data from Google for a given stock symbol, but I'm sure there are ways it could be improved. For starters, my function returns an object in the GMT timezone, rather than the user's current timezone,…
Zach
  • 29,791
  • 35
  • 142
  • 201
6
votes
0 answers

Is there a way to interact with google finance data in google app script?

I'm trying to calculate the rate of change in Google finances' data. For example if price of AMD was 2 dollar and tomorrow it was 1 dollars, then the result I want is -0.5. I called the Google finance data using =GOOGLEFINACE function in the Google…
jjunbbug
  • 117
  • 1
  • 6
6
votes
3 answers

'Access-Control-Allow-Origin' Google finance converter gives an error javascript/jquery

I'm working with one project module, where I want to get converted price from Google finance converter based on from currency code and amount. Here is my code: $('.actual-price').tooltip({ content: function(callback) { var url =…
Hina Khuman
  • 757
  • 3
  • 14
  • 41
6
votes
2 answers

How can I trigger an event when this span value changes?

I'm trying to get a console log when the price of the current page's stock changes. page: https://www.google.com/finance?q=NASDAQ%3AGOOG&ei=yvbRVbHSCcKgmAGyu7CoDA Element ID: #price-panel > div > span > span Attempt 1: fail $("#price-panel div span…
Jacksonkr
  • 31,583
  • 39
  • 180
  • 284
6
votes
2 answers

Highstock vs Google Charts in Performance

A) I'm using the Highstock charting library for a finance project of mine. However, I'm getting bogged down in performance issues. My working implementation of Highstock has i) 5 graphs in a chart ii) multiple lines (and line-types) in a graph iii)…
Nutritioustim
  • 2,686
  • 4
  • 32
  • 57
5
votes
0 answers

Google Finance API address has changed

Until yesterday the following URL (Google Finance API) https://www.google.com/finance/getprices?q=TSLA&x=NASDAQ&i=3600&p=5d&f=d,o,h,l,c,v would lead to a nice comma delimited data table with TSLA stock data. Since yesterday, the same call gets…
user3612816
  • 325
  • 2
  • 11
5
votes
2 answers

Leading slashes in JSON from Google Finance API call

I've been using the Google Finance API to successfully gather some stock info. The problem is that after a call to http://www.google.com/finance/info?infotype=infoquoteall&q=[$tickerSymbol], the JSON that Google returns has // added before it and…
Oren Hizkiya
  • 4,420
  • 2
  • 23
  • 33
5
votes
1 answer

Finance API for Android

I am trying to make a new application and I would like to get stock updates, currency exchange updates etc. Can you please suggest some free API for getting these updates? I have already tried : 1) Google Finance API. Reason for not using:…
harshit
  • 3,788
  • 3
  • 31
  • 54
5
votes
3 answers

Obtaining financial data from Google Finance which is outside the scope of the API

Google's finance API is incomplete -- many of the figures on a page such as: http://www.google.com/finance?fstype=ii&q=NYSE:GE are not available via the API. I need this data to rank companies on Canadian stock exchanges according to the formula…
Marco
  • 245
  • 3
  • 6
4
votes
2 answers

How to get China Stock Market Index (SSE) in Google Sheets using GOOGLEFINANCE?

I have searched everywhere but didn't find a way for this. It's for =Googlefinance("ticker"), Is china's SSE index available as a ticker for google finance, to be used in google sheets?
TheOnlyAnil
  • 877
  • 1
  • 15
  • 27
1 2
3
…
27 28