432 questions
1
vote
2
answers
123
views
How to get data from 'Balance Sheet' on 'Google finance' with Python and Selenium?
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.chrome.options import Options
from bs4 import ...
- 43
2
votes
1
answer
117
views
How can I make multiple Google Finance arrays end at the same row?
I'm trying to display multiple stocks in a single table. I have the following formula For A2:
=QUERY(GOOGLEFINANCE(B1, "close", EDATE(TODAY(), -LEFT("36 Months", FIND(" ",...
- 85
-3
votes
1
answer
197
views
Spreadsheet custom function suddenly stop working
I use this to keep track of my stock portfolio, been using it for almost three years now, and recently it stop working, can't figure out why.
function MyPortfolio2(tickers, values , price)
{
var ...
- 9
0
votes
1
answer
829
views
How to find the correct ticker name for Google finance formula's Currency Data?
A question the forex data in googlesheet, I'm using the formula below to get all columns of Open-High-Low-Close.
Will somebody can elaborate how these values are calculated(stand for)? It's not the ...
- 9
0
votes
1
answer
264
views
Use Google finance to check when a stock hits a target price in a given period
I am trying to do stock backtesting in Google sheets.
I have entered scrip symbol in A3, entry date in B3, the last date to exit the stock in C3 and the target price in D3. Now I want to find on which ...
0
votes
2
answers
102
views
google sheets import year low
I am trying to import low and high of the year to google sheets and I see incorrect data been pulled
=MIN ( INDEX ( GOOGLEFINANCE ("AAPL","low",DATE(YEAR(TODAY()) -8, MONTH(TODAY()...
- 3
0
votes
1
answer
66
views
how to get specific year hig/low on to Google sheets
Hi am trying to get the individual high/low in to spcific cell per specific year, I am using google finance to achivie this, however I seem to get some false information.
below is the query
C7 is the ...
- 3
1
vote
0
answers
110
views
Google sheets AppsScript Range.copyTo function paste values pasting Loading
I have following function
function copyValues(range) {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange(range).copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType....
- 4,474
0
votes
1
answer
167
views
How to capture and update the highest & lowest value ever entered into a cell in google sheets?
I have a google sheet that tracks stock values and the data is regularly feed into a cell from Google Finance and other 3rd party extensions. Based on that data I display the current margin/profit of ...
0
votes
2
answers
298
views
Google Sheets: How to integrate two GOOGLEFINANCE tables horizontally using QUERY?
I have a problem that I unfortunately cannot solve on my own! I have the following formula:
=SPARKLINE(
QUERY(
{
GOOGLEFINANCE(S27; "price"; R27; R27+30);
GOOGLEFINANCE(&...
- 1
0
votes
1
answer
191
views
How to web scrape google finance in which page url is not changed for multiple pages with R?
I want to web scrape stocks' financial tables for different years with R. However, I can obtain the financial tables for the last year, which appears as default. But I also want to obtain data from ...
- 21
-1
votes
1
answer
654
views
What is the formula to get nifty it sectorial index price
Want sector data formulas like cnxpharma,cnxit,cnxfmcg
=Googlefinance("NSE:CNXIT","price"). Not working try this can any one suggest nse sector index price formula.........Pharma ...
0
votes
1
answer
283
views
Two GOOGLEFINANCE formulae in one cell
I am trying to incorporate a GOOGLEFINANCE formula in the GOOGLE SHEETS in one cell, say, F45, like the one in the following:
=GOOGLEFINANCE(A45)-=GOOGLEFINANCE(A45, "CloseYest")
The Cell ...
- 168
0
votes
1
answer
124
views
google finance stock prices
=GOOGLEFINANCE("ABC","all",today()-30,today(),"Daily")
This returns daily stock price info for ABC for the last 30 days. Is there a way to stagger the output so it only ...
0
votes
1
answer
2k
views
How to get daily percentage change of a stock(in array form) in google sheets?
How can I fetch daily % change of a stock in google sheet e.g for last 30 days or last 1 year in array form?
So far I got the daily close prices like this.
=GOOGLEFINANCE("NASDAQ:GOOGL", &...
- 626