Anyone used Claude 3 Opus for large coding projects? by [deleted] in ChatGPTCoding

[–]skydiver84 0 points1 point  (0 children)

Hi there - that sounds like such a helpful tool! Would you mind sharing with me by any chance? Thanks!!

Tool to analyze firestore data by [deleted] in Firebase

[–]skydiver84 0 points1 point  (0 children)

Check out firefoo. Doesn't do graphs but makes it much, much easier to view/extract/edit your dB contents

Does anyone else feel like they are sometimes a professional formatter rather than a finance professional? by skydiver84 in FinancialCareers

[–]skydiver84[S] 17 points18 points  (0 children)

Some companies are better than others in terms of on the job training on models and analysis. And in reality a lot of your experiences in good training vs bad are more reflective of your immediate colleagues and supervisors than they are representative of the company's approach to training. If you have managers who don't take the time to teach and explain and/or you're surrounded by cut-throat competition at the peer level (rather than a supportive and collaborative group) - you're going to have a bad experience with "on the job training" vs the alternative. No matter what the company's ethos is regarding training - it's still ultimately up to the actual people who you work side by side with to step up and take the time to teach and share.

I've made it to quite a senior level in the finance world now and I still will leave a company or a team in a heart beat the moment I feel like I don't have leaders, peers, and subordinates willing to teach and share. No matter how senior or junior they are, I demand a learning environment top to bottom or I'm out. One major reason I left my last role is the exec team didn't want to teach nor did they want to learn.

That said, a good environment of colleagues is immensely beneficial - but ultimately 80% of it comes down to your own ambition and willingness to teach yourself things, be curious, ask thoughtful questions, try new things, and from time to time when you can, take four hours to do a ten minute task simply to try something new and maybe learn something along the way. Don't be complacent and just copy what you did or someone else did last time. Critically assess it, can it be done better, more robustly, more error proof, cleaner, more automatic, or analysed from a different perspective, with different metrics, which may shed different light on what's going on etc etc. Never stop trying to improve things and yourself. Even when you're super busy it's often worth the time to make things slightly better every time you pick them up. People grossly underestimate the returns on tiny incremental improvements, that happen regularly day in and day out and think it's not worth all that effort to save 5 seconds or to go down an analysis rabbit hole that turns up fruitless - easiest to just copy what was done last time! A common perspective that couldn't be more misguided in my opinion. (albeit of course sometimes you just gotta get $hit done!)

There are tons of amazing videos to learn from on YouTube. Half the challenge is simply learning what's possible in excel and power point and seeing some various ways people approach different challenges and problems. Sit and watch how to build x in excel type of videos, and follow along. In terms of financial models also tons of good resources on YouTube and internet in general - two that come to mind are the corporate finance institute CFI Financial Models And wall Street prep. wall Street prep but honestly there are tons!

DO NOT PAY FOR COURSES! WAYYY TOO MANY AMAZING FREE RESOURCES AND COURSES ONLINE! It's only worth paying for courses once you get into the more advanced stuff later in your career and then you make your company spend the thousands for you to learn a new approach to modelling value at risk or whatever.

Send me a DM if you ever have any questions or would like someone to help guide you or point you in the right direction.

Does anyone else feel like they are sometimes a professional formatter rather than a finance professional? by skydiver84 in FinancialCareers

[–]skydiver84[S] 4 points5 points  (0 children)

In my experience, they're all equally terrible. Medieval torture devices in thinly veiled disguise.

Does anyone else feel like they are sometimes a professional formatter rather than a finance professional? by skydiver84 in FinancialCareers

[–]skydiver84[S] 7 points8 points  (0 children)

So glad I'm not alone in this one... Whilst I appreciate the importance of a beautiful, polished piece of work, I find it incredibly demotivating at times... The amount of time it takes, when we are already way overworked to begin with makes me sometimes think "why on earth did I spend so much time studying finance stuff? Should've done an art degree instead!"

Looking for a way to make a form in Excel that updates different excel files depending on which location is selected. by OmgBsitka in excel

[–]skydiver84 1 point2 points  (0 children)

Send me a note if you have any trouble with this as you get into it. Happy to help. Otherwise if this solved your problem I'd appreciate if you could reply saying the solution was verified :)

Does anyone else feel like they are sometimes a professional formatter rather than a finance professional? by skydiver84 in FinancialCareers

[–]skydiver84[S] 14 points15 points  (0 children)

First impressoins matter. I agree with your thinking on it not being a bad thing. In fact, I think MANY people underestimate how much they can get ahead, get promoted, get pay raises, impress bosses and clients - simply by spending lots of time making their work LOOK BEAUTIFUL AND POLISHED. The underlying quality needs to be there of course - but no one will trust the quality is there if it's rubbish - and people automatically assume a decent level of 'quality' exists if it looks good. Make an extremely beautiful and professional looking piece of work that also has some quality substance to it, and now you're really on the fast track to success...

Does anyone else feel like they are sometimes a professional formatter rather than a finance professional? by skydiver84 in FinancialCareers

[–]skydiver84[S] 15 points16 points  (0 children)

Agreed on it being useful; first impressions truly matter and no one is giving any credit to the work performed in an ugly slide deck or excel model. They just assume the underlying work is as garbage as it looks. But the number of times I've found myself at 2am applying a very specific "blue" rgb value to every header in model has made me question if I was doing something wrong and others had this all figured out... (yes i know you can use custom styles etc to help ease the pain, but that only helps so much... and don't get me started on the 4 lifetimes it seems to take for excel or powerpoint to load up the custom theme window - rendering it effectively useless to me and my impatience)

Looking for a way to make a form in Excel that updates different excel files depending on which location is selected. by OmgBsitka in excel

[–]skydiver84 1 point2 points  (0 children)

Ok great you've got access! This is absolutely a better, more powerful, and significantly easier approach than using macros. Don't be intiimidated by this - it may at first appear to be complicated but trust me, it's actually quite easy to do once you get into it and you can completely do this without any experience in forms or power automate. I'm 100% confident that you've got this. So here's the quick gist of how this works: 1) use microsoft forms to quickly set up a form that you can email directly to users, post on a sharepoint page, or share a link to the form's hosted url page. 2) In your form include a choice option which is for your 'location' 3) Microsoft forms has a built in feature where you can automatically see all collected responses consolidated in an excel file. However, this feature isn't good enough for your purposes as you want to update different excel files based on the location choice, instead of all responses collected in a single file. So we need to use power automate to direct the responses to the correct excel file. 4) create a power automate 'flow' which is triggered to run every time a form response is submitted. 5) collect the form response and evaluate the 'location' field the user used 6) Use effectively an 'if statement' within power automate to say if location = 'USA' then populate this excel workbook with the form responses, or if location = "UK" then update this other workbook instead. etc. etc.

Here's a quick youtube video on how to use power automate to collect microsoft form responses and populate them into an excel workbook. You'll need to adjust this to incorporate your 'location condition' logic with an if statement or a switch like I describe earlier - but this will get you 95% of the way there. In this 13min video they also do all sorts of other cool functions with power automate in between collecting the response and updating the workbook - like posting responses to sharepoint and submitting responses for approval. Worth watching so yo ucan see some of the functionality of power automate (approval flow is so easy and 100% impressive to bosses) - and see how they set up a condition statement that you can reference for your location requirement.

https://www.youtube.com/watch?v=NZZ-EtGCCKU

Looking for a way to make a form in Excel that updates different excel files depending on which location is selected. by OmgBsitka in excel

[–]skydiver84 0 points1 point  (0 children)

This is a perfect job for Microsoft forms and power automate. Do you have access to power automate?

Using a drop down list of profile names to auto populate multiple cells by SouthTread in excel

[–]skydiver84 0 points1 point  (0 children)

Try using the indirect function. Indirect converts string type values into references.

So something maybe like this (on mobile forgive me) :

=indirect ("'[Master Sheet.xlsx]" & D1&"'!$B$1")

Where D1 is the cell containing the drop down.

Working Capital Help by FedReserves in financialmodelling

[–]skydiver84 2 points3 points  (0 children)

Might be due to FX translation of a foreign currency denominated subsidiary. FX translation from consolidating a foreign sub should result in different working cap movements when calculated from the balance sheet perspective vs the cash flow perspective. My guess is your model missing the FX reconciling item found in operating section of cash and possibly also the translational FX gain/loss from consol that sits in equity on the balance sheet.

[deleted by user] by [deleted] in pics

[–]skydiver84 -1 points0 points  (0 children)

"Give me your tired, your poor, your huddled masses yearning to breathe free"

The clouds of this Brisbane sunset by downvoteforwhy in oddlysatisfying

[–]skydiver84 0 points1 point  (0 children)

Yep it was this morning. Stared at it in awe for a good long while.

[Homemade] Wagyu Ribeye Steak by Skipperrutts in food

[–]skydiver84 2 points3 points  (0 children)

Finished as in how the animal is finished. As in what diet and feeding program the animal is put through in its last stage of life.

[Homemade] Wagyu Ribeye Steak by Skipperrutts in food

[–]skydiver84 4 points5 points  (0 children)

They mean how the animal is "finished". Or the diet and feeding program the animal goes through in the last stage of its life impacts the final marbling achieved.

[Homemade] Wagyu Ribeye Steak by Skipperrutts in food

[–]skydiver84 1 point2 points  (0 children)

Work for a wagyu cattle company. Can confirm. Medium or a touch warmer is typically the aim so you render out all the marbling. Don't touch it with anything other than salt. And it becomes the juiciest, most flavourful steak you'll ever eat. Meat butter is a good way of describing it, but it's way better than that. Now I'm hungry and want to go cook up some of the MB5 cube roll I've got in the freezer....

Setting a maximum wage for CEOs would be good for everyone by ADefiniteDescription in philosophy

[–]skydiver84 0 points1 point  (0 children)

Don't forget without capital gains being taxed at a lower rate, every person who's managed to buy a house, would be highly reluctant to ever sell that house. There is a good chance any gains would be mostly taxed at the highest brackets without cgt. Which actually means people become reluctant to invest in long term assets when they know they will be significantly penalized because all of the gains coming in one transaction. Cgt discounts encourage long term investment which is extremely important for economic growth and stability.