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

Can you practice for leetcode without knowing how to code?

like

Is your compensation and performance reviewed automatically on a regular/annual basis? I don’t get either of these unless I ask for it! Found out others in our company experienced the same as me. Lowball Salaries trending as a common pain point

I like my team and work life balance, during the pandemic was very beneficial to my wellbeing. However feel I owe it to myself now, to be earning what I’m worth in the market (I’m underpaid by a fair bit) especially with inflation costs

like

Looking for advice on some resources or suggestions on how to start with programming for GPUs. I am 7 years into coding and I don’t know a thing about GPUs! I don’t know why this subject is not taught in schools.
Appreciate your support in helping me learn!

like

What is the rejection rate for canada wp this year?
I have been rejected for us visitors visa twice two years back.. so having doubts about canada wp.. would this cause any issues?

like

If we all make a fuss about returning to the office do you think the standard will change?

likesmart

Former big law associate here who burned out. Now a corporate inhouse counsel.

Been recovering and considering going back to actual legal practice.

I feel I need a new practice area.

One that impacts people’s lives and is meaningful, but where you don’t have to deal with disturbing facts and personal tragedies.

Any suggestions?

like

Odds Wolves pull off Europa?

So where does everyone think Messi is going? I’m guessing Man City

like

What are some boutique firms in London who specialize in the Retail industry? Have a friend with industry experience looking to move into consulting but big firm life would not be a fit for her. TIA!

like

How does PwCs reputation in the consulting market place compare to the other top firms (big 4, MBB, Boutiques, etc.)

like
like

Auto rebalance (every 90 days) or manually rebalance as needed? I'd rather be more passive but willing to do it myself to save money. Btw if anyone ACN knows rebalance cost structure, please share.

like

Has anyone taken up the Personal Capital investment management service that they offer?

They say they will manage my 401k but to do that they will require my credentials that I use to log into fidelity. Is that normal? Has anyone here done that before? Any feedback or experiences of using them?

like

Thoughts on SoFi bank?

like

Which Mckinsey office in the Middle East is hiring? Does Dubai office still hire experienced hire now?

like

How stressful is it to work in a call center? It seems to me that the supervisors would be the micromanaging sort

like

Deloitte is looking for qualified candidates to join their Cyber & Strategic Risk practice immediately. All levels. Please reach out if you're looking for a change and I'll submit your resume!

likefunny

Hello Sharks,

Can anyone please let me know the in hand monthly salary?

Post Photo
like

What would you consider a good % increase in salary to exit from public accounting?

like

Additional Posts in Investment Banking - IBD

When is external hire IBD recruiting season?

like

Anyone work for Wells Fargo Corporate and Investment Banking? Have upcoming interviews for two teams (industrials and healthcare) for corporate banking analyst positions and wanted to know what kind of questions to expect. Thanks!

like

What are bonuses like for a first year IB Analyst in London? (Think US banks like GS, MS, Citi etc.)

like

What “lifestyle” exit opportunities pay decently? Been interviewing for corporate development and strategic finance roles but total comp looks to be almost a 50% pay cut.

like

I am new in London. I have 4 years of M&A experience in the buy side. I have come across an opportunity to work with Rede Partners in London. But I am not aware of what exactly they do and what to expect going ahead. Can someone please guide if they are aware of Rede Partners?

like

Has anyone who lateraled for an experienced IB role gotten moving expenses reimbursed? If so, how much was it? Thanks

like

What’s the best VDR and why is it datasite?

like

Thoughts on GP Bullhound?

Is 36 too late to join IB as an associate? Alternatively, can stay in my industry (not banking) as manager.

like

I am offered PL-08 position in RBC
Canada. Can somebody please
guide me on the pay band for this
position (so I can negotiate if they
are offering low in the range)? They
are offering 87k base + $10.5k
bonus. Thank you!!

Also, does PL-08 equates to
Manager level in RBC?

like

Difference in A1 stub bonus when joining in March vs. summer as usual? I’m joining early, but still part of the 2022 Class.

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

Anyone analyze QoEs before? Need to come up with questions for due diligence call and looking for some guidance

like

Does Barclays UK help it's employees who are interested in getting financial/ accounting certifications?Barclays

like

Is breaking into equity research/coverage teams as hard as breaking into traditional advisory/M&A IB being from a non target school with a non finance degree?

like

Any staple brands for a first year analyst’s wardrobe?

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

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

Economy is shrinking folks - just got my IBD interview cancelled due to hiring needs “changing”… I will continue to prepare and be ready for the next opportunity.

like

Anyone know of any banking analyst lateral opportunities in Chicago? Looking to jump to BB/EB. Any insight to the shops around here is much appreciated!

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