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
2 answers

Use a sheet name based on Column Value

Using Google Sheets or Excel: I have columns (B) with Stock symbols, e.g.: B2=GOOG, B3=AAPL, B4= MSFT I have Sheets named with these same stock symbols respectively. Eg: Sheet2: GOOG, Sheet3: AAPL, etc I have a formula on Sheet1 that does some…
user3705100
  • 45
  • 1
  • 6
0
votes
1 answer

Python: Running multi variables using the same function at the same time. New to Python

I've been working with python for the past few days, and started working on a project. Currently trying to figure out how to execute the same function using multiple variables (In this case, Stock symbols). Preferably with one input() separated with…
JakeLH
  • 1
  • 1
0
votes
1 answer

pandas data reader function for google finance can be really slow

I am trying to get google finance data for stocks. However, sometimes it hangs and takes 30 seconds to a minute, and sometimes it runs in less than 5 seconds. from pandas.io.data import DataReader from datetime import datetime stock =…
Bluegreen17
  • 983
  • 1
  • 11
  • 25
0
votes
0 answers

how to overrule / skip items in a list that cause error

Below is the python script i'm working on to pick out the stocks that meet certain price criteria (as written, tickerlist=[]collects tickers of the stocks whose max price and min price were >30 and <2 respectively.) import matplotlib.pyplot as…
stratofortress
  • 453
  • 1
  • 9
  • 21
0
votes
2 answers

python stock price real time data feed (script debug)

i'm just beginning to learn to code and i want to apologize in advance if this question is trivial. ive been trying to find a way to feed stock market data into python real time and came across this blog …
stratofortress
  • 453
  • 1
  • 9
  • 21
0
votes
1 answer

Problems with class "financials" in R

I am trying to extract income statements from Google using quantmod. It works perfectly fine with US stocks but I ran into trouble when I tried non-US stocks (e.g. stocks from Hong Kong). For example: #US stocks: (no issues here)…
Adrien
  • 151
  • 1
  • 8
0
votes
1 answer

Use cell reference inside google spreadsheet function

I am using Google Spreadsheet function. This formula works fine. =ImportXML("https://www.google.com/finance?q=SHA:000001", "//span[@class='pr']") The string SHA:000001 is contained in cell B4. I would like to use cell reference. So, I changed to…
guagay_wk
  • 26,337
  • 54
  • 186
  • 295
0
votes
1 answer

Use GoogleFinance Currency Conversion on Sum

I'm trying to use GoogleFinance currency conversion on a sum but can't get the correct format. My cell is as follows: =SUM(((IMPORTRANGE("sheet-key","H2:H300"))/100*40)+(IMPORTRANGE("sheet-key","H2:H300"))) I want the results of the sum to be then…
d1ch0t0my
  • 443
  • 7
  • 22
0
votes
1 answer

Excel VBA LOOP - Setting a variable's value by looping on another sheet's cells

Shortened the post. Complete code in the attached excel file. Need help with correcting the looping code so that Variable gets value from a cell of another sheet repeats after certain process. What's working correct already:: For a Single…
Vaibhav
  • 123
  • 8
0
votes
1 answer

Getting jquery data to populate table column

I am trying to get a javascript stock ticker to work, it is going well but my knowledge of javascript is at a beginner level. The current code (top example) pulls out live stock data using the google finance API. It checks to see the stock acronym…
user3036451
  • 25
  • 7
0
votes
1 answer

Creating Javascript tables for stock ticker

I am trying to get a Javascript stock ticker to work, it is going well but my knowledge of Javascript is at a beginner level - but I'm learning! The current code pulls out live stock data using the google finance API. It checks to see the stock…
user3036451
  • 25
  • 7
0
votes
2 answers

javascript live stock ticker pulling wrong name

I currently have a javascript stock ticker which pulls out live stock data. I really want the company name aswell as the stock acryonm but i am struggling to get this working. One way which I have done this is by forcing the stock name in text. it…
user3036451
  • 25
  • 7
0
votes
1 answer

Annuity spread over 360 Vs 12 month

So here is my problem - I have pmt function in excel - A) rate daily 10/100/360 number of terms 360 Present Value 100000 Future Value 0 Advance/Arrear 1 pmt= $291.86 I created mortgage based on above pmt for 360…
NewToNet
  • 191
  • 1
  • 3
  • 10
0
votes
2 answers

Retrieving Stock Data using Google Finance 0.5 pypi

I downloaded the Google Finance and was wondering how I could extract specific values versus all of them. This is the example given: >>> from googlefinance import getQuotes >>> print json.dumps(getQuotes('AAPL'), indent=2) [ { "Index":…
user4723143
  • 1
  • 1
  • 1
0
votes
2 answers

Google Finance JSON does not work with more than 1 symbol

I'm using PHP and JSON from Google finance to get real-time stock updates/quotes using http://finance.google.com/finance/info?client=ig&q=GOOG (this is just an example) My code works fine with above mentioned link (because it only has one stock…
Amit
  • 187
  • 2
  • 15
1 2 3
…
27 28