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.
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.
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).
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
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.
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.
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.
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. :)
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).
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.
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!
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'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
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.
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
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
"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
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.
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!
@@Pain-nw7gv I would recommend finding a free course online (something like code academy) along with W3 schools. Once you have the basics, do a personal project related to what you’ve learned and you’ll be in a good spot to start interviewing.
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 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.
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.
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 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 .
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.
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.
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 !
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
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.
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 :(
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.
@@lizzielizardlipz I just needed to see the thumbnail to understand what he wanted to say, he just didn't say Microsoft straight out, because of legal reasons.
excel gives me sort of ptsd of being forced to use it for boring stuff at university and at 8-5 office job, but I have to admit when you use it for projects you actually care about its kinda fun to use
If Excel gives you ptsd then you aren't using Excel correctly and see it as a cumbersome task. When you find yourself spending hours doing manual work that can be automated you'll gain much appreciation for tools like Excel.
@@MrSupernova111 Because using Excel is and always will be a cumbersome task. If you find yourself using Excel, it's because Excel is the only tool you know. Everything looks like a nail when all you've got is a hammer.
Speaking of data visualization, what I love to do with Excel is on the stock screener I made on it I can use conditional formatting to help highlight certain data. For instance, I have columns for P/S, EV'S, EV/EBITDA, EV/E, and P/E. In each of those columns I also have it set to look at the data in each row and put it on a scale, red for the higher multipules of the set, yellow for middle, and green for the lower multiples. This allows me to easily see, since I have them already grouped by sector, which companies are performing well based on their relative peers. I also do the same for ROE and ROIC. It isn't the end all be all but it gives me a good place to start when looking for where I should be spending my time and attention.
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).
You don’t need a lot of experience with Excel to know you hate it. That’s like saying someone can’t decide they don’t like sardines until they eat 100 tins of them.
I think only an amateur would say such a thing. When you find yourself spending hours doing boring manual work that can be automated you'll gain much more appreciation for Excel.
@@MrSupernova111 I've used Excel extensively for several years and know plenty about it. I think you're just calling me an amateur because you can't explain what's so great about Excel because it isn't great.
@@tomcotter4299 . That's comical considering that I've been using Excel for over a decade and I work in finance. But hey, continue patting yourself in the back.
Lol so? How does that make your opinion on Excel superior to mine? I’ve been financial analyst for a Fortune 100 insurance company. My education is in finance. I have all of the same qualifications as you but I don’t think Excel is a great program. You seem to think your credentials validate your stupid opinion-they don’t. Excel sucks, idiot. You just have trash taste in software.
Lol. The only reason I used excel is literally for stocks and spreadsheets. I have dozens stock portfolios that I’ve created. I even have retirement calculators that i use for tax havens
"now"? R is almost 30 years old. Excel predates it only by 8 years. If you count the predecessor S it's actually older than Excel. Excel is dominant for the same reason why we have GUIs instead of command line interfaces, even though many professionals prefer the command line. The barrier to entry is much lower. You see cells, you click on it, enter something, what you entered is in the cell. Everyone gets that. If people see a command line they start to freak out because they have no idea where to start.
@@bultvidxxxix9973 ... I think it's more that dumbasses can only fuck up so much with Excel. We've literally got the data cells for R if you use Rstudio.
If you were ever curious to determine how much of a nerd Richard is, this is the only data point you need, his first video of the year amid this odd market is an excel video 🤣
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!
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).
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
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?
I manage hundred of million of project with the oil industries in Canada....and also in 2003 I start my full automated manufactured facility, ship in NorthAmerica and Europe.... I accomplish that with the $120 Excel software.........come with MicrosoftSuite Not to mention I saw multiple business...spend humdred of thousand dollar with managing software and they all fail...resaon...the seller want a monthly payment for upgrade... Microsoft is part of my wealth
Correct me if I'm wrong, but Python isn't made for visual presentations and if your boss has to share the data how many qualified people in need of this data can manipulate the shared data in Python?
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
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 RUclips 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
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.
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).
Guy at my office has “I
Imagine if the mug said, “I ❤️ to spreadsheets” 😂
As I've gotten to use excel more I'm glad other people also get excited about spreadsheets. Thanks Richard, you are the finance RUclipsr 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.
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.
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.
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.
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.
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.
The youtube algorithm is really tuned in to the type of freak I am. Love me a good spreadsheet 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. :)
It really shows how much I trust you that I'm watching a video about excel
I just started as an analyst and this is exactly what i needed. Please more of the excel, Bloomberg, capita IQ etc videos
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).
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!
Myman richard starting off 2022 with a fire video!
Boring or not, not ever leaving this channel! (Your vids aren't boring, BTW.)
Indeed, excel is life. Having a love for excel is *perfectly natural*, and don't let anyone tell you differently, you magnificent bastard!
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!
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?
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
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.
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
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
Wild this did not show up in my feed till now.
"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
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.
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!
Once you learn SQL and the basics of relational databases, Excel loses a lot of its appeal but Excel still has its niche.
True I use it a lot
Can you recommend where can I learn sql? I am interested but do not know where to start.
@@Pain-nw7gv code code and w3 school. On the job training is better though
@@silviodomenico Thanks
@@Pain-nw7gv I would recommend finding a free course online (something like code academy) along with W3 schools. Once you have the basics, do a personal project related to what you’ve learned and you’ll be in a good spot to start interviewing.
I'd like to take a moment to thank today's sponsor excel... I mean blinkist 😆
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
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
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.
I took a few accounting classes and lived in excel for awhile.
Finally someone who understands me
Please could you do a case study of a stock or investment using excel?
This is so me :) I love this video so much, I use Excel all the time!
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.
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.
Koyfin is a good option for pulling 10 years of financial statements in excel format.
Happy new year Mr. Plain Bagel! Really love the videos
its good to have things to Excel in.
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 .
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
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.
If you want to earn insane levels of money having just one skill, excel is a great option.
Someone has finally said it !
I know right?!?!
Can't believe it though 🤣
Can you PLEASE show how you built these macros? Even with dummy data?
Not a sexy video, but definitely a useful one. Thanks for the quality of information!
How dare you???!
Excel is very sexy😍🤓
That was gold! I never knew about the SEC page. If I could like twice - I would, just for that.
Excellent video Richard
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.
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
Richard is the 🐐
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
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
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
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 :(
I love this topic!
Cool. Thanks for sharing this
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.
So buy Microsoft stocks, got it!
😂
@@lizzielizardlipz I just needed to see the thumbnail to understand what he wanted to say, he just didn't say Microsoft straight out, because of legal reasons.
excel gives me sort of ptsd of being forced to use it for boring stuff at university and at 8-5 office job, but I have to admit when you use it for projects you actually care about its kinda fun to use
If Excel gives you ptsd then you aren't using Excel correctly and see it as a cumbersome task. When you find yourself spending hours doing manual work that can be automated you'll gain much appreciation for tools like Excel.
@@MrSupernova111 Because using Excel is and always will be a cumbersome task. If you find yourself using Excel, it's because Excel is the only tool you know. Everything looks like a nail when all you've got is a hammer.
@@zvxcvxcz . Clueless!
I see what you did there in the last 😂😂😂hope it is not as bad as 2020 but only time will tell
Speaking of data visualization, what I love to do with Excel is on the stock screener I made on it I can use conditional formatting to help highlight certain data. For instance, I have columns for P/S, EV'S, EV/EBITDA, EV/E, and P/E. In each of those columns I also have it set to look at the data in each row and put it on a scale, red for the higher multipules of the set, yellow for middle, and green for the lower multiples. This allows me to easily see, since I have them already grouped by sector, which companies are performing well based on their relative peers. I also do the same for ROE and ROIC. It isn't the end all be all but it gives me a good place to start when looking for where I should be spending my time and attention.
Hey, Plain Bagel, are you able to beat the market index returns?
When I was studying, during our 1st thesis defense, the first question is always is what is the value of your system that cant be done in excel. 😆
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).
content i didnt know i needed
Automation superhero! 🦸
Love excel and love tpb
Interviewer: “What do you think of Excel?”
Candidate: “I hate it so much!”
Interviewer: “So you have lot of experience with it then”
You don’t need a lot of experience with Excel to know you hate it. That’s like saying someone can’t decide they don’t like sardines until they eat 100 tins of them.
I think only an amateur would say such a thing. When you find yourself spending hours doing boring manual work that can be automated you'll gain much more appreciation for Excel.
@@MrSupernova111 I've used Excel extensively for several years and know plenty about it. I think you're just calling me an amateur because you can't explain what's so great about Excel because it isn't great.
@@tomcotter4299 . That's comical considering that I've been using Excel for over a decade and I work in finance. But hey, continue patting yourself in the back.
Lol so? How does that make your opinion on Excel superior to mine? I’ve been financial analyst for a Fortune 100 insurance company. My education is in finance. I have all of the same qualifications as you but I don’t think Excel is a great program.
You seem to think your credentials validate your stupid opinion-they don’t. Excel sucks, idiot. You just have trash taste in software.
Lol. The only reason I used excel is literally for stocks and spreadsheets. I have dozens stock portfolios that I’ve created. I even have retirement calculators that i use for tax havens
Its interesting how excel is still so dominant in many different fields when we now have things like R
"now"? R is almost 30 years old. Excel predates it only by 8 years. If you count the predecessor S it's actually older than Excel.
Excel is dominant for the same reason why we have GUIs instead of command line interfaces, even though many professionals prefer the command line. The barrier to entry is much lower. You see cells, you click on it, enter something, what you entered is in the cell. Everyone gets that. If people see a command line they start to freak out because they have no idea where to start.
@@bultvidxxxix9973 ... I think it's more that dumbasses can only fuck up so much with Excel. We've literally got the data cells for R if you use Rstudio.
Exactly what I needed. Thx Richard!
If you were ever curious to determine how much of a nerd Richard is, this is the only data point you need, his first video of the year amid this odd market is an excel video 🤣
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!
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).
which excel or microsoft courses would you recommend? Are there any specific courses finance employers are looking for?
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 : ruclips.net/video/F3QpgXBtDeo/видео.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
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?
Anyone that takes the time to learn VBA is about to get into python but just doesn't know it yet.
I love Excel as well
You should do a collab with Stand-up Maths on spreadsheets
I manage hundred of million of project with the oil industries in Canada....and also in 2003 I start my full automated manufactured facility, ship in NorthAmerica and Europe....
I accomplish that with the $120 Excel software.........come with MicrosoftSuite
Not to mention I saw multiple business...spend humdred of thousand dollar with managing software and they all fail...resaon...the seller want a monthly payment for upgrade...
Microsoft is part of my wealth
While you obviously can't show your trackers and metrics, do you have a resource/book/something with ALL the metrics for easier study?
Look at this cool thing I did!
*BLURRRRRRRRRRRRRRRRRRRRRRRRRRRRRR*
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
I LOVE Ms Excel. All my financial data is kept neatly in my beloved spreadsheets. Glad to know I'm not the only one.
As a programmer I would say this is why everyone should learn programming, even if it is just the basics.
Everyone? Even babies?
@@MayTheSchwartzBeWithYou Should incorporate it into the core curriculum at a young age.
@@12345krillin But...babies?
@@MayTheSchwartzBeWithYou yes!! We will need more fresh young workers in the future!
@@12345krillin I've heard of child labor, but baby labor is a new one.
In my previous job, I did everything with python, and when asked, I would output an excel file with pandas to make my boss happy.
Correct me if I'm wrong, but Python isn't made for visual presentations and if your boss has to share the data how many qualified people in need of this data can manipulate the shared data in Python?
Unexpected, but I’m delighted
lol, this video was really exciting to me!
excel is excellent database calculator.
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