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

What timezone is used for financial data returned in Google Sheets

Using =GoogleFinance("EURUSD","price",StartDate,EndDate) produces two columns of results: The date and the currency rate on that date. Great! Except that it's unclear what timezone it is using. I tried changing the timezone of the sheet (File ->…
Cameron
  • 11
  • 6
0
votes
1 answer

'getvalues' sometimes returns '#REF!'

The following Apps Script does not retrieve the calculated value for a formula of =max(index(googlefinance(A2,"close","1/2/2018",today()),0,2)). The logger shows #REF!. Anything wrong? I'm guessing it's related to the index() but no idea how to…
wilsonh
  • 1
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
1 answer

Copy cell value of volatile function on form submission in Excel/Google Sheets

I am using Zapier to add new rows to Google Sheets via a form. One of the cell values in the new row calculates the stock price via Google Finance and another a unique ID. The problem is both of these are "volatile functions" meaning they…
sigur7
  • 796
  • 1
  • 11
  • 35
0
votes
1 answer

When do today's OHLC prices reflect in googlefinance function in google sheets?

It's 9.30 PM while the market closed at 3.30 PM. Still googlefinance() functions are unable to fetch today's OHLC prices. Yesterday's prices are available though. When do they (today's prices) reflect?
Abhijit Buchake
  • 142
  • 1
  • 9
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
3 answers

Browser loads the page but CURL/file_get_contents redirects

I use this page to get the current currency conversion: http://finance.google.co.uk/finance/converter?a=1&from=EUR&to=GBP It has worked okay for over a year using file_get_contents but all of a sudden it stopped working. I then tried curl and it is…
Dan
  • 103
  • 1
  • 13
0
votes
1 answer

google finance new site quote scraping

I have been trying to scrape quotes from the new google finance site with this code that I wrote. import urllib import re import time import requests def get_quote(symbol): base_url = 'http://google.com/finance?q='+ symbol content =…
Urvish Ramaiy
  • 25
  • 6
0
votes
2 answers

Downloading stock prices from Google Finance

import pandas as pd import requests from bs4 import BeautifulSoup from datetime import datetime import pandas_datareader.data as web tickers ['MMM', 'ABT', 'ABBV', 'ACN', 'ATVI', 'AYI', 'ADBE', 'AMD', 'AAP', 'AES', 'AET', 'AMG', 'AFL', 'A', 'APD',…
Kevin Choi
  • 747
  • 1
  • 5
  • 17
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
0 answers

Create Google Sheets Email Trigger Based on Stock Price

I'm trying to create an email trigger in Google Sheets that will send me an email anytime the Price Fair Value Ratio for any stock is less than 1 (meaning the stock is undervalued). The Ratio is in column 6 and I pull in other corresponding columns…
Eyes0ftheworld
  • 1
  • 2
0
votes
0 answers

How to update python googlefinance.client to 1.3.1?

Python's googlefinance.client has stopped working after Google changed hostname for finance. I need to update googlefinance.client to 1.3.1. How can I make my ubuntu upgrade googlefinance.client package to latest version? So far, I tried: sudo -H …
infal
  • 47
  • 4
0
votes
1 answer

GOOGLE Finance Sheets returns same stock price on different days

I am trying to run a GoogleFinance query in GOOGLE Sheets to get the stock price for the same stock. I wish to display the stock price in different rows of column A: On day 1 I will enter the formula in cell A1 On day 2 I will enter the formula in…
edesz
  • 11,756
  • 22
  • 75
  • 123
0
votes
1 answer

Google Scripts automatically add date to column in Google Sheets

I am trying to use a Google script that retrieves 2 securities fields from GOOGLEFINANCE and saves the output to a Google Sheet file. I need the script to also add the datetime to the first column of the Sheet. I have created a basic Google Sheet…
edesz
  • 11,756
  • 22
  • 75
  • 123
0
votes
0 answers

How to get Google Sheet to trigger a dialog box if/when a cell value is larger than another?

I want to make a script to get the google sheet populates a dialog box alert and if possible, sends an email on the condition that a particular cell value (say A1 is larger than A2) and since the A1 and A2 value depend on the query returns from…
Brianlearningscript
  • 27
  • 1
  • 4
1 2 3
…
27 28