google-finance Questions
1
I'm trying to calculate the rate of change in Google finances' data. For example if price of AMD was 2 dollar and tomorrow it was 1 dollars, then the result I want is -0.5. I called the Google fina...
Unsightly asked 10/7, 2019 at 2:3
2
I use GOOGLEFINANCE() to query the historical USD/GBP exchange rate at a set of fixed dates.
This works fine, except sometimes GOOGLEFINANCE returns #N/A, for whatever temporary upstream reason. W...
Vulgarity asked 29/4, 2019 at 14:40
7
Solved
I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR.
Here is my formulae: =Finance!B4*GOOGLEFINANCE("...
Zippel asked 15/11, 2017 at 14:59
3
Anyone know workarounds to make GoogleFinance actually work?
It works for a while so it is not a problem with my formulas but then periodically the cells that were showing stock quotes suddenly sho...
Daguerre asked 22/1, 2020 at 5:53
2
Solved
The GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument.
https://support.google.com/docs/answer/3093281?hl=en
However, the documen...
Bendwise asked 30/12, 2019 at 18:0
4
Solved
I want to get the price of a particular stock at a particular date in Google Sheets using the Google Finance forumula.
I tried this formula:
=GOOGLEFINANCE("GOOG","price",12/13/...
Himself asked 22/3, 2014 at 7:34
3
I am using the GOOGLEFINANCE() function in google sheets to get an exchange rate for expenses I am entering in for accounting.
The issue is that sometimes I get an #N/A error with the message
W...
Bourguiba asked 21/5, 2015 at 17:31
4
Solved
I have no problem retrieving price data of US stocks. For example, to retrieve Apple price data, this formula =GOOGLEFINANCE("AAPL","changepct")/100 works fine. When I tried to retrieve Tokyo stock...
Gaudette asked 1/5, 2015 at 4:31
1
Following this post, where I had listed some of the interesting ETF1s I had found on some of the relevant forums, I received some valuable criticism. Now I want to use a Google spreadsheet to get t...
Subauricular asked 2/5, 2020 at 17:42
2
Solved
Immediate problem:
=ImportHtml("http://127.0.0.1/~themis/transactions.html";"table";1)
is placed into a cell. The page exists; I can open it in Chrome.
My guess is that it's done remotely as the...
Sentimentalism asked 8/7, 2011 at 22:58
3
Solved
First of all, i'm not a powerful sheets user :)
I'm trying to use GOOGLEFINANCE to calculate amounts in multiple currencies.
I use this formula:
=IF($A2;
IF(
$C2:C;
$C2:C;
IF(
$D2:D;
$D2:D*I...
Haemoid asked 10/12, 2019 at 18:13
2
Following ARRAYFORMULA is giving me an error "parameter 1 value is invalid."
=ARRAYFORMULA(IF(ISBLANK(B2:B), "", GOOGLEFINANCE(B2:B, "price")))
B column of my sheet contains the stock symbols wh...
Chick asked 10/4, 2020 at 11:5
2
Solved
=ARRAYFORMULA(IF(ROW(B:B)=1, "Share Price", IF(ISBLANK(B:B), "", googlefinance(B:B, "price"))))
I am trying to make row 1 (my header row) have a name, and then below that, if a valid ticker symbo...
Cassy asked 26/3, 2020 at 19:6
14
Solved
I'm looking for access to financial data from Google services.
I found this URL that gets the stock data for Microsoft.
What are all the possible parameters that Google allows for this kind of H...
Yourself asked 9/2, 2009 at 10:54
4
Solved
I'm trying to get data from Google Finance in Google Sheets with this formula:
=GoogleFinance("CURRENCY:BTC")
But I'm getting this error:
GOOGLEFINANCE, the query for the symbol: 'CURRENCY:BTC'...
Lionellionello asked 13/7, 2017 at 12:51
12
Solved
I need some sort of interactive chart control for my .NET-based web app. I have some wide XY charts, and the user should be able to interactively scroll and zoom into a specific window on the x axi...
Appurtenance asked 21/9, 2008 at 16:45
4
Solved
I just discovered Google App Scripts, and I'm stumped on something already...
I am trying to write a script for a Google Spreadsheet which finds certain historical stock prices. I found tha...
Powerless asked 10/10, 2014 at 5:38
6
Solved
Is there a way to automatically download historical prices of stocks from yahoo finance or google finance (csv format)? Preferably in Python.
Readymix asked 14/9, 2012 at 23:6
2
Solved
I am looking for a way to get stock splitting information. Using the yahoo stock API I can get all types of info on any symbol but I don't think I can get the split ratio or even whether it split. ...
Rancho asked 25/5, 2011 at 5:21
8
Solved
This function:
GOOGLEFINANCE(("CURRENCY:EURAUD"))
works well in Google Sheets, I have searched the web up and down for some documentation regarding this function and how it is used, the closest ...
Trismus asked 26/9, 2012 at 14:18
5
Solved
My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to refresh manually now. How can I make the spreadsheet refres...
Tegan asked 8/4, 2014 at 6:1
2
I wrote the following formula, and it only returns the high of the starting date and not the high of the entire date range: =INDEX(GoogleFinance(C7,"high", A7,B7,"DAILY"),2,2)
w...
Snowberry asked 19/5, 2018 at 4:45
6
I know that Yahoo has a great API for accessing detailed financial metrics about a company documented at http://www.gummy-stuff.org/Yahoo-data.htm. Yahoo also provides historical pricing data...
Gondar asked 16/3, 2012 at 15:31
2
I'm calculating Google finance 200 day moving average formula in google sheet using formula
=average(query(sort(GoogleFinance("GOOG","price", TODAY()-320, TODAY()),1,0),&q...
Ambulance asked 17/6, 2017 at 23:57
3
Solved
I am working on google currency converter and it's working fine for all currencies but not showing
results of ZAR - BTC conversion.
Google currency converter code :
<?php
function convertCur...
Roana asked 24/2, 2018 at 6:52
1 Next >
© 2022 - 2025 — McMap. All rights reserved.