top of page
Writer's pictureAmar Harolikar

Mutual Fund Allocation Analysis with GPT Power Tools. Custom GPT. Custom Python Code. Multiple Excels.

Updated: Apr 9, 2024

Live use case of having ๐˜ต๐˜ฉ๐˜ฆ ๐˜Ž๐˜—๐˜› ๐˜ถ๐˜ด๐˜ฆ ๐˜ข custom code ๐˜ต๐˜ฉ๐˜ข๐˜ต ๐˜ฆ๐˜ฏ๐˜ด๐˜ถ๐˜ณ๐˜ฆ๐˜ด ๐˜ค๐˜ฐ๐˜ฏ๐˜ด๐˜ช๐˜ด๐˜ต๐˜ฆ๐˜ฏ๐˜ต ๐˜ฑ๐˜ฆ๐˜ณ๐˜ง๐˜ฐ๐˜ณ๐˜ฎ๐˜ข๐˜ฏ๐˜ค๐˜ฆ, ๐˜ณ๐˜ข๐˜ต๐˜ฉ๐˜ฆ๐˜ณ ๐˜ต๐˜ฉ๐˜ข๐˜ฏ ๐˜ณ๐˜ฆ๐˜ญ๐˜บ๐˜ช๐˜ฏ๐˜จ ๐˜ฐ๐˜ฏ ๐˜ช๐˜ต'๐˜ด ๐˜ข๐˜ฅ๐˜ฉ๐˜ฐ๐˜ค ๐˜ฅ๐˜ช๐˜ง๐˜ง๐˜ฆ๐˜ณ๐˜ฆ๐˜ฏ๐˜ต ๐˜ข๐˜ฑ๐˜ฑ๐˜ณ๐˜ฐ๐˜ข๐˜ค๐˜ฉ ๐˜ฆ๐˜ข๐˜ค๐˜ฉ ๐˜ต๐˜ช๐˜ฎ๐˜ฆ. ๐˜ผ ๐™‚๐™‹๐™ ๐™‹๐™ค๐™ฌ๐™š๐™ง ๐™๐™ค๐™ค๐™ก.






In my previous videos and posts, I have shown how to use ๐—š๐—ฃ๐—ง ๐—ฃ๐—น๐˜‚๐˜€ ๐˜๐—ผ ๐—ฟ๐˜‚๐—ป ๐—บ๐—ฎ๐—ฐ๐—ต๐—ถ๐—ป๐—ฒ ๐—น๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด (https://rb.gy/o39bvm), ๐—Ÿ๐—น๐—ฎ๐—บ๐—ฎ๐—ฃ๐—ฎ๐—ฟ๐˜€๐—ฒ ๐—ฐ๐—ผ๐—บ๐—ฝ๐—น๐—ฒ๐˜… ๐—ฃ๐——๐—™๐˜€ to analyze 10K / Annual Reportsย (deployed at ๐š‘๐š๐š๐š™๐šœ://๐š ๐š ๐š .๐š๐š’๐š๐šฃ๐š’๐š.๐šŒ๐š˜๐š–/). As well as a ๐—Ÿ๐—Ÿ๐—  ๐—”๐—ฝ๐—ฝ,ย ๐—ฌ๐—™๐—œ๐—ก ๐—•๐—ผ๐˜ that will pull multiple-year financials from Yahoo Finance, now ๐—น๐—ถ๐˜ƒ๐—ฒ on public internet (๐š‘๐š๐š๐š™๐šœ://๐š ๐š ๐š .๐š๐š’๐š๐šฃ๐š’๐š.๐šŒ๐š˜๐š–/๐šข๐š๐š’๐š—) as well as a custom GPT (https://rb.gy/fy8lkk)


๐˜ผ๐™ก๐™ก ๐™–๐™ฅ๐™ฅ๐™จ, ๐™ž๐™ฃ๐™˜๐™ก๐™ช๐™™๐™ž๐™ฃ๐™œ ๐™ฉ๐™๐™ž๐™จ ๐™ค๐™ฃ๐™š, ๐™›๐™ช๐™ก๐™ก๐™ฎ ๐™˜๐™ค๐™™๐™š๐™™ ๐™—๐™ฎ ๐˜พ๐™๐™–๐™ฉ๐™‚๐™‹๐™ / ๐™‚๐™š๐™ข๐™ž๐™ฃ๐™ž (๐˜ธ๐˜ฉ๐˜ฆ๐˜ณ๐˜ฆ๐˜ท๐˜ฆ๐˜ณ ๐˜ค๐˜ฐ๐˜ฅ๐˜ช๐˜ฏ๐˜จ ๐˜ช๐˜ด ๐˜ณ๐˜ฆ๐˜ฒ๐˜ถ๐˜ช๐˜ณ๐˜ฆ๐˜ฅ)


๐—–๐˜‚๐—ฟ๐—ฟ๐—ฒ๐—ป๐˜ ๐˜‚๐˜€๐—ฒ ๐—ฐ๐—ฎ๐˜€๐—ฒ: (a) track changes in equity holdings of a mutual fund over two or more time periods. (b) compare portfolio holdings of two or more different mutual funds. To be done repetitively. Can handle ๐˜‚๐—ฝ๐˜๐—ผ ๐Ÿญ๐Ÿฌ ๐—ฒ๐˜…๐—ฐ๐—ฒ๐—น ๐—ณ๐—ถ๐—น๐—ฒ๐˜€, ๐—ฒ๐—ฎ๐—ฐ๐—ต ๐—ถ๐—ป ๐—ฑ๐—ถ๐—ณ๐—ณ๐—ฒ๐—ฟ๐—ฒ๐—ป๐˜ ๐—ณ๐—ผ๐—ฟ๐—บ๐—ฎ๐˜ (GPT Plus limit)


๐—ฆ๐—ผ๐—น๐˜‚๐˜๐—ถ๐—ผ๐—ป: Custom GPT 'Mutual Funds Portfolio Analyzer' (https://rb.gy/nj51lf). Live now. Feel free to use. It has regular instructions along with a custom Python code generated by GPT itself, to serve as a guideline. I was getting inconsistent results with just prompts and instructions. ๐˜š๐˜ฐ ๐˜ฏ๐˜ฐ๐˜ธ ๐˜ ๐˜ข๐˜ฎ ๐˜ฉ๐˜ข๐˜ท๐˜ช๐˜ฏ๐˜จ ๐˜ต๐˜ฉ๐˜ฆ ๐˜Ž๐˜—๐˜› ๐˜ถ๐˜ด๐˜ฆ ๐˜ข ๐˜ค๐˜ฐ๐˜ฅ๐˜ช๐˜ฏ๐˜จ ๐˜ข๐˜ฑ๐˜ฑ๐˜ณ๐˜ฐ๐˜ข๐˜ค๐˜ฉ ๐˜ต๐˜ฉ๐˜ข๐˜ต ๐˜ฆ๐˜ฏ๐˜ด๐˜ถ๐˜ณ๐˜ฆ๐˜ด ๐˜ค๐˜ฐ๐˜ฏ๐˜ด๐˜ช๐˜ด๐˜ต๐˜ฆ๐˜ฏ๐˜ต ๐˜ฑ๐˜ฆ๐˜ณ๐˜ง๐˜ฐ๐˜ณ๐˜ฎ๐˜ข๐˜ฏ๐˜ค๐˜ฆ, ๐˜ณ๐˜ข๐˜ต๐˜ฉ๐˜ฆ๐˜ณ ๐˜ต๐˜ฉ๐˜ข๐˜ฏ ๐˜ณ๐˜ฆ๐˜ญ๐˜บ๐˜ช๐˜ฏ๐˜จ ๐˜ฐ๐˜ฏ ๐˜ช๐˜ต'๐˜ด ๐˜ข๐˜ฅ๐˜ฉ๐˜ฐ๐˜ค ๐˜ฅ๐˜ช๐˜ง๐˜ง๐˜ฆ๐˜ณ๐˜ฆ๐˜ฏ๐˜ต ๐˜ข๐˜ฑ๐˜ฑ๐˜ณ๐˜ฐ๐˜ข๐˜ค๐˜ฉ ๐˜ฆ๐˜ข๐˜ค๐˜ฉ ๐˜ต๐˜ช๐˜ฎ๐˜ฆ. ๐˜ผ ๐™‚๐™‹๐™ ๐™‹๐™ค๐™ฌ๐™š๐™ง ๐™๐™ค๐™ค๐™ก.


๐—›๐—ผ๐˜„ ๐˜๐—ผ ๐—จ๐˜€๐—ฒ: Upload the excels, share a few details and that's it. Have GPT analyze it or analyze offline, pushing the appended data into a Pivot Table. [See document for details]


๐—ช๐—ต๐—ฒ๐—ฟ๐—ฒ ๐—ฑ๐—ผ ๐—œ ๐—ด๐—ฒ๐˜ ๐˜๐—ต๐—ฒ ๐—ฝ๐—ผ๐—ฟ๐˜๐—ณ๐—ผ๐—น๐—ถ๐—ผ ๐—ฎ๐—น๐—น๐—ผ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—ณ๐—ถ๐—น๐—ฒ๐˜€ ? Available on MF websites. Have uploaded some at https://tigzig.com/files


๐—–๐—ฎ๐—ป ๐—œ ๐—ฟ๐—ฒ๐—ฝ๐—น๐—ถ๐—ฐ๐—ฎ๐˜๐—ฒ ๐˜๐—ต๐—ถ๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—บ๐˜† ๐—ฒ๐˜…๐—ฐ๐—ฒ๐—น ๐—ฝ๐—ฟ๐—ผ๐—ฐ๐—ฒ๐˜€๐˜€๐—ถ๐—ป๐—ด ๐˜‚๐˜€๐—ฒ ๐—ฐ๐—ฎ๐˜€๐—ฒ, ๐—ป๐—ผ๐˜๐—ต๐—ถ๐—ป๐—ด ๐˜๐—ผ ๐—ฑ๐—ผ ๐˜„๐—ถ๐˜๐—ต ๐—ฒ๐—พ๐˜‚๐—ถ๐˜๐—ถ๐—ฒ๐˜€? Yes. Just replicate the GPT and customize your instructions. Easy to do. No coding required. Only one piece of GPT auto generated code to be copy pasted during setup. (see document)


๐—–๐—ฎ๐—ป ๐—œ ๐—ฑ๐—ฒ๐—ฝ๐—น๐—ผ๐˜† ๐˜๐—ต๐—ถ๐˜€ ๐—ผ๐˜‚๐˜๐˜€๐—ถ๐—ฑ๐—ฒ ๐—ผ๐—ณ ๐—š๐—ฃ๐—ง ๐˜€๐˜๐—ผ๐—ฟ๐—ฒ, ๐—ผ๐—ป ๐—ฝ๐˜‚๐—ฏ๐—น๐—ถ๐—ฐ ๐—ถ๐—ป๐˜๐—ฒ๐—ฟ๐—ป๐—ฒ๐˜ ๐—ผ๐—ฟ ๐—บ๐˜† ๐—ฐ๐—ผ๐—ฟ๐—ฝ๐—ผ๐—ฟ๐—ฎ๐˜๐—ฒ ๐—ถ๐—ป๐˜๐—ฟ๐—ฎ๐—ป๐—ฒ๐˜ Yes, you can. See my YFIN bot for pulling multi-year financial statements from Yahoo Finance (https://rb.gy/ca2k5p). It's deployed inside GPT store as well as on the public internet and uses GPT 3.5. However for real-world use, anything requiring GPT4/Code Interpreter has significant cost considerations. Currently exploring lower cost custom build option. Watch this space for more.


95 views
bottom of page