I have a bit, and was always frustrated with not having access to the tools you'd have at bigger companies like capIQ, FactSet or Bloomberg since they're just sold B2B.
Since I have a prior CS background, I've been playing around and built something that uses AI to understand your unique financial modeling template to then extract the key financials from filings (i.e. 10K, 10Q, press release) and fill them into exactly the cells they should go. Key feature I added per some requests is an audit trail for every single cell to see exactly where the data came from highlighted in the text.
This is working quite well in my case, happy to let others try for free if you're curious. But I'm interested in learning what tools you guys are using for your personal investments when it comes to automation, or generally speeding things up!
I use vba macros for it, you can scrape html tables in excel then I have a separate macro that adds the data to my model. Tbh though, the big issue I have isn’t with the US companies, sec Edgar is easy for extracting data. It’s the European ones where everything is in pdf format
nice! Yeah sec edgar is a good api to hook up with for financials. Can you give me an example of one of the european filings you've looked at? I haven't dabbled in that too much.
also interested in your model / examples you can share. thank you!
Does this sheet only work on your local computer or also online, i.e. google sheets?
currently just for excel, but it works for anyone.
Would love to take a look!
Hi! I would love to try it out if possible!
Sure! Pmed you.
Would love to try!
pmed you
Would love to try as well!
pmed
Would love to try!
pmed
Interested, and happy to give feedback.
pmed
Sounds very interesting, always spent a lot of time on keying in financials without access to firm resources. Definitely keen to try it out if possible!
send you a pm!
Very interested in trying this out as well! Thanks for sharing.
No problem, sent a pm.
can you pm me as well?
Would love to give it a go as well!
pmed
Would be very interested in trying!
pmed you.
Doesn't Daloopa do this already?
They do, but it's not into your custom financial model, so you still have to map things over. And... it's certainly not for personal investments since they just allow businesses to use it.
What's your error rate without a pre-mapping step in the workflow?
Would love to take a look, could you pm?
Yep, pmed you.
Interested. Thanks.
Np, check your pm.
I'd like to test it out if possible. Thanks!
Still can take a few more people on, I dmed you.
Would love to try!
Sure, pmed.
Would love to give this a spin, thanks!
sent pm to you
Hey! I'd love to check it out if possible!
Just getting around to this - I sent you a PM!
If this is indeed working as described, on such a low-code/no-code setup, you may have an attractive product at hand… depends on accuracy of the whole thing and ability to apply to US/EU/APAC stocks…at a reasonable price point, this would be a relevant SaaS product for quite an audience, esp. with a proper audit trail. Just stating the obvious…
From a user's perspective it's no code, but certainly took a lot of coding to make haha. I have a computer science background - it's just my brother and I that made this. From my personal experience it's very accurate at pulling financials from filings, and the audit trail is accurate as well, you can check at any point where any data was found in the filings. I sent you a pm, Happy to disucss more in detail
How do you achieve the low error rate, and what do you consider low?
I've assessed a bunch of the commercial solutions and found that the ones that require manual/assisted mapping (someone mentioned Daloopa) are the most reliable.
The PM freaks out if you get just 1-2 numbers in the quarter wrong. Given they don't understand tech, they consider the whole experiment failed and ask you to start doing it manually again next print.
Am I the only one who sees how out-of-touch it is to use Excel modelling for personal investments that are worth less than $10m??
Yes
Sounds interesting. I’d love to take a look.
Dm'ed you
Would love to try!
Sent you a dm
Would love to try!
Sure, check your dm.
Hey I'd love to try it if possible!
Check your dm!
Would love to try this as well.
Sent you a DM.
Would love to try!
Hey, sent you a dm.
Would love to give it a try!
Pmed.
Hi ! Sounds very interesting !
I would love to try too !
pmed
I’m happy to try and give feedback, I wanna model Toyota lol I’m super bull on them
pmed
Hi! Would love to try it out if possible!
Hi! Would love to try it out if possible!
hey! I messaged you
Hi! Would love to try it out as well if possible!
dmed
Hi! I would love to try this out! I PMed you
Hi would like to try it as well Thanks!
pmed
Interested as well!
I just model in front of the mirror and hype myself up before buying personal investments.
Interesting concept. Here's a banana. What AI platform are you using to export and categorize the data?
As a next improvement... couldn't you utilize another AI platform to peruse and categorize the European filings that typically come in PDF? There is definitely AI capable of doing that and it really doesnt seem difficult considering the work you have already done.
Also, I do like the idea of auditting every cell to uncover where the data came from. That's a nice touch that saves alot of head scratching for the end user. No more deciphering of EDGAR reports required.
I'd love to check it out and give feedback on features to add/ how to improve it. However, I am not necessarily from a CS background so my input would be more from a basic end user point of reference.
Good luck
I'm using a custom trained anthropic model to understand the data, and for exporting and categorizing it I have developed a custom PDF parser.
European filings are definitely a good suggestion, something I haven't covered in the past. And yes the auditing is nice, you can fully trust results from AI this way. No need for a CS background, I reached out to you if you'd like to have a quick chat later on this.
Hi! Would love to try it out as well if possible!
Can I try it out? Happy to provide feedback. Have been developing my own models for miners as I’m based in Australia
This is cool. I’ll share my thoughts if I can get my hands on it.
would love ti tryyy, thank you!!
Would love to try it! Thanks very much
Would love to try it out! Thanks!
my wife has a personal interest in RE...so i let her handle all of it she just tells me where to sign...
she builds "models" but they're nothing fancy or complex. i'm a partner in a few roll-up / smb deals that friends bring to me, but i'll typically just review their materials.
My PA is 50% ETFs and remaining 50% are my top 5 ideas outside my coverage at work (obviously can't trade those names). All longs. I used to cover this space in PE years ago and built models for them, so I've just been updating them q/q. I have a pretty significant amount of $ in each of those 5, so having a model and being somewhat close to them is important to me. To each their own.
What are your go to ETFs?
I agree, it's fun (and smart) to have models for your individual investments. How do you find time to update the every quarter? This was the part I felt was quite time consuming.
Interested..
would like to try as well. thank you very much
Definitely keen to run this.
Tried to make something work with PDFs (I am Europe based) but it's too painful.
Hey, I'd love to try it out too!
Hey guys, trying to let as many people try out what I made since there are so many requests! It's money coming out of my own pocket, and i'm setting each person up with $20 of spend on me. To use AI like this isn't free, unfortunately (I wish it was). If I haven't messaged you i'll get to you later, but trying not to overwhelm the server (or my wallet).
This is the most obvious market testing post ever and everyone slurped it up.
If the software is decent with good use case I don't see what the problem is. I'll gladly slurp it up if it means my current basket of stocks to watch gets easier to manage.
yo, I dmed you.
Would love to try whenever you’re open to it - thanks
Sure, got some room for you man. Check your inbox.
would love to try! Thx
check your inbox
Would love to try as well. Thank you!
sure, check your inbox.
Wow, great to hear about this tool. I’d love to try it — thanks!
Wow, great to hear about this tool. I’d love to try it — thanks!
inboxed you.
It would be great to try this out. Thanks in advance!
no problem man, check your inbox.
I model a bit just to get a rough return profile down, nothing too technical. It isn't worth the marginal benefit for the time cost, considering that personal investing is really a hobby.
I'd love to try it if possible!
sure dude, check your inbox.
Hi, would love to try this too. For personal investments, I use Tikr to quickly copy over financials and do some very fast modelling. No excel export tool, but they make copying data fairly easy. Then if interesting enough, I will look into the filings and do some real work. Tbh the model is often the least problematic aspect. The research aspect is what takes the greatest amount of time and chatgpt helps a lot. Not so much so for researching but for converting very complex text into something with dedicated explanations for someone that is not an expert in that particular subject. It is prone to making assumptions but if you pay a lot of attention to what it spits out, you can almost always tell where the assumptions are likely made. Meanwhile Alpha Spread has a pretty cool tool for searching transcripts (e.g. https://www.alphaspread.com/security/nyse/jnj) and I use the free version. For idea generation, I have a bunch of different screens and various market signals I follow e.g. spinoffs, CEO departure (restructuring), etc. Not paying a dime for anything aside from Tikr.
interesting. This fills financials directly into any model template you have, from any amount of pdfs you upload. Check your inbox, I gave you instructions on how to use it for the beta testing round. Only allowing a few people to try at the moment.
Would love to check this out
check your inbox
Keen to try this as well, thanks!
sure, check your inbox.
Would love to try it out
check your inbox.
I'm interested in checking it out, would you be open to sharing it?
Yeah man, check your inbox.
would love to try!
sent you a message, check your inbox
Hey! Would love to try this tool
sure thing, check your inbox.
could i try it out?
Yep, check your inbox.
would love to try!
sent you a message, check your inbox.
Also would love to try please.
check your inbox
interested if you can pm me. Would love to learn from your work
Sure man, check your inbox.
Would love to check out the model!
it's powered by an AI model, but it's an excel add-in and website at the moment. I sent you instructions on how to get set up, and credits. Check your inbox.
would love to try it - when you are available haha
Yo, I sent you a link to chat i'm curious to hear your thoughts, so check your inbox.
Also interested, thank you!
check you inbox
Give this a look brother, it’s a chrome extension I built specifically for this: https://chromewebstore.google.com/detail/omniaxe/docgcdbkigfdcgfimpfahc…
Would also love to try, thanks a lot.
Letting some more people try, check your inbox.
Would love to try this out!
inboxed you
Would also love to try it.
inboxed you
Would also love to try it!
inboxed you
Would love to try it, thanks!
inboxed you
Interested in trying this, thanks!
Sent a message.
Hi, I would love to try this out
Sent a message.
Would like to try this as well, thank you
Sent a message.
Hi I would love to try. Could you pls send me the template / vba? Thanks a lot and merry christmas
Sint veritatis consequatur facilis commodi dolore laboriosam. Quia cumque pariatur eum corporis et qui. Hic omnis numquam iste esse ad.
Et assumenda vel voluptas alias consequuntur est. Totam dolorem rem voluptatem. Ab soluta ut omnis minima neque aut. Officiis reiciendis fuga amet.
Harum et animi non dolor aut perferendis. Aut est voluptatum sed occaecati consequatur earum. Natus non sequi voluptatem aut id illo doloribus sed. Est necessitatibus ut odit inventore nihil.
Dolorem tempore consequatur omnis rerum. Unde quia voluptatibus eos ipsa. Et voluptate recusandae amet soluta aut ducimus quis. Aliquid accusamus fugiat rerum. Cum similique quia doloremque maiores odio. Quia necessitatibus nihil debitis nam. Aliquam et adipisci eaque iste quod aut pariatur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Illum assumenda magnam nostrum culpa velit sit earum doloremque. Dolorum quaerat eveniet aut incidunt cumque. Aut quibusdam facilis reiciendis iste eum quidem. Fuga eum et aut dolorum delectus fuga minus. Est qui quo eaque commodi.
Sed cumque nemo culpa eos accusamus quibusdam. Enim non commodi expedita exercitationem sit.
Aliquid laboriosam et ipsa. Veniam repellendus et rerum vel alias saepe.
Repudiandae rem aspernatur pariatur. Ut iure iste temporibus excepturi rem tenetur non. Molestiae libero deserunt quisquam magni ullam sit voluptatum. Laborum enim nulla nesciunt ratione sit.
Tempore quia ipsam impedit quibusdam sequi illo. Non odit at qui delectus amet enim dolorem sit.
Dolor voluptatum dolores doloremque ut et reiciendis officiis. Officia incidunt nihil esse sequi aut. Odio nulla ipsam dolores totam aut dolorum repellendus. Sunt et illo vitae quae id.
Ea qui saepe officiis commodi. Qui et ut aut excepturi sunt dolore.
Recusandae debitis iusto eaque. Sunt consequuntur ipsam vel fuga autem. Cumque dolorem dolorum odio qui quis. Eum culpa et sit porro optio sit est. Recusandae quos nihil excepturi aut ea praesentium quis. Inventore porro vel ab voluptate pariatur et in dolorem.
Nesciunt sapiente et perferendis placeat ipsum molestiae. Et et modi sequi beatae modi.
Quo culpa maiores aspernatur vel aliquid sed. Eum odio sit vel provident aut quia. Iste et voluptatem rem unde. Assumenda amet sed deserunt non tenetur est ipsum. Consequuntur nisi blanditiis sapiente sit a sit itaque.
Culpa corrupti voluptatum unde est non dolorem a autem. Aut quia maxime consequatur autem sunt rerum. Quia porro quam sit. Et quaerat et eaque repudiandae culpa sit aut.
Iste quae ea vitae aut saepe nostrum cum. Sed aut quis laudantium vero non praesentium quas.
Minima error et sed quia quae. Voluptates magni cupiditate sed consequatur et qui. Odit nemo tenetur est provident rem voluptatibus architecto.
Voluptatem quasi veniam blanditiis. Consequatur nulla quis voluptatum aperiam quas dolorem provident. Ex ipsam eos corrupti maiores nemo atque optio. Laborum dolor a illum doloremque aut. Tenetur nisi deserunt eum alias. Harum animi quidem et et iusto quasi.
Tenetur optio maiores assumenda voluptas optio perferendis ut. Ut corporis et eveniet dicta aspernatur. Odio consequatur adipisci quia quas asperiores. Enim unde cupiditate animi aperiam ut dolorem. Qui at laudantium ut molestiae aut impedit rerum. Quae et voluptas laudantium sunt doloremque tempora. Minus blanditiis aperiam amet fuga.
Autem placeat officiis aut laudantium quia. Enim voluptas dolores dignissimos est et error recusandae. Porro in voluptates ad aut. Voluptates omnis sit dolores tenetur odio rerum.
Numquam nesciunt pariatur laboriosam repellendus. Explicabo enim qui laudantium sint. Dolore quo adipisci voluptatibus quia quis. Enim nobis non voluptatem exercitationem et ab doloribus. Ullam dolorem dolores est ad ab minus sed. Reprehenderit nihil mollitia iusto doloremque.
Quos eos maxime dolorem illum omnis dolorum blanditiis. Qui voluptatem tempora neque voluptas. Eum eum reprehenderit aliquid asperiores est ea. Et consectetur illum rerum. Sequi voluptas totam consequatur iure. Praesentium delectus illum rerum nihil.
Officiis ipsa at rem eum nihil qui. Tempore expedita neque rem. Quae velit eveniet sed unde corrupti animi possimus. Qui sit rerum maxime provident corporis. Aperiam qui non quas perferendis animi repellendus. Sed libero non rerum.
Atque est a et molestias. Quia amet est cum. Labore soluta laborum omnis commodi. Qui sit consectetur ut ipsa adipisci.
Et voluptatem vel ab quos. Omnis ut pariatur eaque molestias tenetur nulla eum dolorem. Eaque qui soluta porro aut. Atque mollitia recusandae veritatis eum molestiae quos dolores magnam. Atque tempora ut blanditiis pariatur itaque.
Quas nobis omnis accusantium voluptas. Qui quam in autem. Accusantium nihil eum repudiandae consequatur quos ut corporis sit. Id natus tempora nihil doloribus consequatur magnam occaecati atque.
Dolorum ipsum facere error ex accusantium consectetur iste quasi. Iste itaque eligendi dolores veniam fugiat et. A quae consectetur autem expedita. Nam temporibus illo ut sunt esse qui vero.
Eligendi voluptatem dolorem occaecati perferendis nihil. Dolores velit molestiae voluptatem officia optio.