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.

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

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.

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.

Imagine you take more medicancion, than a pharmaciast can put on a list.

Imagine if the mug said, “I ❤️ to spreadsheets” 😂

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.

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.

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. :)

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.

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!

Can you share that with us?

Yeah that would be greatly appreciated!

Can you share with us please??

Sharing is caring!!

share senpai

why amazon and not pricecharting?

Same - I regret not taking it more seriously once graduating from university. But better late than never.

@@derekcanmexit w

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.

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.

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

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.

How dare you???! Excel is very sexy😍🤓

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

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 know right?!?!

Can't believe it though 🤣

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.

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!

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?

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!

😂

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

"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.

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!

Read the book Corporate Finance by Stephen Ross. Also study for a CFA certification. Thats all you need.

@@ivanguillermovallenasmunoz5763 thank you

Here’s the basics how stock exchanges work : kzfaq.info/get/bejne/fJmBo8qJp9qolaM.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

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

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.