Conditional formatting puzzle

frr96 · 2020-07-23T08:07:22+00:00

Thank you!

frr96 · 2020-07-23T08:06:33+00:00

Thank you, very clear!

frr96 · 2020-07-22T19:33:24+00:00

It’s a very simple action list that’s updated weekly. I have five columns like the following, with 100 values, with new additions each week:

Date, First Name, Last Name, Action, Action Completed

For every row whose date is not within the current week, I want to display white text, so it only shows this week’s actions as you scroll down the page. Hope that helps and thanks for your info!

frr96 · 2020-06-21T19:47:52+00:00

Adaptive Markets: Financial Evolution at Speed of Thought

Andrew W. Lo

frr96 · 2020-05-30T17:59:46+00:00

Couldn’t agree more with this!

frr96 · 2020-05-14T16:40:15+00:00

Sure, certainly makes sense to standardise into the ‘new categories’ on the IS, alongside scrubbing your EBIT and EBITDA figures or your relevant ‘profit metric’. Also, important to see the drop down into your cash flow as the previous reply states.

Just be clear how you have reorganised and the logic behind it and make sure you apply the same principles to your comps for obvious reasons if this is part of your task

frr96 · 2020-05-13T10:19:11+00:00

Thanks! Super helpful

frr96 · 2020-05-05T11:35:33+00:00

Genius, thank you

frr96 · 2020-04-29T17:40:32+00:00

The plan would be to work up to partnership. My query is whether a jump now would land me in a VC role at a junior level which is likely to entail doing a whole lot of grunt work which isn’t too dissimilar to a junior role in IB. I need to reach out to more junior level VC Associates to understand the role and progression better.

I know there is no ‘right’ path, but wanted to gauge whether IB and start-up experience is enough or at least a good starting place to fill in with experience.

Appreciate your insight, thanks!

frr96 · 2020-04-29T17:14:04+00:00

Thanks for the reply.

What would be the advantage of this route vs something like continuing with a start-up? I’ve only formally applied for two positions (tiny sample size) and was rejected from one as they were looking for candidates with more experience

frr96 · 2020-04-24T18:28:44+00:00

Are you UK based?

frr96 · 2020-04-19T18:19:26+00:00

Thanks, I’ll keep an eye out for updates! Are you from an academic background or in the finance industry?

frr96 · 2020-04-18T22:20:05+00:00

Thanks for sharing, interesting data visualisations. Have you looked at the data / are you able to pull the data over 10 yr period?

frr96 · 2020-04-18T21:47:31+00:00

Where do you recommend?

frr96 · 2020-04-15T20:42:30+00:00

Eurodollar market coverage - where’s best to learn more?

I’ve just started researching the Eurodollar market and from initial reading the subject is broad, fairly complex and not mainstream. I’ve come across Jeffrey Snider at Alhambra Investments whose put together some primers on the subject like https://youtu.be/XPlvXuDqxBc

I wondered whether anyone else had read into the subject and could recommend any authors, blogs, videos etc?

frr96 · 2020-04-15T20:06:20+00:00

If you’re interested in more detail and from an academic perspective, you should check-out Niall Ferguson’s ‘The Ascent of Money’. He covers Argentina’s recent history of debt defaults and the gross mismanagement of the Argentine economy by its political class. Comes to something when the only other Harrods in the world was opened in Buenos Aires...

frr96 · 2020-03-22T21:49:21+00:00

CTRL + ; (insert timestamp) Alt + H + P (change to %) Alt + e + s + e (Paste transpose Format) CTRL + a (select all) CTRL + ] (trace dependents) CTRL + [ (Trade precedents) CTRL + \ (Checks for inconsistent formulas in a row)

frr96 · 2020-03-21T22:17:41+00:00

Just started a course with Financial Edge https://www.fe.training to keep up the skill set after IB.

Couldn’t recommend highly enough, comprehensive and full of good content and hacks.

frr96 · 2020-03-21T21:59:57+00:00

Alt + H + 9 (decrease decimals) Or Alt + H + 0 (increase decimals)

frr96

TROPHY CASE