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

How to get Google Sheets (Google Finance) to show today's close value

I am able to get todays high / low / open with below formula correctly. =INDEX(GOOGLEFINANCE("NSE:CIPLA", "HIGH")) // considering changing second param but I cant get the today's close with below formula. =INDEX(GOOGLEFINANCE("NSE:CIPLA",…
codingHack
  • 21
  • 3
0
votes
1 answer

Google Finace change a number to negative if another column is marked sell

Currently working on making a portfolio tracker. im looking probably for a if statement that will change my Quantity of shares held to a negative if another column is labeled as 'SELL'. You can see from the image provided, the right column is what…
Peter
  • 45
  • 7
0
votes
0 answers

What to use to get data from OpenFIGI API to store into AWS or Snowflake?

I am trying to get help on what to use to get data from OpenFIGI API to store into AWS or Snowflake? https://www.openfigi.com/api I would like to build a form or input sheet to be able to input the POST /v2/search Request Format for OpenFIGI and…
Johnson36912
  • 1
0
votes
1 answer

How to write to google finance API?

I know how to read from the google finance api, it is pretty simple. But when I try to write I get the following error: Error: Request had insufficient authentication scopes This is my code: const fs = require('fs'); const readline =…
Jose Montalvo
  • 13
  • 3
0
votes
0 answers

r error - Unknown SSL protocol error in connection to query2.finance.yahoo.com:443

I am connecting to the query2.finance.yahoo.com in order to scrape some information from the google finance for 3000 stocks (written in json as shown here). I am able to retrieve information until, say 50 stocks or so, then it throws an error…
user9532692
  • 584
  • 7
  • 28
0
votes
2 answers

Google Finance Convertor returns Undefined Offset 1

I am trying to implement this Google Finance Convertor in my project. I implemented it and it was working fine then. But today when I rechecked my application to ensure every thing is working properly I found out that the Google Finance Convertor…
Single Mingle
  • 1
  • 2
0
votes
1 answer

Get historical data for multiple stocks in single request using python from Google finance

I am able to get historical data on one stock per each request. But I need to get historical data for multiple stocks in a single request from Google finance using python. Any help will be highly appreciated! Thanks
NaveeN .G
  • 1
  • 3
0
votes
1 answer

Adding a time index to a pandas dataframe from google finance

I am using the google finance api to pull data into a pandas dataframe. The index is a number and I would like to change it to be a date inclusive of hours and minutes. Any ideas? Thanks! import pandas as pd api_call =…
pmillerhk
  • 171
  • 1
  • 2
  • 12
0
votes
1 answer

Google Finance API Time Period

I am using a C# class to get the prices of a given stock from Google Finance. The communication between the class and the Web Service is working well. I am using the following url: http://www.google.com/finance/historical?output=csv&q=BBAS3 The…
Mad River
  • 11
  • 5
0
votes
0 answers

Not able to download all available data from Google Finance

import datetime as dt import pandas_datareader.data as web start = dt.datetime(2007,1,3) end = dt.datetime(2017,10,30) df = web.DataReader('XCSE:OMX Stockholm PI', 'google', start,…
Chisq
  • 117
  • 1
  • 9
0
votes
1 answer

Google Finance ActionScript

I'm trying to consume Google Finance API on a Flex Project but with no success. I want to use the ClientLogin mode, am able to get the auth token, but then I can't seem to get information from any of the feeds! I've tried some of the few examples I…
RedEagle
  • 21
  • 2
0
votes
2 answers

Google Sheet, Finance: FILTER twice to get only one cell

I have a Google Sheet with some stock information. I'm using the formula GOOGLEFINANCE($B2, "price",TODAY()-15) to retrieve historical information about a stock (symbol named in $B2). That returns a 2x2 table: Date Close 8/25/2017…
Ivan Perez
  • 582
  • 2
  • 17
0
votes
1 answer

Slight problem with Google Finance API

Hello all I can't seem to log in with google finance api to my account and I don't know why. Here is my code public static void main (String [ ] args) { FinanceService myService = new FinanceService("exampleCo-exampleApp-1"); try { …
Chris Maness
  • 37
  • 1
  • 5
0
votes
1 answer

Url for google finance unable to get data

I am using this link to get multiple quotes for my own app https://www.google.com/finance/info?infotype=infoquoteall&q=SGX:U11,ASX:TPM,ASX:WOW However, it stop working now. Any alternatives google api that can get data for multiple quotes at one…
lotteryman
  • 389
  • 1
  • 6
  • 21
0
votes
0 answers

How do I get the Dividend from Google Finance?

I have had this code run before, and Google Finance used to give me the Dividend and Yield in the dictionary it returns. How do I get that data now that it won't come in this dictionary? from googlefinance import getQuotes import…
Anton Alley
  • 1
  • 2
1 2 3 4
5
6 7