4 ms·
Another somewhat off-topic comment: Someone please do this for stock prices / SEC data / financial modeling, with the ability to output into PDF (or PPTX) and y
by airstrike 7y ago
Another somewhat off-topic comment: Someone please do this for stock prices / SEC data / financial modeling, with the ability to output into PDF (or PPTX) and you will conquer the world.
- iamwil 7y agoWho would you talk to that would buy? Where do you find them?
- airstrike 7y agoInvestment Banks, but maybe sell the functionality to a large provider like FactSet or Capital IQ who already have their packaged software licensed to big financial institutions Alternatively build something more tightly integrated to MS Office and sell it to Microsoft
- mkl 7y agoWhat do you mean? Jupyter notebooks can already work with any kind of data (including fetched over the internet), and can already output to PDF.
- airstrike 7y agoThey output to a PDF with very limited formatting... I mean something like these: https://www.sec.gov/Archives/edgar/data/826083/000119312513134593/d505474dex99c4.htm https://www.sec.gov/Archives/edgar/data/826083/0001193125131... https://www.sec.gov/Archives/edgar/data/826083/000119312513134621/d505474dex99c24.htm https://www.sec.gov/Archives/edgar/data/826083/0001193125131... https://www.sec.gov/Archives/edgar/data/826083/000119312513134593/d505474dex99c5.htm https://www.sec.gov/Archives/edgar/data/826083/0001193125131...
- datagy 7y agoSo you are talking about type of Notebook for Inline XBRL data rendering?
- airstrike 7y agoThis isn't exactly XBRL as the calculations are all bespoke, done for the purposes of these specific presentations My vision is separating financial analysis from formatting, or bringing CSS / markup languages into the world of Excel and sidestepping PowerPoint entirely if possible PowerPoint is a slide presentation tool that is sadly used for authoring so-called "books" with lots of formatting in Investment Banking, Management Consulting and Corporate America at large... and its shortcomings become immediately obvious As we speak (!!!), I'm having to reformat a book from our standard template into the client's template by manually resizing charts, recoloring series, etc... literally wasting hours of my time because we use Excel + PPT
- iamwil 7y agoWouldn't that mean clients would have to give you templates in CSS / markup? Or would you maintain different templates for different clients? And then the task would just be mapping the data generated to the templates, mad lib style?
- airstrike 7y agoClient templates happen, but they aren't the norm. I pointed that example out as one egregious waste of time, but simply conforming Excel charts / tables to the company's format is very time consuming on a day-to-day basis. A lot of people just don't have an intuitive sense for design or plain don't care, so you're left with a high variance in the quality of the work that is produced. Speaking from my banking experience, the result is senior bankers have to spend time marking up documents on things like formatting, and junior bankers feel frustrated because they waste their productive hours on non-productive work. And it's generally a frustrating experience indeed as the tools we use aren't built for this purpose. But formatting is just part of it. "Code" reusability (more like financial model reusability) is basically zero, auditing is a pain and people use many different approaches to do the same things, but again with varying levels of efficiency and accuracy. I can tell you 10 ways to calculate Total Shareholder Returns for a public company using the FactSet add-in in Excel. Also several ways to pull Revenue and EBITDA figures, and these aren't even the more esoteric metrics like Free Cash Flow or Funds from Operations. These decks that we prepare should work like recipes. Input the ingredients and out comes the prepared dish, but everything is so god damn manual Not to mention issues with Excel itself, like how Excel's (non-cascading) styles and defined names (similar to variables) propagate to other workbooks if you copy-paste content from one to another, which in the long-term creates files full of garbage that crash and corrupt frequently The whole paradigm is a shit show. One day it will be different, I am certain. But nobody has taken a holistic, multi-disciplinary view at the problem because bankers / consultants don't know what is possible with today's technology and the ones trying to address these usability issues are only looking at a couple pieces of the puzzle at once
- iamwil 7y agoAre these the outputs that you'd have to generate because your client has to submit reports to the SEC? Or am I misunderstanding?
- airstrike 7y agoNo, these are outputs that the client pays us to generate for them. These specific instances that I linked were from an example that was made public and then filed with the SEC, but usually these decks remain private