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

How to get historic data including today

=GoogleFinance(A5,"close", TODAY()-500, TODAY()) This return data from yesterday. Any idea how to get the data from today ?
Mohanish
  • 9
  • 2
0
votes
2 answers

Add future date in Google script and Goggle Sheet

I use Google sheet and Cryptofinance.ai to retreive cryptocurrency prices. I have one script that works well : it appends data periodically from one row in tab A to save them in a tab B so I can make graphs and charts. Now I'd like to add date + 1…
NiphitAe
  • 295
  • 1
  • 5
  • 16
0
votes
0 answers

Change date format in googlefinance (historical)

I have a google sheets formula to get an historical rate for a determined currency pair: GOOGLEFINANCE("CURRENCY:"&A2,"price",DATE(YEAR(B3),MONTH(B3),DAY(B3)),DATE(YEAR(B4),MONTH(B4),DAY(B4)),"DAILY") It outputs the date as follows : Date …
BTC75
  • 71
  • 10
0
votes
1 answer

Change the range of cell with given value

Can anyone solve this problem I need to find the simple moving average with a condition if J1 is 9 then it has to calculate from E2:E10 and put in G10 If the given value is 15 then the result has to for 15 periods SMA While changing the SMA value…
dgnk
  • 98
  • 8
0
votes
2 answers

Google Sheets: Convert a master currency into a local currency on specific Sheets

I have a master budget spreadsheet that is in one currency (NZD). I then use =QUERY('Sheet',"Select * where (A <> '' and B = 'UK')", 0) and other variations to populate each line item into a regional budget. I would like the regional budgets to be…
nickpnz
  • 1
  • 1
0
votes
1 answer

Writing one column of an Array or transposing a 2 column array to a one column then writing

Hello I have tried to figure this out for many days and I just can't. Can I lean on you guys for some help? I am pulling 2 columns from a sheet into an array, then I am looping the array overwriting the second column of the array to become a SQL…
Scott Fitzpatrick
  • 41
  • 4
0
votes
1 answer

google finance function not correct in google sheets

The function below should be pulling back the amazon share price on 04/04/2020. The result states $11.43 which is incorrect. This has been working for the past 6 months but not today for some reason. Is this an issue with google finance…
user1438082
  • 2,740
  • 10
  • 48
  • 82
0
votes
1 answer

Using INDEX to only show the prices of a stock using the GoogleFinance function in Google Sheets

The following formula in Google Sheets shows me the closing price of GOOG stock for the last 5 workdays: =INDEX(GoogleFinance("GOOG","close",WORKDAY(TODAY(),-5),TODAY()),,2) However, the result includes the word "Close" as a heading. This is the…
FrostedKrispie
  • 3
  • 1
  • 2
0
votes
1 answer

Building (delayed prices) trading system using google finance API or yahoo finance API

Im interested in using one of the two named APIs for building my own hobby-project trading system. My question is, i would prefer to build this in Java, C++ or C#. Is this possible considering the type of APIs yahoo and google offer? I had the…
James
  • 21
  • 3
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
5 answers

Limiting float value in for loop Python

I'm working on banking project, where my team asks me to limit all float values to .2 precision. My dataSet.head() Goal: To find max of all stocks comparatively My present output: Bank Ticker BAC       54.900002 C …
Thirumalai vasan
  • 655
  • 2
  • 6
  • 19
0
votes
1 answer

GoogleFinance formula to find previous historical trading day of a stock

I have been searching for a solid formula to find stock prices of "previous trading days" of a large batch of historical dates. The formula I started with: =googlefinance(A5, "close", B5-1) where A5 refers to a ticker, and B5 refers to a date in…
Jared G
  • 27
  • 1
  • 1
  • 6
0
votes
1 answer

What is the best open Source API for importing financial data from google finance or any source?

I am currently looking for a way to import financial data into python directly. I was looking at a few alternatives finding the yfinance API to be the best so far. I created a notebook that explains it and how it works in a git repositiry .…
user4933
  • 1,485
  • 3
  • 24
  • 42
0
votes
2 answers

googlefinance function on google sheets stopped working

I have a google sheet that I use to monitor my forex trades. in it I use the googlefinance function to retrieve the latest forex quotes. And it did work fine until very few days ago, now I'm getting an error: Errore Durante la valutazione di…
Don Giulio
  • 2,946
  • 3
  • 43
  • 82
0
votes
1 answer

Google Sheets sparklines trend query using Yahoo finance data

Can someone help me write a one cell query similar to the one below but using yahoo finance data instead of google finance. This sparkline shows a trend on daily price for the last 365 days and colors the sparkline green or red depending if the…
domid
  • 33
  • 7
1 2 3
…
27 28