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

344 questions
-1
votes
1 answer

How to specify the currency for GoogleFinance historical data

I'm having a problem using Google Finance historical data. I need to know the price a particular stock had on a particular date (Usually within the last month). The problem is, when I use a URL such as…
Muc
  • 1,352
  • 2
  • 12
  • 29
-1
votes
1 answer

C# .net WebRequest google finance

I'm using google finance to convert a currency to another. The code that I'm using is shown below which was working fine. However, today, I'm facing the IndexOutofrange exception and getting a result of -1 for the indexes searched below (which means…
Nassif Bousaba
  • 357
  • 3
  • 17
-1
votes
1 answer

Yahoo finance or google finance will block if i will subscribe all stocks?

I want to retrieve all stocks from few exchanges - by retrieve the stocks that inside those exchanges (by taking from http://www.nasdaq.com/screening/company-list.aspx). And then I will quote for all stocks from google or Yahoo. My question is if I…
David Michaeli
  • 367
  • 2
  • 21
-1
votes
1 answer

Calculator input change to unrounded result

Having this currency calculator, when a natural value is inserted user gets relevant currency well, however when inserted a number such as 8.5 or 4.3 etc... You get a rounded result. how do I change this and show accurate result (2 digits after…
eyalix
  • 120
  • 1
  • 1
  • 17
-1
votes
1 answer

Using file_get_contents() / cURL or API to get financial data?

I'm fetching market data from both Google Finance and Yahoo Finance but struggeling with an issue. Google Finance http://www.google.com/finance/info?q=NASDAQ:GOOG Yahoo…
Treps
  • 760
  • 3
  • 11
  • 27
-1
votes
2 answers

Can't parse Google Finance html

I'm trying to scrape some stock prices, and variations, from Google Finance using python3 but I just can't figure out if there's something wrong with the page, or my regex. I'm thinking that either the svg graphic or the many script tags throughout…
Slpk
  • 23
  • 5
-2
votes
1 answer

Automatic data record in Google Sheets

I receive the data on the P/E multiple in Google Sheets via GOOGLEFINANCE in the following manner: =GOOGLEFINANCE("GOOGL","pe") How to write script in Google Sheets that would record the P/E values (or better the values of a particular cell) every…
MariaMaria1
  • 25
  • 1
  • 6
-2
votes
1 answer

how to slice bytes object when i try to slice it give me int number?

I am trying to get live tick from google finance site using urllib,request but it returns a lot of data but I want to select the only price so how do I select that without using loops **I want that thing from HTML ["INFY","Infosys…
Lakhan Pahuja
  • 47
  • 7
-2
votes
1 answer

How to Obtain Google Quotes in KMyMoney?

In order to retrieve the stock quote from Google Finance in KMyMoney do the following: Goto https://finance.google.com and obtain the symbol, example "NASDAQ:GOOG" Open KMyMoney, goto Settings->Configure kMyMoney->Online Quotes Click on the "New"…
Suresh PB
  • 101
  • 1
  • 13
-2
votes
1 answer

Yahoo / Google finance JSON not working in Chrome

This is my JS code. This works perfectly in IE. If I paste the request link in browser then I do get JSON reply but when I run this code. I do not get any reply for either Yahoo or Google requests. Works very well in IE though. //var url1 =…
Nikhil Redij
  • 1
  • 2
-3
votes
1 answer

Get daily stock movement in %

My goal is to get daily stock movement in % as follows in Google Sheets: name 1JAN 2JAN 3JAN 4JAN 5JAN ------------------------------ GOOG 1% 2% 1% 2% 1% BABA 2% 1% 3% 5% 6% Can anyone pls advice. I am new to Google finance.
asdasd
  • 2,502
  • 2
  • 9
  • 23
-4
votes
1 answer

JSON parsing of finance.google.com result

I'm not getting how to parse finance.google.com results, i.e. I got [ { "id":"787381", "t":"HDFC", "e":"NSE", "l":"1,424.00", "l_fix":"1424.00", "l_cur":"₹1,424.00", "s":"0", "ltt":"3:46PM…
Gireesh Bhat
  • 139
  • 1
  • 1
  • 6
-4
votes
1 answer

save stocks historical data into stock name.csv using python

I used python 2.7 to fetch historical data from Google finance. I would like to save the output in .csv with the stock individual names. Example, AAPL.csv,MSFT.csv and etc. Since I have 900 stocks in the list, I use a for loop to name my file but…
bkcollection
  • 793
  • 9
  • 29
-7
votes
1 answer

Is it possible to extract everyday stock closing price in Python and store them to Excel?

Is it possible to extract closing prices of stock market and dynamically write them into an excel sheet using python? Example: Can I get GOOG, AAPL, MSFT, AMZN everyday closing stock prices from Google-Finance or Yahoo!-Finance and write them…
SandB
  • 11
  • 3
1 2 3
…
22
23