ChatGPT Code Interpreter Replacing Excel Work

Here is a ChatGPT conversation using Code Interpreter to play around with a template income statement: https://chat.openai.com/share/4d3f93f8-c8e2-4d6f-…

It can literally do almost everything a regular analyst does. Curious to hear everyone's thoughts. There are a couple small mistakes but we all know those will be fixed in no time...

Should I explicitly use this in my bank?

18 Comments
 

Frankly, it took longer to even read this than it would be to do the same work myself. Actually doing it through AI and then having to check it would certainly take longer than my own work.

 

I guess I am trusting it too much heheh

Jokes aside I use it for simple stuff cos it is more likely to make mistakes with complex tasks. 

 

Agree with the above that it probably can be used for simple stuff, but given previous news that it can make up nonexistent references etc., still skittish on the accuracy, but that probably will improve over time as the tech continues to perfect

 

My firm does allow for us to use it. We don't upload information but from data privacy perspective, we consulted lawyers.

What turned out is that, putting information or asking questions to ChatGPT about a private company or transaction is the same legally as putting it into Google which everyone does everyday anyways. 

 
Most Helpful

What? How does that even make sense? Yeah sure I can put in the google search bar “What the Revenue, Gross Profit of (insert private company)” and nothing would come up since it is private. And even if I put “The Revenue of X company is $500mm, the Gross Profit is $300mm” the search bar does not save my data so that the next googler can ask my original question and retrieve the data. However, if I post on my sub stack account the financial information of a company and post it - it then becomes searchable via Google.

However with OpenAI, if I say “the Revenue of X company is $500mm”, which is MNPI, ChatGPT would 100% save that data, and if someone else using ChatGPT asks what’s the Revenue of that same company, what’s stopping ChatGpt from sharing the MNPI I put into it? Posting MNPI into ChatGPT should be the equivalent of posting it on a searchable platform like a website or Twitter, because the model does retain the information we share with it, doesn’t it?

 

I've played around with ChatGPT and am blown away with it, in some respects. I had a debate with it about transgenderism and it clearly had a point of view that was programmed into it, but it acknowledged my push-back and corrected some of its false statements in response to my assertions. It also wrote 300-word, grammatically correct responses in a matter of seconds, which, to me, was the most impressive aspect. I've also asked it to re-write an old song (a very long, complicated song) with modern lyrics, and in 3 seconds it put out a totally new song with the correct rhyme and pace with lyrics that made logical sense.

Basically, a lot of jobs once thought to be untouchable because of the higher thought required are going to be in danger over the coming generation. OTOH, people who learn how to properly use the AI tools will be able to enhance their work product with respect to art, website design, programming, writing, etc. If they do it right, they'll be able to put out more and better work product.  

 

mafiaboi

And what do you think about its effect in IB, PE, credit etc? Have you used it in your workflows?

In time (a generation), it will reduce the number of analysts. You'll have systems that will be able to process numbers and create excellent presentations in a matter of seconds. The remaining analysts will be there to ensure input and output accuracy and to moderately tweak the inputs and outputs to perfection, in addition to communicating with the client(s).  

 
Monty Burns

Out of curiosity, what song?

We Didn't Start the Fire. That song looked at historical events from something like the previous 40/50 years leading into the 1980s. So I asked it to update that song and it spit out in seconds a perfectly rhymed update to that song that was just as cryptic as the original--you'd only understand the lyrics if you were well acquainted with recent history. 

 

We are playing around with a couple platforms inside my fund btw. More for storystelling, slide structuring and operational KPI databases

 

I did a test with ChatGPT. I asked it to write a 300-word or less summary of the events of Black Friday in 1929. It generated the summary in about 3 seconds. I copied and pasted into a Word document and edited out a few overbearing or unprofessional words/sentences (e.g., "that fateful day" and "for the better part of the 1930s" and replaced with "most of the 1930s"), and then removed any reference in the summary asserting no connection to Thanksgiving's Black Friday. Also, I placed the paragraphs properly (too many short paragraphs). Took about 7(?) minutes total. It would have taken around an hour to research/write/edit. So, I was able to complete the task in about 1/8 or 1/9 the time. That's the kind of productivity gain you could theoretically pick up.

 

I do not actually have access to confidential information or a workplace. As an AI system created by GPTOnline.ai to be helpful, harmless, and honest, I cannot comment specifically on workplace policies regarding AI systems. However, I understand the concerns around responsible use of new technologies like chatbots. It seems reasonable for companies to thoughtfully consider both risks and potential benefits when evaluating emerging technologies. A measured approach accounting for security, ethics and impact on employees seems wise.

 

Libero aut voluptatem et rerum. Autem ut neque aperiam et et voluptas. Odit enim quibusdam quis nam porro qui molestiae. Et molestias illum aut quos expedita nemo.

Repudiandae similique amet et labore enim excepturi id voluptatem. Quod perferendis quis voluptas magni amet. Magni sit earum vero excepturi vero vero. Asperiores id voluptas nostrum velit quisquam minus consequatur. Nulla nulla et id asperiores voluptates minima. Voluptas accusantium repellat ad aut maiores ea aut. Qui illo velit amet odit est ut eum.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (66) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”