Use ChatGPT INSIDE Excel | Retrieve Any Data With OpenAI's API

Ryan O'Connell, CFA, FRM shows how to use ChatGPT INSIDE Excel using OpenAI's API. Bring ChatGPT directly inside Excel and retrieve any data with OpenAI's API.

👨‍💼 My Freelance Financial Modeling Services:

CHAPTERS:
0:00 - Intro
0:29 - Download the Free File
1:02 - Get API Key From OpenAI
1:50 - Import Office Script Code
2:48 - Retrieve An Excel Formula With ChatGPT
3:39 - Retrieve a List In Excel With ChatGPT
4:06 - Review of the Code
6:14 - Retrieve Any Data Set In Excel
9:39 - Conclusion On ChatGPT Bot In Excel

*Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC

Alternative Titles:
How to Use ChatGPT's API Inside Excel and Retrieve Any Data Set
How to Get a OPENAI API Key and Use It for Excel
Use ChatGPT In Excel
Use chatgpt inside excel
Create a ChatGPT Bot INSIDE Excel | Retrieve Any Data

[RyanOConnellCFA]

👨‍💼 My Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs:

[christopherfrantz]

Just discovered your channel...fantastic stuff -- thank you!

[jacobpatterson]

Really interesting stuff! Thanks for the video, Ryan.

[benweisman]

Hey Ryan, great video. When changing the Output Sheet Name to Output Data and putting my own set of data into that tab, it doesn't appear to return anything when i try and use the prompt. Any ideas?

[lorenzopinardi]

Hi Ryan, that sounds exactly what I was looking for... but when I executed the code I received an error (Line 61: Cannot read properties of undefined (reading '0')). don't know the language and cannot debug it... could you possibly help?

[males_social]

there is a error: Line 61: Cannot read properties of undefined (reading '0')
does it work with gpt4 ?