Financ!al

Financial statements contain information critical to determining a company’s health. AI generated context makes information accessible, analyzing financial and economic contexts to explain trends.

Comment

Inspiration

One day after business class, we realized just how boring financial statements sounded in class (income, asset, and balance sheets were). Many would not think of looking at financial statements before investing in a company, due to the difficulty of comprehending what the statement means without prior knowledge, even though the statement could provide very crucial indicators for how a company is doing. Utilizing an AI agent would increase financial statement accessibility for a dataset that was meant to be accessible.

What it does

Our program contextualizes financial statements from time series bar graphs of financial statement data using AI upon cursor hover of a graph, it provides both micro (company & industry) and macroeconomic (Fed policy & global) contexts.

How we built it

SEC data pulled through financialmodelingprep transformed with pandas into graphs hosted on streamlit integrated Groq api (mixtral-8x7b-32768, "Mixtral of experts") to provide AI context on hover for graphs.

Challenges we ran into

One big challenge was getting a website with data up and running. Initially, we wanted to do SQL calls on a dolthub data and integrate it with a website built in reflex.dev, but we couldn't get the SQL calls to return any data at all. We spent a lot of time debugging but never got it to work which is why we switched to another API (financialmodelingprep) to call data, despite it having a shorter time series. The most challenging thing was probably figuring out how to get the AI to function. We have never done an AI API call before, so setting it up required countless hours of consulting GPT and the internet to discover the easiest way we could get it work with our site.

Accomplishments that we're proud of

We're proud that we got something within our initial vision and built something out with newbies 🔥 Here’s to many more projects!

What we learned

We learnt to type up the devpost locally because the page crashing literally wiped out our first iteration that we typed up. We also learnt that FUD regarding LLMs replacing programmers might just be what it is: FUD. We were basically three non-technicals and found it almost impossibly hard to create something like we envisioned with GPT. We thought we could prompt it with examples and specific contexts and it would build something extremely sleek, but most of the code it generated didn't run at all, so we had to watch youtube tutorials.

What's next for Financ!al

Switch dataset from financialmodelingprep to dolthub (larger range of data + free) and pull data using SQL. Better UI, improve visibility of graphs, customizability of layout. Improving AI model for narrower context and accuracy. Adding more customizability for graphs (line, bar, etc), incorporate a automatic sankey style diagram generation for income statements (which is cool to have), and make the AI generated text be less intrusive (move it to bottom left corner and have it disappear upon clicking outside the context window)

Not financial advice, please perform your own due dilligence. AI could hallucinate as project was bootstrapped in a day. Utilize with soft caution!

Built With

Share this project:

Updates