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
1 answer

Login to google using Python

I have been trying for some time now to login to my google account and download a file from it without using any external libraries. I am specifically talking about Google Finance (https://www.google.com/finance). All I want to do is login, and…
user1476876
  • 65
  • 2
  • 12
1
vote
0 answers

Google finance request to get volume data

http://finance.google.com/finance/info?client=ig&q=NASDAQ%3aGOOG This returns realtime last price with no delay (like 15 min in yahoo). Is it possible to get current volume of the day from the google finance?
Dork
  • 1,816
  • 9
  • 29
  • 57
1
vote
1 answer

CookieConflictError - APISID when trying to programmatically login to Google Finance

I'm trying to write a script to programmatically login to Google Finance, view my portfolio and then display results on my desktop. I'm using the requests module, currently stuck on the 'login' part. I keep getting this error…
Nathan Kot
  • 2,392
  • 1
  • 21
  • 31
1
vote
1 answer

reformating now() function so it works in GoogleFinance function

I'm using GoogleFinance function in Google spreadsheets to display a chart over the last 5 years. I'm using it as follows: =GoogleFinance(A1;"all";Date(2012,02,08);Date(2013,02,11); "weekly") This works fine. However, I have to increment the two…
Laurence
  • 869
  • 3
  • 12
  • 20
1
vote
1 answer

Visifire line charts

I have a visifire line chart in my silver light project. There are some data points ( lets say 5). I need to show the Y value when I mouse over between the data points . Is there any way to implement this using visifire?. Thanks in…
1
vote
2 answers

Downloading Stock quotes to App

I'm new to iOS programming and want to display stock quotes and stock details in the iPad app I'm designing. I am looking at two options Im looking at google finance or yahoo finance. How would I go about sending a url request to their sites and…
Ashmanq
  • 29
  • 1
  • 4
1
vote
2 answers

How to get Moving Average for each day from Yahoo/Google Finance API?

I need the value of Simple Moving Average for each day for Historical data? Is there a way? Or just for last day? SMA 20-day, SMA 5-day, SMA 50-day All this stuff via API or .csv output
sparkle
  • 7,530
  • 22
  • 69
  • 131
0
votes
1 answer

Stock Beta through API (Preferably in C#)

Anyone know how to get a stock's Beta through an API? (Preferably in C#) I know it's available on Yahoo/Google/Reuters/Bloomberg when you go to their website, but it seems like none of the YQL / Google Finance stock API / other interfaces support…
user1167650
  • 3,177
  • 11
  • 34
  • 46
0
votes
3 answers

Google Finance API in JavaScript or Python to get Currency exchange rate

I am looking to find a API that I can use in JavaScript or Python to be able to eXchange the currency rates. I need the example of using those APIs too. Do you Guys have any Idea how to find it ? JavaScript or Python portfolio and positions…
Emax
  • 1,007
  • 2
  • 13
  • 16
0
votes
1 answer

Creating a stock portfolio in rails

I am new here and new to ruby on rails. I am trying to create a rails app where users can create their own stock portfolios. I want to use the yahoo finance gem but i don't know where to start . I have created the rails login using devise . Any…
0
votes
1 answer

How to get Lowest price of Stock in Google Finance for the past 6 months

I want to use Google Sheets to find the lowest price a stock has reached in the last 6 months. I have tried various formulas: =googlefinance("NSE:RELIANCE", "close", Today()-365,125) it shows full previous year data with date…
Wrathyimp
  • 7
  • 5
0
votes
0 answers

GoogleSheets - Calculate XIRR from different sheet

I have two sheets: Portfolio and Transactions. My transaction sheet looks like this : My portfolio sheet looks like : Here total Market rate refers the current market price of total X stocks.Say, I have a total of 44 HDFCBK stocks, so 44 * current…
usr_lal123
  • 650
  • 12
  • 28
0
votes
0 answers

Google Sheets – ImportHTML: Select span inside a table td

Google Sheets – ImportHTML - select span inside a table data cell I would like to select a span inside a table data cell using =ImportHTML function in Google Spreadsheet. I could successfully select the table I…
0
votes
2 answers

Invoke googlefinance from a script and only run it for a small batch of tickers at a time

I have a Google Sheet in which I'm gathering some stock-related data. I'm using the googlefinance() function, among others: Some formula's I use: // current price =if($D$1=true,googlefinance(_ticker(A3),"price"),D3) // 5 year low =if($D$1=true,…
Pr0no
  • 3,910
  • 21
  • 74
  • 121
0
votes
0 answers

Googlefinance no longer identifying OTC stocks as it had in the past

I have a sheet that tracks the prices of several stocks using the Googlefinance function. It had been working for several months, but just recently started breaking with any companies listed on the OTC markets. I've tried using OTCMKTS: before the…