Showing results:
Displaying 1 - 35 of 35
VBA Code
What do you guys use VBA code for? Now that ChatGPT can handhold you on VBA code writing, wondering ways to use it. A lot of the brain damage that made VBA generally not worth it is now gone.
Using VBA as a Fixed Income Sell Side Trader
Do any sell side traders use VBA a bunch to make their job more efficient? Interested in hearing how you use it and how you learned it.
Infra Fund VBA test?
Have an upcoming VBA test with a separate case study for an infra fund. Anyone has any idea what to expect/likely scope on the VBA test? Never came across something like this, thanks
VBA advice Intern
Hi all, I am currently doing my MSc in Financial Mathematics at LSE and yesterday started a 1-month part-time internship in Quantifi (risk, analytics, and trading solution provider), at London office. The tasks I have to complete throughout my internship are mostly based on VBA programming and Excel...
VBA programming - Quant career Advice
Hi all, I am currently doing my MSc in Financial Mathematics at LSE and yesterday started a 1-month part-time internship in Quantifi (risk, analytics, and trading solution provider), at London office. The tasks I have to complete throughout my internship are mostly based on VBA programming and Excel...
Quant Role Interview at ~$10B AUM Fund
I may have the opportunity to interview for a quant role coming up somewhat soon. The position calls for knowledge of VBA specifically, but notes that programming languages like Python, Java, etc. would be ideal. I have academic research focused experience in VBA but nothing professional as my...
Pulling Data from Morningstar w/ VBA - Also the Defense Sector...
Hi, I was wondering if anyone is familiar with pulling data from Morningstar via VBA in excel. I'm trying to create a rugged comps model without the use of a Bloomybergy and was wondering if anyone had any insight... Secondly, XAR up 20% YTD. Who else likes defense names this year?? I feel like they...
do i need to learn VBA/Python/SAS
my bachelor degree is in Interntaional Economics and Trade. i will go for a management master degree. Should i prepare CFA now or learn VBA/SAS/Python if i want to get the job doingindustry research in a security company or FA company and finally become a fund manager?
Project Finance Model
Hey, Does anybody have a good Project finance model they could share? Preferably one with a DSCR debt sizing VBA script in there. Thanks.
VBA/Macros
Hi Gang, So I'm trying to learn VBA for excel. While I hear it is not really THAT complicated I am having a hard time trying to find examples of how VBA in excel would simplify certain excel processes. If anyone uses VBA or Macros what do you use them for in a acquisition model or debt or equity...
Learning some basic coding on your own?
I have been quite interested in learning some coding on my own, specifically thinking about VBA to further enhance my excel skills. Although I do not necessarily need to know programming in my job, I thought knowing VBA might give me more ideas as to how certain processes can be improved. Also, I...
Urgent: need help with VBA
I have a list of about 5000 investors and need to create a new sheet with the names, contact info and description of the investors who have the keyword 'debt' in their description. How would I go about doing this?
Is there a free source of fundamentals that I can extract from with excel?
I'm trying to create a stock screener; but I am building it from scratch, and it requires a lot of fundamental data. Does anyone know where/how I can extract specific line items off a companies financials without factset/bloomberg/etc? So far the only thing I can think of is extracting all the data...
Is VBA useful for Consulting Career?
Hello guys. I've secured an internship at Roland Berger for the next year, and I'll have some free time next semester to develop some useful skill. Is VBA a good thing to learn? I'm looking for something that can make my life in consulting easier, accelerating my career. I already know intermediate...
WACC function in VBA
.....
VBA question
working on a project using VBA I need to create a function, but i need my variables to refer to individual cells on separate spreadsheets. say for instance i want something like answer= cell c6* cell f3 How do i name those variables?? thanks
Pershing Square's "Open Source Model"
Just finished reading Confidence Game by Christine Richard. Over the course of the book she mentions a CDO valuation spreadsheet called the "Open Source Model" that was released to the public. It has over 600 tabs and was used to value MBIA's CDOs. Google reveals that the link Pershing Square posted...
Learning VBA for Banking
I'm considering using part of the summer before b-school to learn VBA. Anyone have any experience with using VBA in banking? Is it useful at all? It's a skill I've always wanted to have and will probably plunk down the time if it is remotely relevant to my future career ambitions.
Sharing a VBA Autofill Macro I Made
So I've been working on my VBA skills and wrote a macro for autofilling (clicking the black box on the bottom right of a selected cell), because it always annoyed me that I could never find a way to efficiently do this without using the mouse. In the spirit of collaboration, I'd like to share it...
Learning VBA in 2 weeks.
How to Learn VBA programming Just get your hands dirty and do it. As long as you know how coding works, it should be easy. Make some simply exercises for yourself. Start off by recording marcos of what you are doing and seeing what the code looks like. Then learn logical operators (if then else etc)...
VBA for Excel, Useful or a waste of my time?
Hey boys, I am a senior at a non-target and I just received an offer from a well-known middle market. Very excited about the offer. Now my focus is standing out amongst my analyst class. In school I took a CS class which taught me some basic VBA for excel. I am wondering if you guys think it would...
Visual Basic; useful for an analyst?
This is my first post so forgive me for my sins! As part of my degree programme, I've the option to take an elective in Visual Basic. I'm aware that programming skills are particularly useful in analyst roles within IB and S&T . However, with so many programming languages in use, how relevant is VB...
Cholesky Decomposition in Vba help
Hey guys, Has anyone done a Cholesky/ variance decomposition before? I am currently doing a project- the idea is to find out the correlation between different stock markets, incorporating directionality. I know how to get the correlation like through normal regression methods, but am clueless about...
VBA Training
Any recommendations for good VBA/Programming training in New York, with a focus on trading based applications? Working as a commodity trader and want to upgrade my skills for modeling etc. Thanks!
how to do this in VBA??? plz help
So here is the set up of my worksheet Name of Stock Long Inventory Short Inventory Apple 0 50 Apple 30 0 Google 10 0 Google 40 0 Google 20 0 . .
Excel, VBA practice projects
I've been learning some excel 2007, vba, and powerpont. The problem is that i'm learning primarily from books, and I need things to apply my new skilsl to for them to really stick. I'm already working on optimizing all of the spreadsheets I use in my everyday life. Anyone have ideas for clever...
HOW TO WRITE THIS TASK IN A RESUME
Okay so I wrote two VBA programs that cut the process time from about 10 minutes to less than 2 minutes (well more like less than 1 minute)... But how do I write this (quantitatively) on my resume and not risk sounding douchey- I mean you wouldn't say I cut down the original process time by 500%...
Self study VBA
Any good sources to bring up my proficient quickly. My intern boss told me that there will be a programming aspect, specifically vba, and that I will be working heavily in creating client friendly financial models with macros. I have advanced modeling in finance with excel and vba by mary stauton...
Best VBA book for S&T
The best VBA book for first year S&T analyst to read?
Are we using excel 2007 yet?
Hey, Trying to get up to speed for my future work. I plan to learn some advanced excel stuff, including vba. I was just wondering if excel 2007 has been/ will be widely adopted by the bb banks, consulting firms, etc, or if it looks as if we're going to skip this generation of microsoft office....
Trading Support Analyst Excel VBA requirement
What kind a skill set in Excel and VBA is required for trading support analyst? Are there any functions in Excel that are heavily used? Also any methods in VBA that an analyst should be aware of?
Jane Street VBA and Excel
Hello, I will be going in for an in house interview with Jane Street Capital. My recruiter specifically told me I will be tested on my MS Excel and VBA skill set as they use of a lot Excel on the floor. To quote the exact words she said, "We will go to the trading floor where we will do something on...
Amateur VBA question - need help (urgent!)
So I wrote the macros for my model to run for various scenarios and the model runs fine. But now I need to add an if statement where if the toggle cell I gave the name "GoalSeeker" has "Yes" selected, I want the model to goalseek the growth rate instead of using the assigned growth rate (cell I...
to what extent is VBA used in S&T?
I read a few threads about how VBA is widely used by analysts in S&T , and was wondering to what extent it is used. I was learning VBA over the summer and am now more or less familiar with how to create sub procedures, functions etc and manipulate data in worksheets. I've also covered pretty much...
Good Computer Programs to Know?
For someone who is really interested in HF work, particularly on the credit side, what are good programming languages to know? I've been building up on VBA to improve my Excel skills, and a friend has recommended learning Python, but I wanted to hear thoughts from other people. And out of curiosity,...
or Want to Sign up with your social account?