Is there any way to get intraday stock data for free rather than the daily data? In this code, it says for intervals only options are "DAILY" or "WEEKLY".
Thanks for the upload. I am trying to get past week's OHLC data. I use $B$1-weekday($B$1+1) as a formula to get the end of the past week. $B$1 cell has today(). It works perfectly fine when there are no holidays. It doesn't work when there is a holiday on Fridays. Any idea why it is so?
What would the syntax be? I want to compare todays price to the closing price 1 or 2 or 5 or "Max" years ago to find out if todays price is higher or lower than it was "a year ago". Thanks!!
Any idea if you can get this to work with the changepct? I can't get no luck! I want to track my stocks performance over a month, trying to get it to do it automatically haha
Nice video. Can you please advise how i can short data by date. I am able to pull data but just like in your video, old date show up on top row and most recent date is in at bottom. I need most recent date on top. Thank you
The dataset is ordered by the most recent date on the top already. Do you mean the earliest translation date? If so, here's an example using QUERY function to sort the order. =QUERY(GOOGLEFINANCE("aapl", "All", "01/02/2022", "02/22/2022"),"SELECT *",True)
HI JJ, I pulled in historical price data from 30 day ago until today to create a technical indicator. However, it only pulls stock price data until the 8th October (Friday), and it so far did not bring in data for 11th October (Monday). Today is 12th so market is not yet open. Is this normal? How can i get price coming in as up-to-date as possible. Thanks in advance
I am getting strange data too. I put in TQQQ going back years and for weekly it pulled the last three fridays. Changed it to daily and it only gives me back through March 28th of this year. Seems to be missing....12 years of history. 20 minutes later and now it is showing what I want. Google finance - as reliable as....never.
@@thiagoperetto2626 Cara ja faz um tempao que fiz essa pergunta e eu não consegui não!! Simplesmente achei uma forma de me acostumar a organizar minha analise ao contrario. Valeu bro
@@viniciusrangel7295 Faaala Vicicius!... Eu encontrei a solução. =SORT(S:W;1;False) Ele simplesmente espelha a lista invertida. do jeito q queremos. S é a primeira coluna e o W a ultima. Ai eu deixo a lista "errada" escondida no documento e fico vendo só a planilha espelhada. Cara, tá muito pratico e lindo de ver. Um abraço Vinicius, obrigado pela atenção!
Hi I encountered this error and I'm unsure what is wrong. Function QUOTE parameter 3 expects number values. But '1/23/2020' is a text and cannot be coerced to a number.
These would be helpful videos except the final code is not shown separately from the video and the video itself is too small and the speaker is hurried. PLEASE IMPROVE THIS and stop ebegging and calling it coffee. If your videos are quality you get views and cash $$$.
