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

Rx - Triggering Stock Price changes in live time?

As an example for a class, I'm trying to figure out the most robust way to create a hot Observable that emits current prices for a given stock ticker, but only have it emit a price when it changes. The best I could come up with on my own is create…
tmn
  • 11,121
  • 15
  • 56
  • 112
1
vote
1 answer

Google Finance Google Sheets ImportHTML to retrieve Financial Statements

I can use ImportHTML in Google sheets to retrieve financial data from Yahoo Finance but it is lacking where Google Finance has the data. For example here is a link to Ford's financials on Google Finance how would I grab this data with ImportHTML in…
CodeCamper
  • 6,609
  • 6
  • 44
  • 94
1
vote
1 answer

How do I get and compare stock quotes from Yahoo! and Google?

How to get a history quote from Yahoo and Google Finance with Perl and save in DB to compare and validate. What´s the best/simple Perl/Windows DB to make this and the Perl/Algoritmo to compare this data?
user477189
  • 21
  • 1
  • 1
  • 3
1
vote
1 answer

Pandas: datareader unable to get historical stock data

I found that some of the stock exchanges is not supported for datareader. Example, Singapore. Any workaround? query = web.DataReader(("SGX:BLA"), 'google', start, now) return such error` IOError: after 3 tries, Google did not return a 200 for url…
vindex
  • 331
  • 6
  • 17
1
vote
1 answer

How to get exchange rate with GoogleFinance on dates market is closed

I can retrieve the exchange rate on a given date with the following command: =GoogleFinance("audusd","price","09/15/2015") However if the market is closed that day then GoogleFinance returns "N/A":…
BigBrownBear00
  • 1,378
  • 2
  • 14
  • 24
1
vote
2 answers

Isolating string in python list

I'm using the google finance module to get stock data in Python. I would like to isolate the LastTradePrice from the list and convert it into an integer. Any suggestions? Thanks. from googlefinance import getQuotes import json stockinfo =…
Bandito
  • 21
  • 2
1
vote
1 answer

prepend a header to .csv file with python

my current code able to fetch historical data from Google finance but missing the first row to label each column. I want the output as below Stock,Date,Time,Open, High,Low,Close,Volume CCK,2015-12-30,00:00:00,1.05,1.05,0.99,1.00,157800 …
bkcollection
  • 913
  • 1
  • 12
  • 35
1
vote
1 answer

Unable to install googlefinance with conda

I just discovered the Anaconda project and think it's AMAZING! I just ran into an issue installing googlefinance, however: Unable to find with a search: (env)me@vm$ conda search googlefinance Fetching package metadata: .... Found with pip: pip…
tarabyte
  • 17,837
  • 15
  • 76
  • 117
1
vote
1 answer

retrieve international investement fund data

I am trying to get financial data on bonds and funds not traded in the US. Example. This is my code: import pandas.io.data as web from datetime import datetime end = datetime.now() start = datetime(end.year - 5, end.month, end.day) df =…
DaCoEx
  • 303
  • 1
  • 7
1
vote
1 answer

Retrieve JSON data returned from GOOGLE FINANCE API URL in android

I am using the following URL to get quotes information of any company. http://finance.google.com/finance/info?client=ig&q=bom:ranbaxy (here ranbaxy is the company). what website or url returns is given below. [ { "id": "672832" , "t" : "500359"…
KarmaCoding
  • 87
  • 3
  • 16
1
vote
2 answers

What is the formula for average daily trading volume calculated by Google Finance formula?

Average daily trading volume is obtained by this formula GOOGLEFINANCE("Symbol", "volumeavg") on Google Spreadsheet. How is the average volume calculated? Based on how many days of moving average?
guagay_wk
  • 26,337
  • 54
  • 186
  • 295
1
vote
2 answers

How to retrieve stock price from Google Finance with 4 decimal places into google spreadsheet?

On google spreadsheet, the price of a stock can be retrieved onto google spreadsheet using the formula GOOGLEFINANCE("stock_symbol", "price"). However, price retrieved is only in 2 decimal places. For international stocks, this is not good enough…
guagay_wk
  • 26,337
  • 54
  • 186
  • 295
1
vote
1 answer

Yahoo finance CSV query no returning january in result

I need to get stock prices from a web service and the only reasonable way i've found is tu use the below query string. The problem is that with the below string the result start in February and not January. Has anybody experience with this service…
jim
  • 8,670
  • 15
  • 78
  • 149
1
vote
3 answers

Is there a way I can import price from google finance into google spreadsheet with 4 decimal places?

I have the formula to retrieve the data from google finance. =googlefinance(D4; "price") I am tracking some penny stocks and some of the prices have a price in 4 decimal places. When I import the price and it only imports the information with only…
OliverTwist
  • 43
  • 2
  • 8
1
vote
2 answers

google finance tools on my website?

i am on the process of building a website execlusively for trading purposes. including live quotes and level 2 quotes. charts. user protofollio with automatic updates. news and so on. am i allowed to use google finance tools on my website? and if…
bilal
  • 11
  • 2
1 2 3
…
27 28