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

Sum Values Based On Other Column Value

I am trying to do a formula for: NUMBER OF SHARES per sector - should count all shares from column E:E in column I:I based on sector TABLE: SYMBOL NAME TYPE SECTOR OWNED SHARES SHARES PRICE SECTOR NUMBER OF SHARES TOTAL PER…
vohratom
  • 422
  • 7
  • 16
-2
votes
1 answer

How do I retrieve the information about the maximum and minimum price of a stock just during the after hours, or the pre-market?

How do I retrieve the information about the maximum and minimum price of a stock just during the after hours, or the pre-market? For example, I can use the formula =GOOGLEFINANCE("TSLA";"high";"02/02/2022") which will retrieve the maximum price of…
Fernando Cañellas
  • 1
-2
votes
1 answer

Automatic data record in Google Sheets

I receive the data on the P/E multiple in Google Sheets via GOOGLEFINANCE in the following manner: =GOOGLEFINANCE("GOOGL","pe") How to write script in Google Sheets that would record the P/E values (or better the values of a particular cell) every…
MariaMaria1
  • 25
  • 1
  • 6
-2
votes
1 answer

how to slice bytes object when i try to slice it give me int number?

I am trying to get live tick from google finance site using urllib,request but it returns a lot of data but I want to select the only price so how do I select that without using loops **I want that thing from HTML ["INFY","Infosys…
Lakhan Pahuja
  • 47
  • 8
-2
votes
1 answer

How to Obtain Google Quotes in KMyMoney?

In order to retrieve the stock quote from Google Finance in KMyMoney do the following: Goto https://finance.google.com and obtain the symbol, example "NASDAQ:GOOG" Open KMyMoney, goto Settings->Configure kMyMoney->Online Quotes Click on the "New"…
Suresh PB
  • 169
  • 1
  • 2
  • 16
-2
votes
1 answer

Yahoo / Google finance JSON not working in Chrome

This is my JS code. This works perfectly in IE. If I paste the request link in browser then I do get JSON reply but when I run this code. I do not get any reply for either Yahoo or Google requests. Works very well in IE though. //var url1 =…
Nikhil Redij
  • 1
  • 2
-3
votes
1 answer

Get daily stock movement in %

My goal is to get daily stock movement in % as follows in Google Sheets: name 1JAN 2JAN 3JAN 4JAN 5JAN ------------------------------ GOOG 1% 2% 1% 2% 1% BABA 2% 1% 3% 5% 6% Can anyone pls advice. I am new to Google finance.
asdasd
  • 6,050
  • 3
  • 14
  • 32
-3
votes
1 answer

save stocks historical data into stock name.csv using python

I used python 2.7 to fetch historical data from Google finance. I would like to save the output in .csv with the stock individual names. Example, AAPL.csv,MSFT.csv and etc. Since I have 900 stocks in the list, I use a for loop to name my file but…
bkcollection
  • 913
  • 1
  • 12
  • 35
-4
votes
1 answer

JSON parsing of finance.google.com result

I'm not getting how to parse finance.google.com results, i.e. I got [ { "id":"787381", "t":"HDFC", "e":"NSE", "l":"1,424.00", "l_fix":"1424.00", "l_cur":"₹1,424.00", "s":"0", "ltt":"3:46PM…
Gireesh Bhat
  • 139
  • 1
  • 1
  • 7
-7
votes
1 answer

Is it possible to extract everyday stock closing price in Python and store them to Excel?

Is it possible to extract closing prices of stock market and dynamically write them into an excel sheet using python? Example: Can I get GOOG, AAPL, MSFT, AMZN everyday closing stock prices from Google-Finance or Yahoo!-Finance and write them…
SandB
  • 11
  • 4
1 2 3
…
27
28