Get any STOCK DATA you want using EXCEL ONLY | STOCKHISTORY FUNCTION

Поділитися
Вставка
  • Опубліковано 8 лис 2024

КОМЕНТАРІ • 36

  • @donaldlcartinsr2332
    @donaldlcartinsr2332 7 місяців тому +2

    GREAT video!!! You explained what I was looking for so simple that I had no problem keeping up. I really apprecite it!!

    • @JS-pf5fv
      @JS-pf5fv 3 місяці тому

      please edit title to say version so it doesnt come up in the search. thank you

  • @yashsingavi5167
    @yashsingavi5167 4 місяці тому +1

    simple yet efficient than scraping.. thank you so much man !!

    • @mo-chen
      @mo-chen  4 місяці тому

      Glad it helped!

  • @romethariyarathne8903
    @romethariyarathne8903 Рік тому +1

    do you trade or invest in the stock market personally. If so plz share how you use your data analytics skills for investing

    • @mo-chen
      @mo-chen  Рік тому

      I do invest, but I'm a very boring investor. I believe in long-term investing and am a buy and hold investor - rather than a make millions trading on leverage in weeek investor 😄

  • @colombo11
    @colombo11 27 днів тому

    Great video
    Is it possible to get all the shares in one file?
    And can a document with all shares be updated every day

  • @GregoryKodolanyiRitter
    @GregoryKodolanyiRitter Рік тому +2

    That was neat! thank you, Mo!

    • @mo-chen
      @mo-chen  Рік тому +1

      I’m glad you liked it Gregory! Thanks a lot for watching 😃

    • @kevingonzalo9087
      @kevingonzalo9087 Рік тому +1

      nice comment

  • @thewizard_9
    @thewizard_9 5 місяців тому +3

    Doesn't work for me. Copied the exact same thing and it says "#BLCOKED!" when I press enter

  • @brendanfoley6112
    @brendanfoley6112 8 місяців тому

    is there a way to manipulate the interval to intraday? 1min 5min 15min?

  • @robh.1212
    @robh.1212 6 місяців тому

    I would like to show the year to date performance of spy as a percentage. Is there a way to use stockhistory to do that? Do you know of some other way to get excel to show me the year to date performance of spy as a percentage? Thanks so much in advance. We really love your videos. They are so helpful and they age well.

  • @harishn5873
    @harishn5873 5 місяців тому

    Nice, Can we compare our portfolio performance with the benchmark index?

  • @traceruss3170
    @traceruss3170 16 днів тому

    Great video! Thank you!

    • @mo-chen
      @mo-chen  16 днів тому

      Glad you liked it!

  • @godfreykiggundu7787
    @godfreykiggundu7787 7 місяців тому

    This function gives only the daily, Weekly and Monthly. But what if I want to fetch Hourly data; How can I do that in excel?

  • @adilsonsf
    @adilsonsf 2 місяці тому

    Great. That is what i needed.😊

    • @mo-chen
      @mo-chen  2 місяці тому

      Glad it was helpful!

  • @WalletInvestUSA
    @WalletInvestUSA 27 днів тому

    What about if I just want to have the ticker symbol + the daily price?

  • @dattmuffy
    @dattmuffy Місяць тому

    to fetch the stock prices for each START day just skip the STOP date with a comma and only fetch price for the START date.

  • @DonnyOtsuka
    @DonnyOtsuka 4 місяці тому +1

    Is it possible to get this done for 100+ companies simultaneously listed on a specific exchange?

    • @noun1986
      @noun1986 2 місяці тому

      For me the query stops working after like 3 stocks. Seems like it is too much for excel to handle

  • @NickBZ
    @NickBZ Рік тому +1

    Awesome

  • @remzhu9709
    @remzhu9709 5 місяців тому +2

    why is mine saying "#BLOCKED!"?

  • @shivasanthosh31
    @shivasanthosh31 6 місяців тому

    really helpful & great bro...

  • @vigneshwaran6878
    @vigneshwaran6878 2 місяці тому

    pls upload time based data collection video

  • @RandomFaxx
    @RandomFaxx Рік тому +1

    Good video

    • @mo-chen
      @mo-chen  Рік тому

      Hi RandomFaxx, thanks a lot!

  • @ericmarx3741
    @ericmarx3741 5 місяців тому

    how can I get every 15 minute incremental pricing?

    • @mo-chen
      @mo-chen  4 місяці тому

      You can't with this function, as long as I am aware.

  • @AJ-cg7zc
    @AJ-cg7zc 2 місяці тому

    Get to the point. Too much extra talk

    • @Lovie484
      @Lovie484 29 днів тому +1

      Be grateful…you don’t know anything and he’s helping YOU out!

  • @TonyMontana-yp1lh
    @TonyMontana-yp1lh 6 місяців тому

    whats wrong with your voice?