I'm working on analyzing historical trends in a basket of 200+ stocks as if they were a real ETF (so: quarterly rebalancing, inclusion bands around a market cap cutoff, etc). The Excel math is getting a little unwieldy and this is not something my firm has built off the shelf that I can just utilize.

Any online tools/platforms out there that allow me to do this?

like
Posting as :
works at
You are currently posting as works at

I think python can help. It sounds like you want a strategic approach to the analysis Python can do all those things but require a bit of programming skill if you are willing to learn for a week.

like

I feared this day might come lol, but I've been avoiding it for too long so may as well get it over with....thanks for the tip!

Related Posts

I have an Amazon Hiring Manager phone interview Tuesday. Can I use my phone instead of my computer? I’m just worried because it looks like there’s no video with through the phone app. Is this okay or will the HM expect to see me on video?

like

How do you approach a stinky middle school kid or their parents with hygiene suggestions? I don’t know how to politely tell anyone that they smell bad.

like

Is applying a few days before the “Apply by” date too late? Do most decisions get made early on/they don’t wait for all applications before interviewing/hiring?

like

BDO recruiter reached out for an audit senior position in the DC area. Recommended or not? And why? Insights appreciated!!

likefunny

How is Client interview conducted in persistent systems

like

What’s a gal got to do to get an interview with Droga5? Any CDs in here willing to check out my book?

like

I’m 26 and have ~40k sitting in my savings account. Annual income 140k. Maxing out 401k. No debt. Planning to invest 25k but don’t know where to start. Should I get a wealth manager? What is the best way to approach this?

like

Where can we check legitimate cutoff for Canada express entry PR?
How often do the results come out? is it every month?
After submitting your profile in how many days can one expect to get Invitation?

Just finished the movie Senna. So damn good. RIP Aryton

like

Not happy working for current team as don’t see personal growth. Switching to a different project will affect growth and promotion cycle - is this the indication to quit and try outside ?

like

Now that Facebook is Meta, I thought I’d just pitch MANGA as the new FAANG…

like

I’ve been offered a reporting consultant job for less than 60k and I bring 9+ years of experience to the role. They should be offering more. I don’t want to settle but I don’t want to miss an opportunity to move. Reporting consultants should start at $65k per recruiting sites. Any advice? How can I get HR/recruiters to offer more? TIA

like

Anyone knows how is Emirates NMD client in Synechron, And do we need to give client interview after joining?

Looking for a one month sublease in dc!

I need to rent a car and drive from NY to PA. Any Cody effective recommendations?

like

Hi guys, i have a current CTC of fixed 30L and I got a variable ~8L (32%). I heard that Bofa doesn't give bonus so what is the ideal one can quote the HR and should look reasonable?
PS - I heard that Bofa gives an average hike of 10% whereas in consulting I have always received hike > 20 or above.
Given this and markets I was hoping for ~50L (considering 30+8)? Any suggestions. Also they are in an urgent requirement for the role to be filled. I need suggestions on this number. Thanks in advance

Anyone know any recruiters at USAA? Trying to apply for jobs there but getting no luck

like

Is genetic carrier screening prior to starting an ivf cycle necessary? I tested and found some disorders. Now my RE won’t start my cycle until my partner is tested. They are saying they will have to do special PGT tests if we are carriers of the same disorder. I am confused. I thought this type of testing was optional and usually recommended if you are using a donor. My guess is that they are booked and pushing me to the Jan cycle. Thoughts?

like

Husband and I have been trying to conceive for a little over a year with no luck. All of our testing came back normal except his morphology was at 6%. RE is recommending IUI as next step with letrozole (and also looking like progesterone and ovulation trigger shot from the paperwork) I’m scared of the drugs and potential effect on my hormones, body, and future cycles. Can anyone please share their experience with these drugs and any side effects? Should we maybe start with natural IUI first?

like

2021 FREELANCE RATE THREAD. Let’s share to see how 2021 budgets seem to be. I’ll start, Associate design director, $1200/day

like

Additional Posts in Investment Banking - IBD

Weighing whether another year of IB experience would be helpful, or would just make me one year older at the same starting point in PE.
I’m 1.5 years out of college as an analyst at a middle market bank within the healthcare M&A group. Getting worked a lot but starting to operate as an associate on deals. Debating accepting an offer for a newer, lower-MM healthcare and growth focused PE firm. I know I want to go to PE at some point, but what are some thoughts on when you should go?

like

Public finance exit opps?

Asking for wife who's also in banking. If she got ~$100k in signing bonus in 2019 for 1 year commitment in CA and started FT in July 2020, assuming she leaves before July 2021, can her employer claw back full amount in California? Some say it's much tougher to do so under CA law but wonder if anyone has any insights. Banks won't likely care about analyst signing bonuses, but associate bonus at EB with diversity bonus can be significant. If she quits before, she won't be going to another bank.

like

I am going to speak with a recruiter at Houlihan Lokey TMT in LA. I would like to know more about the group and its culture. Would love to connect and network🙏

like

Received an offer for equity research and IB, both in toronto. ER paying $120k base and my understanding is that bonus can be around 25-30%. IB is paying $105k base but likely higher bonus? Which one would u choose if you think you would be good at both

like

I just graduated from a nontarget in Dec 2020 & am currently interning at PwC before I go back to do my Masters. My initial plan was to accept my full time offer and slowly work my way into IB.

I see postings right now for FT IB analyst programs. Should I even try applying online?

Ik recruiters don’t really read cover letters, but I learned about banking rlly late into college. i’m the daughter of blue collar workers who don’t speak English so I never really knew what jobs were “prestigious”

like

Equity research associate considering to pivot into IBD. Is this a wise choice? Heard ER is an exit for some of the IB folks out there.

like

currently debating if i should work on the hill or accept an IB role. i feel like working on the hill is invaluable experience that could get me into IB but maybe i’m wrong? Which opportunity gives me best resume experience?

like

How many times do you think about quitting per day?

like

Does anyone know about Sage Group? Seems to be a boutique firm but not sure about their culture and overall dealflow in the market.

like

What does the branch transfer process look like for UBS? I'm wanting to transfer from my current office to one closer to home.

Looks like some bonus numbers are coming out for bankers, would appreciate any insights!

like

Thoughts on analyst to associate promote in IB?

like

Thoughts on GP Bullhound?

Have technical interview (pen and paper only) coming up with a BB, can anyone offer advice/resources/suggested way to practice?

like

What are some great investment banks to work as an associate in the Washington DC area?

like

What credit cards does everyone use to maximize rewards points? What bank accounts to maximize sign up bonuses?

like

Does anyone know Barclays Ib summer bonus cycle month?? Thanks in advance

like

Hi All,
I have been invited to a networking event for a BB IB. I was wondering if anyone can help me out what is generally expected out of the participants? Shall I carry my resume or just get to know the people. Thank you 🙏

likehelpful

Any recommendations on brushing up on PowerPoint?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal