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

mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen ⬅ Support me on Patreon
• Data Analysis Portfoli... ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python
┋Professional Certificates┋
DataCamp Certifications ➡ datacamp.pxf.i...
Google Data Analytics Professional Certificate ➡ imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate ➡ imp.i384100.ne...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.ne...
Microsoft Power BI Data Analyst Professional Certificate ➡ imp.i384100.ne...
IBM Data Science Professional Certificate ➡ imp.i384100.ne...
Google Project Management Professional Certificate ➡ imp.i384100.ne...

[@donaldlcartinsr2332]

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

[@JS-pf5fv]

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

[@tap_in_merchant]

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

[@yashsingavi5167]

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

[@mo-chen]

Glad it helped!

[@romethariyarathne8903]

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]

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 😄

[@GregoryKodolanyiRitter]

That was neat! thank you, Mo!

[@mo-chen]

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

[@kevingonzalo9087]

nice comment

[@colombo11]

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

[@brendanfoley6112]

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

[@godfreykiggundu7787]

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?

[@harishn5873]

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

[@remzhu9709]

why is mine saying "#BLOCKED!"?

[@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.

[@WalletInvestUSA]

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

[@robh.1212]

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.

[@traceruss3170]

Great video! Thank you!

[@mo-chen]

Glad you liked it!

[@sajun6508]

Hi, I would like to ask how to get S&P 500 historical price using this function? TT

[@DonnyOtsuka]

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

[@noun1986]

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

[@adilsonsf]

Great. That is what i needed.😊

[@mo-chen]

Glad it was helpful!

[@NickBZ]

Awesome

[@sayedmuzz5727]

Does it work for forex?

[@vigneshwaran6878]

pls upload time based data collection video

[@shivasanthosh31]

really helpful & great bro...

[@RandomFaxx]

Good video

[@mo-chen]

Hi RandomFaxx, thanks a lot!

[@ericmarx3741]

how can I get every 15 minute incremental pricing?

[@mo-chen]

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

[@TonyMontana-yp1lh]

whats wrong with your voice?

[@AJ-cg7zc]

Get to the point. Too much extra talk

[@Lovie484]

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