Stack Overflow
Stack Overflow

Questions tagged [google-finance-api]

API used to query information about portfolios stored in Google Finance. Note this API was deprecated in May 2011 and will be permanently shut down on October 20, 2012.

API used to query information about portfolios stored in Google Finance.

Note this API was deprecated in May 2011 and will be permanently shut down on October 20, 2012.

https://developers.google.com/finance/

92 questions
2
votes
3 answers

Google Sheets - googlefinance not working

I have one google sheet using googlefinance function on multiple stocks. It was working fine until this morning. Now, googlefinace is not giving output for all stocks and giving output for only some of the stocks. Please share, if is anyone else…
Syed Mohammed Mehdi
  • 183
  • 2
  • 5
  • 15
2
votes
1 answer

How to get NSE spot minute ticker data from google finance api?

In previous, I could get all minute ticker from google finance api all like below url http://www.google.com/finance/getprices?q=NIFTY&x=NSE&i=60&p=1d&f=d,c,o,h,l But now google providing only 1 interval data for a day as the daily summary. I think…
Syam Kumar
  • 343
  • 5
  • 16
2
votes
0 answers

Google finance to get the price of a stock for a given date

In Google doc, let's say B5 is "GOOG", C1 is 3/18/2016, D1 is 3/19/2016, E1 is 3/20/2016... How can I get the price for GOOG for each of these dates? I've tired =GOOGLEFINANCE(B5, "price", C1) And I've got a #REF! error: "Array result was not…
Gundam Meister
  • 1,425
  • 2
  • 19
  • 29
2
votes
0 answers

Trouble with Google Finance API

When i am trying to buy shares using google finance api I am getting an exception: run: Enter user ID: ****@gmail.com Enter user password: ****** Enter transaction type: Buy Enter transaction date (yyyy-mm-dd): 2010-03-10 Enter number of shares…
BANSAL MOHIT
  • 51
  • 2
1
vote
1 answer

How to get the 1-hr, 7-day and 1-month percentage changes of a stock with Google Finance/Sheets

I can currently get the 24hr percent change of a stock in Google Sheets by: =GOOGLEFINANCE("NASDAQ:GOOGL","changepct") How do I get the 1-hr, 7-day and 1-month percent changes of a stock(or even a custom amount)?
steve238
  • 831
  • 1
  • 10
  • 19
1
vote
2 answers

Referencing a date from a cell in google sheets

I am trying to track stock prices with Googlefinance function in Sheets. I can pull the price for a date with =INDEX(GOOGLEFINANCE((B2),"price",date(2019,12,13)),2,2) which is fine but I want to input the date with Column A which has date data. So,…
WeedKiller 420
  • 11
  • 1
1
vote
2 answers

How to check stock market is open with Google finance (sheets)

Hi I'm using the GOOGLEFINANCE command in google sheets to return stock prices which is working but when the market is closed it still returns a value (last trade price) - I only want to return a price when the market is open. (this could be USA…
coder787
  • 21
  • 5
1
vote
2 answers

How to fetch price for a specific date from GoogleFinance?

I tried below syntax to fetch the close price of specific date: =GOOGLEFINANCE(,"price","07/09/2020") While it works perfectly for US stocks, the result for Indian stocks are incorrect. For example: if you query for July 9th, the stock…
snehil kamal
  • 13
  • 1
  • 3
1
vote
0 answers

GOOGLEFINANCE: Finding a defined price for a stock at a certain date (whenever that defined price was reached) and returning it to a cell

Thanks for reading this - I'm a beginner with google sheets and hope you can help me finding a solution to my little problem! Here it comes: I want to extract the (historic) date from GOOGLEFINANCE when a stock price has hit a certain price.…
RJ W
  • 11
  • 1
1
vote
1 answer

How to use google Finance API in .Net web application?

Has any one used Google Finance API in .Net 4.0? If not 4.0 any version of .net? Please let me know how to start with and helpful resources, links if any. I need to show Google Finance Data in my web application. I am good at Bloomberg Finance data…
Jigar Pandya
  • 6,004
  • 2
  • 27
  • 45
1
vote
1 answer

GOOGLEFINANCE function - specific instrument returning #N/A

I am trying to use the google finance function within Google Sheets to return the share price for Vital Healthcare Property Trust which is listed on the New Zealand stock exchange. Here is the instrument in question:…
Jake McInteer
  • 11
  • 1
1
vote
0 answers

Google Spreadsheet: Calculate Total Dividend generated from a particular date

I am trying to calculate dividend earned from a stock since it was bought (i.e. from a particular date). Is there a way to calculate sum of every dividend paid out by company since particular date? For simplicity, lets assume that shares were…
alwaysAStudent
  • 2,110
  • 4
  • 24
  • 47
1
vote
0 answers

Google Finance API to retrieve currency exchange rates

Now that Yahoo Finance API is dead, is there any way to retrieve currency exchange rates via Google Finance API (which, afaik, is also not really supported)? I would like to get, for example, EURUSD=X from Google Finance which will now show 1.1600 -…
Summer Son
  • 25
  • 5
1
vote
3 answers

GOOGLE Finance converter api is not responding

I have been trying to convert the currencies using google finance converter in PHP. I have used the following code. $amount = 100; $from_Currency = "INR"; $to_Currency = "BTC"; $amount = urlencode($amount); $from_Currency =…
Bip Inn
  • 31
  • 2
  • 10
1
vote
2 answers

What's the exchange suffix for German and Australian stocks for GoogleFinance API?

What's the exchange suffix for German and Australian stocks for GoogleFinance API? For London stocks, it's .L (e.g. VOD.L). Just wonder what's the suffix for Germany and Aussie? I tried something like .DE for German but it didn't work..(that's the…
Calvin Lau
  • 11
  • 1
  • 2
1 2
3
4 5 6 7