It looks like your VBA script is updating the spreadsheet a lot. Pro tips: only access the spreadsheet to read data the minimum possible, and perform all your operations in memory (using your arrays of data in VBA instead of the underlying spreadsheet). Once all is done, write it once. Big performance boost! Try it yourself to compare: have a random column of a few hundred to thousands rows, do one macro that loop through that column reading from the spreadsheet every time, and an other that will first read the whole column, and then loop through it using the VBA array.
06:30 Ironically, my arbitrary guideline at work (in IT) is that if I need to do VBA in Excel it might be time to consider switching to "actual" coding in an "actual" programming language. But to make a ludicrously overengineered dashboard with conditional formatting so I can keep an eye on tax-loss harvesting opportunities (or stuff like that such as keeping a portfolio balanced / rebalancing, etc.) Excel or another spreadsheet software is a great tool (I use Google Sheets for my personal finances).
As a software architect, I like Excel. The files themselves are goofy and have a lot of quirks, but the ubiquity and familiarity with users is so valuable and reduces friction between orgs.
I hope you revist this topic again. Maybe with some recomendations on excel/google sheets books or courses. I'm a construction worker and not an academic but over the last few years simply tracking my personal finances and working towards real goals has made all the difference for me.
Excel built my career. Nothing against my alma mater, but Excel did more for my career and improving my skills than going to college. And I had almost zero training That's part of the power of Excel, you can just start using it and pick things up almost naturally over time. From there, Excel gave me a sound understanding of the basics of formulas and then I could use that logic and apply it to other programming like Qlik, Tableau and even to a degree, SQL. And over the past 20 years I would hear company after company and expert after expert talking about the need to get away from Excel completely, yet here we are still with a need for Excel in every day tasks and reporting. Meanwhile it's has greatly improved its capabilities to the point where on some level it can do just about anything that any analyst or decision maker really needs.
Absolutely! Today, with 365 and Power Query the only real limitation is size. Otherwise, there isn't much that Excel can't do in terms of analysis and data transformation (ETL).
"Meanwhile it's has greatly improved its capabilities to the point where on some level it can do just about anything that any analyst or decision maker really needs." Oh? Did they add XGBoost, SHAP, deep learning, n-dimensional interpolation, Hilbert Curves, and get it to stop fucking up gene names? Would be news to me. Using Excel for my work would be like crossing the ocean in a dinghy. I applaud your achievement, but you've suffered much pain for naught.
and it's not just for finance. I'm a pharmacy student and I use excel/sheets for patient charting all the time. It helps me list all of the current medications being taken by my patients and is even more useful for determining why some of my patients experience certain side effects. Makes my life so much easier
Please do more videos about excel and VBA. It interesting to learn how someone can use these mechanisms to enhance their analytical abilities. This is from someone trying to make the switch from field HR to business analysts. Love the content. Always a top tier lecturer.
I have a degree in finance and even so I thought myself how to use Excel. I started by taking on projects like building DCF models and performing market analysis. Then I read the Excel Bible from front to back. Today, I'm doing work projects that include using Power Query to handle as many as 500k+ rows of data - something that Excel functions can't easily handle with that much data. Next, I plan to teach myself VBA using books and youtube videos. Excel is rather easy to learn if you assign yourself projects and start working with the program. The rest you can learn for free using google. Exceljet is a great source for referencing functions and Leila Gharani on youtube has great content among others.
Hilarious that you released this video today.. Just a few hours earlier I logged on to my mom's computer (we live in different countries) and helped her rebalance her portfolio, while talking to her on the phone.. first thing I did was open Excel and added her positions and some simple formulas to show simple percentage-changes would affect her positions. She was amazed by it, while for me it took maybe 30 seconds to type. (Eventually we did get rid of some older positions that were inherited from my grandpa and put that money into ETFs to better suit her risk profile and investment horizon).
you might want to include 'Application.ScreenUpdating = False' at the start of your VBA code, just stops the screen jumping around. Feels a bit more seemless. Hope this helps!!!
True story. In my first job, I used to compete with another analyst over who had the most "Excel-lent" skills. Eventually, it got so competitive that the CEO (an engineering nerd by trade and a small 80 person company) got us a little trophy we could display. Whenever we would win it back, the CEO and several others of a more nerdy persuasion, would ask what we did to deserve it. Became weirdly a thing. :)
I've made a DCF/DDM model and with that a watchlist, so I can just open up the watchlist and see the intrinsic value ratio. If I want to look at their finances I just click their ticker - taking me to the valuation and their 5-10 year numbers.
That's my next goal. Did you use Excel's Power Query to pull the data directly into Excel? How do you keep your file organized and not copy over old data with new data? Or do you just replace the entire time series each time you load the file?
@@MrSupernova111 no I enter it manually from Morning Star or Market Watch. When a new report comes out i just change the years, delete the oldest data, move it over and enter the new data. Doesn't take any time at all.
@@MrSupernova111 and for the organization I keep the main page stylish with filter options so i can sort by marketcap, a-z or intrinsic value ratio. On the data pages it's how i described in the last post. 😊 So every page for every company looks the same. The ddm/dcf-model up top and then I have my selected data (can't use every finacial sector in a 10k - would be too much clutter), revenue, net income, debt, equity, assets, cash and then i have a free cashflow calculator (cash from op less capex) and their cashflow less the dividends to see payout ratio.
It might be worth spending a bit of time learning Python, in particular using a library like Pandas in a Jupyter notebook (this is a very visual approach similar to Excel), it's a little more complex at first but it's much more powerful and less error prone. In Excel the computation logic is encoded in relationships across the cells which can make it very difficult to debug. In Python the computation logic is explicit. Importing data is also much easier.
Agree, python actually makes me dislike spreadsheets to a certain extent, although I do admit they are useful for “common or trivial” tasks that you don’t need to automate… python is so much better for automation
"bit of time" is like spending months until you can produce something and by that point you can go just to IT field and get better paid job. Excel is well documented and Indians come up with all kind of new things. With your tools you better have development skills already in place
You can generalize that by learning to program. Being able to program AND having the clever ideas on how to use that to get better insight gives an advance over those that don't.
I'm an entry level analyst and I'm amazed how powerful and customizable excel can be. In college I was worried it would be hard to get a job because I don't know how to code. But to be a fin analyst at my firm I was delighted to learn all they care about is excel skills lol
Have to comment that that dead pan picture of you heart Excel is excellent. I love Excel too. It's pretty much the greatest thing invented for computers since 1990
Let me just say, I can talk about how awesome Excel is for hours. One problem, AINT NO ONE wants to hear about how cool Excel is, at least in my circle of friends, that are around 18-20 years old (I am 21). So when I saw the name of your video I just thought "Yes... Who every is as exited about this video as me, is my kind of person, my kind of people" ahaha I knew my love and passion for Excel is not weird :D Great video, as always
i built a sheet that can automatically pull the prices of video games on amazon, to run purchasing calculations to see whats the most i should spend on buying a particular title to resell
I love excel / spreadsheets. I just came across your channel and I really like your content. I was curious if you have any advice about getting into the finance industry? Might be a good topic for a video (eg what you do day to day, advice for ppl who want to join) - but maybe you already have that! Anywho, great content. Cheers.
Im totally okay with being the Excel guy at work 😆 there is nothing more satisfying than spending hours on a new sheet and seeing it come to life! Especially when all the BQL formulas play ball lol... I appreciated this Excel gratitude vid 🙌 tx
Same! I spend all Friday evening working on a template to migrate 500k rows of financial data using Excel. I used Power Query and I'm very satisfied with the end result. It sucked working late on Friday but result is very clean and my team will know I built it to save them lots of time doing tedious manual work.
The keyword that Excel excels in is versatility. It's a jack of all trades, and it doesn't take much time or resources to set up. Compare this to Salesforce, where setting up is painful, development is even more of a pain due to its outdated Java backend, and its quarterly subscription cost is better spent on colonoscopy. If it were an Android game, it wouldn't be a pay-to-win one, but a pay-to-pay.
"Let me show this tool I'm super proud of" *Blurs everything but the tool bar* made me laugh, button 3 looked so cool with what ever the heck it was doing even while blurred, I'd be proud of it too
I think spreadsheets are useful, especially for prototyping. Although I prefer LO Calc because its superior UI (similar to pre-ribbon Excel) and better CSV support. However after I know exactly what I need, and the problem comes up again and again, I tend to rewrite them in Python (could be anything else, but that's what I prefer for it speed of writing code when running time is less important). It's just as versatile, and can do a lot of things, including graphs and lots of math functions.
If you go to college that has a finance major there is a good chance your student account has access to things like: - Bloomberg terminal - Barrons - Wall Street Journal - S&P Capital IQ - etc Talk to your librarian or make a friend with someone in finance who can show you the links to them!
Hey Richard that BBG annual subscription amount is correct with an important caveat, that's per GB per user! ~$27k only gets one log-in one GB of data!
amature tip: excel is amazing to keep track of what you boght/sold, for what price and how much proffit/loss you had. I don't use any formulas (yet) and it's already SO helpfull.
I could of told you Plain Bagel would know how to work those spreadsheets from the first look at him . No video needed . Enjoyed the video though . Thanks for the tips .
WOW !! I never clicked on a title so fast. Only recently started appreciating Excel after neglecting it for years. Great video idea can't wait to watch !
Love your channel. So tired of car salesmen trying to shill some investment. Just teach me things that can help me make good decisions. Much better plan.
I used to LOVE macros!! What a throwback my friend, thanks for the video. These days most of the things I would have done with macros (Data cleaning and arrangement) I have substituted with power queries. Thank you for this video, I enjoyed a lot.
Exactly what I was thinking!! I used macros in the past as well but now I use Power Query for the most complex projects. Some tasks are more difficult than others but I spend as much time as needed to come up with solutions that are intuitive and easy to update. The problem with macros is that if you change anything in the file the macros breaks down and most people won't be able to quickly fix the problem.
I have my own DCF model on a spreadsheet, the ability to track stock prices in real time and have it tell me when they meet my strike price is very useful
Hi Richard, any chance of making videos on "doing your job better with excel" for investment analysts? The models you showed looks interesting and I was wondering if I can recreate for my firm.
Pura Vida from Costa Rica Plain Bagel, I recently discovered your channel and Im very thankful for it. Im trying to download the last Filing Detail for NU, but im not finding anywhere the "interactive Data" blue button... not sure if the SEC eliminated that feature :(
Disclaimer: VBA is constantly voted one of the most disliked programming language to work with. Use at your own risk! That being said, it will earn you "Excel Chad" status if that's something you're into.
It's a boomer programming language and I used to see it in a lot of analyst description, now I hardly see it. Will slow you down if you have lots of data. In IB I would imagine excel is sufficient
In small companies with sh*tty data management practices, VBA is useful to try and get data from bad formats (i.e. custom / weirdly laid out spreadsheets into nice data formats). Source: Me, as a data analyst within a small fund.
Obviuously you cant share the individual indicators you use on the daily, but do you have a resource with ALL the indicators (from which you pickef out the ones you think should be used).
Sorry for the late comment. Just wanted to say thank you for making this video talking about applications of excel in finance. I work as a chemical technologist and we also use excel everyday to analyze our data. We do things like formatting, manipulating, making different templates, calculations, corrections, pulling data from our detectors etc etc. Unfortunately there are so many little annoyances with the macros at my work that i have started constantly trying to change things or figure out how the VBA works. I was seriously looking for a good tutorial on excel to help me build better macros thank you :). Also the data analysis you do in finance and at your job looks so interesting! I've been watching your videos for a while now and as a scientist working in finance looks so cool. I love the amount of quantitative data and analysis required nowadays. Makes me want to reach out for some job opportunities in finance :D
Is there a good group/website that will answer any finance-related questions I may think up? I tried several on Reddit, but couldn't get off the ground as I needed merit points before being entitled to ask my question - kinda pointless.
What are you trying to learn? If you want to learn things like DCF models then get a college textbook on Principles of Finance. If you want to learn how to read financial statements then get a book on Financial (Reporting) Accounting. If you want to learn about various investments get a book on Principles of Investments. After you learn all this then you're ready to perform security analysis and start picking stocks or creating your own forecast models. But then, you need to have a strong grasp on economic concepts and the current state of fiscal and monetary policy and political environment. I'm not away of any one group that covers all this but you can surely find groups that cover portions of this topics although they're no replacement for a formal education. Good luck!
What is your opinion on using jupyter notebooks and associated python tools like numpy, pandas and matplotlib? I heard they're popular in some parts of finance. As a coding nerd it might be easier for me to write python scripts to track personal finance than build excel sheets.
You’d be better off tracking personal finance with excel Jupiter notebooks is an interesting solution but it’d be more work to get it all set up than just make or use a pre made template. Excel is a great spreadsheet software, personal finance is relatively small and can fit on a single sheet Doing software we only tend to hate excel when people try to make it something it’s not suited for, like being a UI. ( I complain about excel a lot ) Excel starts having problems when you need to reference things likely to break, or if you are trying to use with an external program
Unexpected but extremely informational! Thanks for the reverse engineering thing. I was needing something like that! Please give us some more content on Excel. Also, could you make a video about Morningstar?
They're common in the scientific community, in genetics, in statistics, etc... I can't speak for finance, but finance tends to be big corporate firms, and they tend to be... lowest common denominator in their approach. From a programming approach I wouldn't expect a Quant fund to use a scripting language in production... but as they may not be programmers they may not be well informed on why that may not be a good idea. Of course they could use them extensively for analysis while using something else for live trade execution. It's not that uncommon for researchers to train models in R or Python but run the final model in C++ in the production environment.
Hi, ive been a great fan of your content for a while now, keep up the great work. I do have a quick question that i hope to get some insight. I work as a junior sell side equity research analyst at an investment bank in the UK. What stood out to me in this video is when you said you build up all of those macros, templates etc for your employer. Was all of those your initiatives, or were you under directions to do so? Im asking because, my job mostly revolves about executing analysis on behalf of senior analysts and i was wondering if i should maybe show some initiative. I'd appreciate your insight.
Most of it was self-guided, but I also work for a very small company. It was a rare opportunity where I had the flexibility to build some tools (some bigger companies are more reluctant to adopt employee-made tools) AND there were some low-hanging fruit that I could take advantage of when I first joined (I.e. simple processes I could easily automate for the form). But I’d say there’s no harm in showing initiative and trying to build something useful!
I have a question .when u deposit on bank we get money as interest. But in share market we get money based on demand. So does that make it non productive assets. What if company perform is good, but demand go down due to irrational behaviour of seller? And how can we get money similar to bank deposit if demand is not there. How can we sure that people will buy a piece of paper with share market certificate which create monkey on paper ? Could you please answer my question
Sure, when investing in stocks you take a liquidity risk; which means that if you want out at the time others don’t want in, you may have to accept a price below it’s intrinsic value. It’s helpful however to think of stocks for what they are, which is a piece of ownership of a company. Some day your fellow investors will be optimistic and think the company will be great, other days they will think everything is going to zero, and so the market value of the company goes up and down with that (Warren Buffet has great analogies about this, look for his name and Mister Market). So yes the price will go up and down, but in the end that stock is a piece of ownership of a company, and as long as the company is producing cash flows and profits, it will always have value and people will always want to buy it from you. Because realize this: if the price gets too low, when people would not want to buy, a competitor or an investor could simply buy all the shares and own the total company for a bargain. Besides market crashes this would be pretty rare, as it just means that people are selling $100 for $10 for example, and most people tend not to do that. If you want to have the highest level of certainty that there is demand for your stock a well-diversified, large ETF rather than an individual stock might be the way to go, which gives you a piece of ownership of many companies at the same time (and if the price would ever get too low a market maker will take it off your hands for you), so the risk is even lower. I’m sure there’s a video somewhere on this channel about ETFs
I use Excel in my day job too and love it. During lockdown I helped people create an expense tracker from downloading their online bank transactions so they could see where there money went and help them while their income was down. Ir was very satisfying to help people in a time of need! Great video!
Great video about something that a lot of people sometimes forget. A lot of industries use excel as well (even those that do heavy programming themselves).
Aslo, in 1997, I had create a electronic catalogue with Excell, color imaging, price sheet, description.....I was ready for online sale... Only one problem: internet didn't exist......in 1997 My sale wen't from $2 millions to $25 millions.....per year.....just with the catalogue....and old fasion thermal fax
Happy Friday everyone! Visit the following link for a 7 day free trial plus 25% off a Premium membership with Blinkist: www.blinkist.com/theplainbagel
can you make a video on how to do all this good tricks ?
It would be fun for you to have a video interview with Strong Man Personal Finance
It looks like your VBA script is updating the spreadsheet a lot. Pro tips: only access the spreadsheet to read data the minimum possible, and perform all your operations in memory (using your arrays of data in VBA instead of the underlying spreadsheet). Once all is done, write it once. Big performance boost!
Try it yourself to compare: have a random column of a few hundred to thousands rows, do one macro that loop through that column reading from the spreadsheet every time, and an other that will first read the whole column, and then loop through it using the VBA array.
Oh, what does "The Plain Douche" have to say?
Oh, nothing of value. Again.
@@macrogenii Wow, nice feedback. You must be a quality individual.
Optimist: the glass is 1/2 full
Pessimist: the glass is 1/2 empty
Excel: the glass is January 2nd.
Plain bagel : one of the only qualified finance TH-cam channels
VALID
Some of the best investments are boring, plain, low but consistent returns.
@@jamesgatz5301that's why most investors don't make money, it's too boring to do it properly
06:30 Ironically, my arbitrary guideline at work (in IT) is that if I need to do VBA in Excel it might be time to consider switching to "actual" coding in an "actual" programming language. But to make a ludicrously overengineered dashboard with conditional formatting so I can keep an eye on tax-loss harvesting opportunities (or stuff like that such as keeping a portfolio balanced / rebalancing, etc.) Excel or another spreadsheet software is a great tool (I use Google Sheets for my personal finances).
As a software architect, I like Excel. The files themselves are goofy and have a lot of quirks, but the ubiquity and familiarity with users is so valuable and reduces friction between orgs.
I hope you revist this topic again. Maybe with some recomendations on excel/google sheets books or courses.
I'm a construction worker and not an academic but over the last few years simply tracking my personal finances and working towards real goals has made all the difference for me.
As I've gotten to use excel more I'm glad other people also get excited about spreadsheets. Thanks Richard, you are the finance TH-camr we need.
Excel built my career. Nothing against my alma mater, but Excel did more for my career and improving my skills than going to college. And I had almost zero training That's part of the power of Excel, you can just start using it and pick things up almost naturally over time.
From there, Excel gave me a sound understanding of the basics of formulas and then I could use that logic and apply it to other programming like Qlik, Tableau and even to a degree, SQL.
And over the past 20 years I would hear company after company and expert after expert talking about the need to get away from Excel completely, yet here we are still with a need for Excel in every day tasks and reporting. Meanwhile it's has greatly improved its capabilities to the point where on some level it can do just about anything that any analyst or decision maker really needs.
Absolutely! Today, with 365 and Power Query the only real limitation is size. Otherwise, there isn't much that Excel can't do in terms of analysis and data transformation (ETL).
"Meanwhile it's has greatly improved its capabilities to the point where on some level it can do just about anything that any analyst or decision maker really needs." Oh? Did they add XGBoost, SHAP, deep learning, n-dimensional interpolation, Hilbert Curves, and get it to stop fucking up gene names? Would be news to me. Using Excel for my work would be like crossing the ocean in a dinghy. I applaud your achievement, but you've suffered much pain for naught.
@@zvxcvxcz . I'm tired of you. Blocked.
Guy at my office has “I
Imagine if the mug said, “I ❤️ to spreadsheets” 😂
and it's not just for finance. I'm a pharmacy student and I use excel/sheets for patient charting all the time. It helps me list all of the current medications being taken by my patients and is even more useful for determining why some of my patients experience certain side effects. Makes my life so much easier
Imagine you take more medicancion, than a pharmaciast can put on a list.
Please do more videos about excel and VBA. It interesting to learn how someone can use these mechanisms to enhance their analytical abilities. This is from someone trying to make the switch from field HR to business analysts. Love the content. Always a top tier lecturer.
I have a degree in finance and even so I thought myself how to use Excel. I started by taking on projects like building DCF models and performing market analysis. Then I read the Excel Bible from front to back. Today, I'm doing work projects that include using Power Query to handle as many as 500k+ rows of data - something that Excel functions can't easily handle with that much data. Next, I plan to teach myself VBA using books and youtube videos. Excel is rather easy to learn if you assign yourself projects and start working with the program. The rest you can learn for free using google. Exceljet is a great source for referencing functions and Leila Gharani on youtube has great content among others.
The youtube algorithm is really tuned in to the type of freak I am. Love me a good spreadsheet video.
Hilarious that you released this video today.. Just a few hours earlier I logged on to my mom's computer (we live in different countries) and helped her rebalance her portfolio, while talking to her on the phone.. first thing I did was open Excel and added her positions and some simple formulas to show simple percentage-changes would affect her positions. She was amazed by it, while for me it took maybe 30 seconds to type. (Eventually we did get rid of some older positions that were inherited from my grandpa and put that money into ETFs to better suit her risk profile and investment horizon).
you might want to include 'Application.ScreenUpdating = False' at the start of your VBA code, just stops the screen jumping around. Feels a bit more seemless. Hope this helps!!!
I was literally about to write this comment 😂
Programmers and correcting random code on the internet. Name a more iconic duo
Also would make your code run faster
Cool nice to know
He probably took that line of code out to make it obvious for people watching the video that the program was running.
Myman richard starting off 2022 with a fire video!
The most disappointing part about excel is making a sick spreadsheet and not being able to share your excitement with anyone else about it 😞 lol
No one is more excited about my excel skills than me. I know this sadness personally lol
Powerbi
Yes. We need a spreadsheet nerds social media group and/or platform..
I have one big excel spreadsheet file that I updated daily since 2011. And I can't share that excitement even with my closest dearest friend.
True story. In my first job, I used to compete with another analyst over who had the most "Excel-lent" skills. Eventually, it got so competitive that the CEO (an engineering nerd by trade and a small 80 person company) got us a little trophy we could display. Whenever we would win it back, the CEO and several others of a more nerdy persuasion, would ask what we did to deserve it. Became weirdly a thing. :)
I've made a DCF/DDM model and with that a watchlist, so I can just open up the watchlist and see the intrinsic value ratio. If I want to look at their finances I just click their ticker - taking me to the valuation and their 5-10 year numbers.
That's my next goal. Did you use Excel's Power Query to pull the data directly into Excel? How do you keep your file organized and not copy over old data with new data? Or do you just replace the entire time series each time you load the file?
@@MrSupernova111 no I enter it manually from Morning Star or Market Watch. When a new report comes out i just change the years, delete the oldest data, move it over and enter the new data. Doesn't take any time at all.
@@MrSupernova111 and for the organization I keep the main page stylish with filter options so i can sort by marketcap, a-z or intrinsic value ratio. On the data pages it's how i described in the last post. 😊 So every page for every company looks the same. The ddm/dcf-model up top and then I have my selected data (can't use every finacial sector in a 10k - would be too much clutter), revenue, net income, debt, equity, assets, cash and then i have a free cashflow calculator (cash from op less capex) and their cashflow less the dividends to see payout ratio.
@@dividendking3686 . Thanks for the info! Cheers!
It might be worth spending a bit of time learning Python, in particular using a library like Pandas in a Jupyter notebook (this is a very visual approach similar to Excel), it's a little more complex at first but it's much more powerful and less error prone. In Excel the computation logic is encoded in relationships across the cells which can make it very difficult to debug. In Python the computation logic is explicit. Importing data is also much easier.
Also can program python to read and write excel files if the end user really needs excel as interface.
Agree, python actually makes me dislike spreadsheets to a certain extent, although I do admit they are useful for “common or trivial” tasks that you don’t need to automate… python is so much better for automation
And where would you recommend someone who knows excel, but no python to learn about this stuff?
"bit of time" is like spending months until you can produce something and by that point you can go just to IT field and get better paid job. Excel is well documented and Indians come up with all kind of new things. With your tools you better have development skills already in place
You can generalize that by learning to program. Being able to program AND having the clever ideas on how to use that to get better insight gives an advance over those that don't.
It really shows how much I trust you that I'm watching a video about excel
Boring or not, not ever leaving this channel! (Your vids aren't boring, BTW.)
I just started as an analyst and this is exactly what i needed. Please more of the excel, Bloomberg, capita IQ etc videos
I'm an entry level analyst and I'm amazed how powerful and customizable excel can be. In college I was worried it would be hard to get a job because I don't know how to code. But to be a fin analyst at my firm I was delighted to learn all they care about is excel skills lol
Have to comment that that dead pan picture of you heart Excel is excellent.
I love Excel too. It's pretty much the greatest thing invented for computers since 1990
Let me just say, I can talk about how awesome Excel is for hours. One problem, AINT NO ONE wants to hear about how cool Excel is, at least in my circle of friends, that are around 18-20 years old (I am 21). So when I saw the name of your video I just thought "Yes... Who every is as exited about this video as me, is my kind of person, my kind of people" ahaha I knew my love and passion for Excel is not weird :D Great video, as always
i built a sheet that can automatically pull the prices of video games on amazon, to run purchasing calculations to see whats the most i should spend on buying a particular title to resell
why amazon and not pricecharting?
Indeed, excel is life. Having a love for excel is *perfectly natural*, and don't let anyone tell you differently, you magnificent bastard!
I love excel / spreadsheets. I just came across your channel and I really like your content. I was curious if you have any advice about getting into the finance industry? Might be a good topic for a video (eg what you do day to day, advice for ppl who want to join) - but maybe you already have that! Anywho, great content. Cheers.
Im totally okay with being the Excel guy at work 😆 there is nothing more satisfying than spending hours on a new sheet and seeing it come to life! Especially when all the BQL formulas play ball lol... I appreciated this Excel gratitude vid 🙌 tx
What if you make a mistake
Same! I spend all Friday evening working on a template to migrate 500k rows of financial data using Excel. I used Power Query and I'm very satisfied with the end result. It sucked working late on Friday but result is very clean and my team will know I built it to save them lots of time doing tedious manual work.
The keyword that Excel excels in is versatility. It's a jack of all trades, and it doesn't take much time or resources to set up.
Compare this to Salesforce, where setting up is painful, development is even more of a pain due to its outdated Java backend, and its quarterly subscription cost is better spent on colonoscopy. If it were an Android game, it wouldn't be a pay-to-win one, but a pay-to-pay.
"Let me show this tool I'm super proud of"
*Blurs everything but the tool bar*
made me laugh, button 3 looked so cool with what ever the heck it was doing even while blurred, I'd be proud of it too
Finally someone who understands me
Please could you do a case study of a stock or investment using excel?
I think spreadsheets are useful, especially for prototyping. Although I prefer LO Calc because its superior UI (similar to pre-ribbon Excel) and better CSV support.
However after I know exactly what I need, and the problem comes up again and again, I tend to rewrite them in Python (could be anything else, but that's what I prefer for it speed of writing code when running time is less important). It's just as versatile, and can do a lot of things, including graphs and lots of math functions.
If you go to college that has a finance major there is a good chance your student account has access to things like:
- Bloomberg terminal
- Barrons
- Wall Street Journal
- S&P Capital IQ
- etc
Talk to your librarian or make a friend with someone in finance who can show you the links to them!
Hey Richard that BBG annual subscription amount is correct with an important caveat, that's per GB per user! ~$27k only gets one log-in one GB of data!
amature tip: excel is amazing to keep track of what you boght/sold, for what price and how much proffit/loss you had.
I don't use any formulas (yet) and it's already SO helpfull.
I could of told you Plain Bagel would know how to work those spreadsheets from the first look at him . No video needed . Enjoyed the video though . Thanks for the tips .
WOW !! I never clicked on a title so fast. Only recently started appreciating Excel after neglecting it for years.
Great video idea can't wait to watch !
Same - I regret not taking it more seriously once graduating from university. But better late than never.
@@derekcanmexit w
I'd like to take a moment to thank today's sponsor excel... I mean blinkist 😆
its good to have things to Excel in.
Love your channel. So tired of car salesmen trying to shill some investment. Just teach me things that can help me make good decisions. Much better plan.
Can you PLEASE show how you built these macros? Even with dummy data?
Wild this did not show up in my feed till now.
I took a few accounting classes and lived in excel for awhile.
That was gold! I never knew about the SEC page. If I could like twice - I would, just for that.
I used to LOVE macros!! What a throwback my friend, thanks for the video. These days most of the things I would have done with macros (Data cleaning and arrangement) I have substituted with power queries. Thank you for this video, I enjoyed a lot.
Exactly what I was thinking!! I used macros in the past as well but now I use Power Query for the most complex projects. Some tasks are more difficult than others but I spend as much time as needed to come up with solutions that are intuitive and easy to update. The problem with macros is that if you change anything in the file the macros breaks down and most people won't be able to quickly fix the problem.
This is so me :) I love this video so much, I use Excel all the time!
Not a sexy video, but definitely a useful one. Thanks for the quality of information!
How dare you???!
Excel is very sexy😍🤓
I have my own DCF model on a spreadsheet, the ability to track stock prices in real time and have it tell me when they meet my strike price is very useful
Can you share that with us?
Yeah that would be greatly appreciated!
Can you share with us please??
Sharing is caring!!
share senpai
Happy new year Mr. Plain Bagel! Really love the videos
Hey, Plain Bagel, are you able to beat the market index returns?
Richard is the 🐐
this episode is practical
Thanks for the video and the links. I would like to learn how to use Excel to make my life easier. I will be checking this info out
Hi Richard, any chance of making videos on "doing your job better with excel" for investment analysts? The models you showed looks interesting and I was wondering if I can recreate for my firm.
Automation superhero! 🦸
Pura Vida from Costa Rica Plain Bagel, I recently discovered your channel and Im very thankful for it. Im trying to download the last Filing Detail for NU, but im not finding anywhere the "interactive Data" blue button... not sure if the SEC eliminated that feature :(
which excel or microsoft courses would you recommend? Are there any specific courses finance employers are looking for?
I see what you did there in the last 😂😂😂hope it is not as bad as 2020 but only time will tell
I love this topic!
Excellent video Richard
Koyfin is a good option for pulling 10 years of financial statements in excel format.
Disclaimer: VBA is constantly voted one of the most disliked programming language to work with. Use at your own risk!
That being said, it will earn you "Excel Chad" status if that's something you're into.
It's a boomer programming language and I used to see it in a lot of analyst description, now I hardly see it. Will slow you down if you have lots of data. In IB I would imagine excel is sufficient
Personally, I hate VBA. I would rather learn a bit of Pandas and work with Python.
Funny, VBA is the only programming language I liked to use. I'm not a programmer anymore though.
In small companies with sh*tty data management practices, VBA is useful to try and get data from bad formats (i.e. custom / weirdly laid out spreadsheets into nice data formats). Source: Me, as a data analyst within a small fund.
@@matthewshedden6456 I work for a large aerospace company and still end up using VBA because everyone is a boomer that only knows excel lol
excel is great for everything. I'm studying engineering rn and we use it for every lab
Then Mathcad will blow your mind. It's literally my favorite program.
P. S. Civil engineer here👷🏼♂️
@@LMZ29 is that similar to Matlab? cuz we've done a bit of Matlab work
@@kadenw8068 it's like Word and Excel had a child 😂
@@LMZ29 bet I'll keep an eye out for it
Cool. Thanks for sharing this
Someone has finally said it !
I know right?!?!
Can't believe it though 🤣
What have you got to say about Google sheets?
how do we do that actually ? I see the formula is hidde, or ? thanks !
Obviuously you cant share the individual indicators you use on the daily, but do you have a resource with ALL the indicators (from which you pickef out the ones you think should be used).
Love excel and love tpb
Sorry for the late comment. Just wanted to say thank you for making this video talking about applications of excel in finance. I work as a chemical technologist and we also use excel everyday to analyze our data. We do things like formatting, manipulating, making different templates, calculations, corrections, pulling data from our detectors etc etc. Unfortunately there are so many little annoyances with the macros at my work that i have started constantly trying to change things or figure out how the VBA works. I was seriously looking for a good tutorial on excel to help me build better macros thank you :).
Also the data analysis you do in finance and at your job looks so interesting! I've been watching your videos for a while now and as a scientist working in finance looks so cool. I love the amount of quantitative data and analysis required nowadays. Makes me want to reach out for some job opportunities in finance :D
Is there a good group/website that will answer any finance-related questions I may think up? I tried several on Reddit, but couldn't get off the ground as I needed merit points before being entitled to ask my question - kinda pointless.
What are you trying to learn? If you want to learn things like DCF models then get a college textbook on Principles of Finance. If you want to learn how to read financial statements then get a book on Financial (Reporting) Accounting. If you want to learn about various investments get a book on Principles of Investments. After you learn all this then you're ready to perform security analysis and start picking stocks or creating your own forecast models. But then, you need to have a strong grasp on economic concepts and the current state of fiscal and monetary policy and political environment. I'm not away of any one group that covers all this but you can surely find groups that cover portions of this topics although they're no replacement for a formal education. Good luck!
where did you learn all this
i know i will be able to learn it if i wanted to but dint know where to start
How do you feel about google sheets?
While you obviously can't show your trackers and metrics, do you have a resource/book/something with ALL the metrics for easier study?
Great video! The world needs more Excel evangelists like you!
content i didnt know i needed
Every .NET engineer just slapped their forehead when you talked about VBA (myself included)
Hes not a programmer. Its fine for other professiona
@@hanro7430 I know, it's time VBA died a peasant's death though :)
For better or worse VBA still makes the world go round. But yeah... It should die, but it never will
This is unbelievably valuable information for completely free. You are amazing!
excel is excellent database calculator.
Any free financial anaisys tools to get info from?
What is your opinion on using jupyter notebooks and associated python tools like numpy, pandas and matplotlib? I heard they're popular in some parts of finance.
As a coding nerd it might be easier for me to write python scripts to track personal finance than build excel sheets.
You’d be better off tracking personal finance with excel
Jupiter notebooks is an interesting solution but it’d be more work to get it all set up than just make or use a pre made template.
Excel is a great spreadsheet software, personal finance is relatively small and can fit on a single sheet
Doing software we only tend to hate excel when people try to make it something it’s not suited for, like being a UI. ( I complain about excel a lot )
Excel starts having problems when you need to reference things likely to break, or if you are trying to use with an external program
Unexpected but extremely informational! Thanks for the reverse engineering thing. I was needing something like that! Please give us some more content on Excel. Also, could you make a video about Morningstar?
is using R or MATLAB common in the industry? or is that more for the quant funds and such?
They're common in the scientific community, in genetics, in statistics, etc... I can't speak for finance, but finance tends to be big corporate firms, and they tend to be... lowest common denominator in their approach. From a programming approach I wouldn't expect a Quant fund to use a scripting language in production... but as they may not be programmers they may not be well informed on why that may not be a good idea. Of course they could use them extensively for analysis while using something else for live trade execution. It's not that uncommon for researchers to train models in R or Python but run the final model in C++ in the production environment.
How can I reference the last non empty cell in a column
Hi, ive been a great fan of your content for a while now, keep up the great work. I do have a quick question that i hope to get some insight. I work as a junior sell side equity research analyst at an investment bank in the UK. What stood out to me in this video is when you said you build up all of those macros, templates etc for your employer. Was all of those your initiatives, or were you under directions to do so? Im asking because, my job mostly revolves about executing analysis on behalf of senior analysts and i was wondering if i should maybe show some initiative. I'd appreciate your insight.
Most of it was self-guided, but I also work for a very small company. It was a rare opportunity where I had the flexibility to build some tools (some bigger companies are more reluctant to adopt employee-made tools) AND there were some low-hanging fruit that I could take advantage of when I first joined (I.e. simple processes I could easily automate for the form). But I’d say there’s no harm in showing initiative and trying to build something useful!
lol, this video was really exciting to me!
I have a question .when u deposit on bank we get money as interest. But in share market we get money based on demand. So does that make it non productive assets. What if company perform is good, but demand go down due to irrational behaviour of seller? And how can we get money similar to bank deposit if demand is not there. How can we sure that people will buy a piece of paper with share market certificate which create monkey on paper ? Could you please answer my question
Here’s the basics how stock exchanges work : th-cam.com/video/F3QpgXBtDeo/w-d-xo.html
Sure, when investing in stocks you take a liquidity risk; which means that if you want out at the time others don’t want in, you may have to accept a price below it’s intrinsic value. It’s helpful however to think of stocks for what they are, which is a piece of ownership of a company. Some day your fellow investors will be optimistic and think the company will be great, other days they will think everything is going to zero, and so the market value of the company goes up and down with that (Warren Buffet has great analogies about this, look for his name and Mister Market). So yes the price will go up and down, but in the end that stock is a piece of ownership of a company, and as long as the company is producing cash flows and profits, it will always have value and people will always want to buy it from you. Because realize this: if the price gets too low, when people would not want to buy, a competitor or an investor could simply buy all the shares and own the total company for a bargain. Besides market crashes this would be pretty rare, as it just means that people are selling $100 for $10 for example, and most people tend not to do that. If you want to have the highest level of certainty that there is demand for your stock a well-diversified, large ETF rather than an individual stock might be the way to go, which gives you a piece of ownership of many companies at the same time (and if the price would ever get too low a market maker will take it off your hands for you), so the risk is even lower. I’m sure there’s a video somewhere on this channel about ETFs
So it's not possible to analyse data with other tools like Python? What about non-Excel spreadsheets?
I use Excel in my day job too and love it. During lockdown I helped people create an expense tracker from downloading their online bank transactions so they could see where there money went and help them while their income was down. Ir was very satisfying to help people in a time of need! Great video!
Great video about something that a lot of people sometimes forget. A lot of industries use excel as well (even those that do heavy programming themselves).
I love Excel as well
Unexpected, but I’m delighted
Richard what the NFT ??? where is my free XLS stock analyzer ?
Exactly what I needed. Thx Richard!
Hi Richard, I always enjoy your energy and personality as a youtube. Thank you for informative contents!
anythings against sheets?
Gotta fix that lav mic pretty tinny sounding audio.
Aslo, in 1997, I had create a electronic catalogue with Excell, color imaging, price sheet, description.....I was ready for online sale...
Only one problem: internet didn't exist......in 1997
My sale wen't from $2 millions to $25 millions.....per year.....just with the catalogue....and old fasion thermal fax
What company does he work for?