Getting Stock Price Historical Data for Specific Dates and Date Ranges with Google Finance

Поделиться
HTML-код
  • Опубликовано: 29 окт 2024

Комментарии • 45

  • @alphaandomegabusinesssolut1695
    @alphaandomegabusinesssolut1695 2 года назад +2

    Great video and you speak at a very comfortable and understandable rate, not too fast or jumping around. Your explanations are very clear and precise. I learned a neat function I never knew about is just a few minutes.
    Recommendation: I just found your channel so I am going to explore your other videos, perhaps you already have this there, but a suggestion to include in this video or related follow up video is how to get multiple columns of data (e.g. "open, close, high, low, volume) and only one "date" column. In this video, it appears each time we make a call for a specific column like "open", Google sheets automatically populates a dates column next to the request. I would be curious to know how to pull multiple data columns with just one date column. My apologies if you already address this in another video that I am not aware of. Anyways, some food for thought.
    Great job. God's blessing to you!

  • @ryanowen1118
    @ryanowen1118 2 месяца назад

    Thanks! Still works! Do you know if you can pull for a certain time? Like off of the minute chart? I day trade and would like to be able to pull data for multiple times a day.

  • @al.istitsmaar7210
    @al.istitsmaar7210 2 года назад

    Good Day, Sir.
    May i ask you a question?
    🙏
    List of Stock Prices (Monthly/Daily/Weekly Closing Price) on Google Finance Indonesia, the last one is only until July 1, 2022, right?
    How come today (September 18, 2022) does not appear?
    Thank you
    =googlefinance(concatenate("IDX:";"TLKM");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")
    The result is different with this function :
    =googlefinance(concatenate("NYSE:";"UNVR");"price";DATE(2022;1;1);DATE(2022;12;31);"WEEKLY")

  • @viniciusrangel7295
    @viniciusrangel7295 3 года назад +2

    Hi, I want the historical close prices, but new dates first. All I get is old date first.

  • @yourtime2602
    @yourtime2602 10 месяцев назад

    is it possible to get the closing value of x bars from today for a specific stock ?

  • @gregerlindstrand1665
    @gregerlindstrand1665 2 года назад

    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!!

  • @SD-sv7xt
    @SD-sv7xt 2 года назад

    Hello Sir, I have a query regarding Google finance please help me to solve it. Query is, I have 25 stocks list in Column B and I want in column C or D is ( specific date closing price of every stocks of collum B. Like I want 23/6/2022 closing price in column C or D)

  • @orkayen
    @orkayen 2 года назад

    thanks for the video. how to get closing price 10 min after market open? Day closing shows time as 16:00:00. i am looking for 9:40:00. any idea?

  • @vigneshwaran6878
    @vigneshwaran6878 Месяц назад

    superb bro very usefull one

  • @SD-sv7xt
    @SD-sv7xt 2 года назад

    I have 20 stocks in column A, and i want to get all stocks closing price in B or C column for the date of 20-6-20. Please guide me how can i get it

  • @sandeep6133
    @sandeep6133 2 месяца назад

    Hi sir, good afternoon
    What's the formula for below, if possible plz share it
    Getting highest Stock Price for Specific Dates and Date Ranges with Google Finance in 1 culom

  • @Sam-007
    @Sam-007 2 года назад

    Hi, from INDIA...
    How can I get High & Low of specific time candle ...?
    Plz reply

  • @Frojyt
    @Frojyt 3 года назад +1

    Hi, how can i plot previous 3 days or 5 days price agains a list of stocks? So if today i open the sheet it gives me previous 3/5 days price for all the stocks i hv on my list without me having to update the dates in the columns.

    • @Frojyt
      @Frojyt 3 года назад

      And i want the high and low prices of the previous 5 days here and not the closing price

  • @altafhussain2204
    @altafhussain2204 2 года назад

    Price what i am getting is one day ahead price. Example- date is 4th Oct 21 but price is of 5th Oct 21. Why it is happening any adea?

  • @armandssakne1868
    @armandssakne1868 Год назад

    Looking for the formula of historical close price, day before historical date. Example: Historical date: 07.07.2016, Ticker: FORD, Close price at 06.07.2016. Can't find solution in any youtube videos. And just price value in same cell. Thank You!

  • @manis9360
    @manis9360 2 года назад +1

    how to get "change %" for n number of day.?

  • @steve318k
    @steve318k 3 года назад

    how do you get the 'syntax information' to show ? ... I don't get anything at all.

  • @dpatel2747
    @dpatel2747 2 года назад

    how to use cell reference for DATE, suppose date is written in cell "A1" then how i can use this cell in date place in formula

  • @thesashank
    @thesashank 2 года назад

    Thanks, good stuff

  • @WealthandWisdom
    @WealthandWisdom 3 года назад

    I have watched many of your videos on stock, but no one shows how to set up performance, WTD,MTD,YTD....Thoughts?

    • @SixMinutesSmarter
      @SixMinutesSmarter  3 года назад

      Interesting. week to date, month to date are definitely not common. Year to date seems to come up from time to time. Of course, we're getting this info so that we can compare investment A to investment B. If you compare WTD returns instead of annualized returns, are you really getting any new comparative info?
      Making an Excel formula to display that does sound like a fun challenge--and I'm confident it'll work.

    • @WealthandWisdom
      @WealthandWisdom 3 года назад

      @@SixMinutesSmarter I found d a video that does this in Google Sheets - But as an Advisor, I look for trends, short, mid and long term. Thats wy I use several dates

    • @jvl167
      @jvl167 3 года назад

      @@SixMinutesSmarter thanks for the clear video ralph, very interesting! So what would be the formula to get YTD data?

    • @SixMinutesSmarter
      @SixMinutesSmarter  3 года назад +1

      Check ruclips.net/video/_M-Q1BTZB2g/видео.html in about 10 minutes for a walk-through of the year-to-date return formula.

    • @jvl167
      @jvl167 3 года назад

      @@SixMinutesSmarter thank you very much!

  • @piyushpathela1365
    @piyushpathela1365 3 месяца назад

    How to get data from Google finance for less than 650 days ?

  • @chettanv3398
    @chettanv3398 Год назад

    how to get the data of any ticker at an specific time on the current date?

  • @kisalayjoshi3027
    @kisalayjoshi3027 3 года назад +1

    Hi Ralph , this was great .I have one doubt .Is there a way to get highest price in last 6 months . I am trying to arrange all the stocks in rows and wanted to compare 52 week high and last 6 months high .

  • @akassebaum
    @akassebaum 2 года назад

    Is there a way to just have the close price without the headers of "Date" and Close?. I would just like the value in one cell

    • @SpotBentley
      @SpotBentley Год назад

      Did you ever figure out how to do this?

  • @rhondagarcia1004
    @rhondagarcia1004 3 года назад

    I love this tutorial!!! However, I'm trying to add stock rates from today (current) and the past 4 days into googlesheets from google finance. I currently have the cells as today (C3) then next cell is =C3-1, =D3-1, =E3-1.... so the cell dates change daily based on today's date in C3. Is there a way to do this? I can't seem to find a tutorial that describes how to make this work.
    Thank you!

  • @baraiyagopal1
    @baraiyagopal1 3 года назад +1

    sir how to get 30 before prise in single column???

  • @JP-vk7bb
    @JP-vk7bb 2 года назад

    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-Glitch-
    @The-Glitch- 3 года назад

    Great vid. How do I pull, say 1 months, data, minus sats sundays, minus custom Holidays.
    Thank you again.

  • @luigipalmero3270
    @luigipalmero3270 3 года назад

    Hello, awesome vid! I have one question, since as "last date" u put a future date, that means that the next day your excel automatically updates and shows u the next day values? That would be awesome to create a chart real time

  • @simoneassirelli1809
    @simoneassirelli1809 2 года назад

    what about adjusted close prices?

  • @mdbilla4219
    @mdbilla4219 Год назад

    how to add only open and close price without date column

  • @babhalgaonkarv8459
    @babhalgaonkarv8459 3 года назад

    Sir, how do get the next 10 trading days data (Only trading days) from any specific date?

    • @SixMinutesSmarter
      @SixMinutesSmarter  3 года назад

      Check out ruclips.net/video/dymkT3yR2A4/видео.html and use a similar technique.

    • @babhalgaonkarv8459
      @babhalgaonkarv8459 3 года назад

      @@SixMinutesSmarter Thanks alot

  • @chrismartin1993
    @chrismartin1993 2 года назад

    Can this Google Finance tool, give me live feeds of a currency pair (Forex) is trending up or down. For example GBP/USD. One cell would be current GBP/USD; 2nd Cell would be GBP/USD from 72 hours previous. Third cell could just be simple logic formula to confirm. Bullish or Bear would be put in third cell. Basically looking for trend Seems easy. ? Maybe an input is if you wanted to a variable to how far back to look. 72 hours, 36 hours 144 hours whatever. I hope I explained that well.

  • @GK-ll7zo
    @GK-ll7zo Год назад

    Google finance seems not so reliable, if I ask to give me all latest closing prices on 28 june 2023, latest data he can show is 26 june, also when you want to point to a day earlier but it falls in a weekend, he rounds it off to nearest date
    Hard work to just get 2 latest market datapoints out of it
    Would be nice of Googlesheets that they also make a "marketday" so we don't need to do this work around every time ;-). marketday(). marketday()-1. ....