[HN Gopher] Show HN: Wallstreetlocal - View investments from Ame...
___________________________________________________________________
Show HN: Wallstreetlocal - View investments from America's biggest
companies
Hello Hacker News! My name is Anonyo, and I am a seventeen-year-old
from Southeast Michigan. This is wallstreetlocal, my passion
project for the last year (and a half). I've posted this before,
but I've finally open-sourced this entire project, so I thought I'd
post it again. Heres the short pitch. The Securities and Exchange
Commission (SEC) keeps record of every company in the United
States. Companies whose holdings surpass $100 million though, are
required to file a special type of form: the 13F form. This form,
filed quarterly, discloses the filer's holdings, providing
transparency into their investment activities and allowing the
public and other market participants to monitor them. The problem
though, is that these holdings are often cumbersome to access, and
valuable analysis is often hidden behind a paywall. Through
wallstreetlocal, the SEC's 13F filers become more accessible and
open. By exploring the website (and the code), you can see the
resources I used, check out some notable money managers I listed,
and download any data that suits you. All for free. (Note, the
mobile site likely needs work.) I made this project to better
democratize SEC filings, and also to get some experience on my
hands. I love computers, and one day hope to get involved with
startups. In the comments, I'd appreciate any and all advice, as
well as feedback on how to improve the site.
Author : anonyonoor
Score : 157 points
Date : 2024-03-08 18:02 UTC (4 hours ago)
(HTM) web link (github.com)
(TXT) w3m dump (github.com)
| bdjsiqoocwk wrote:
| Feedback is: by making this an npm thing, you reduce the pool of
| people that will use this.
|
| This should really be a lib that takes a folder of 13F forms and
| outputs a csv, or something like this. That's it. No need for
| webapps or whatever.
| anonyonoor wrote:
| There's actually a couple of libraries that already do this,
| and this project can probably function like a libary if edited
| here and there.
|
| The problem I found though is that you can't really just use
| the raw filings. The data is much more useful when the stocks
| are queried with third party APIs and organized along with
| things like recent price data. This project alone uses three
| APIs, and while you could include that in a library and force
| the developer to get three different API keys, it just works
| better as a service.
|
| If a "library" is all you want though, the API is available
| with documentation. There's also 13.info, an open-source
| project that predates this one. Although it is still a service,
| it is more like a library and could probably be used like one.
|
| https://13f.info/
| cobertos wrote:
| Dang, I saw the name and hoped it was a map-based app that showed
| you ownership of things around you (further intriguing me because
| I don't believe such data exists at a local scale anyway).
|
| Great project though! Opening up these sort of semi-encumbered
| datasets is what keeps humans well informed
|
| I'm from MI as well and always wondered about deeper datasets for
| watching money and influence change hands
| arrowleaf wrote:
| There are a lot of GIS / mapping software that shows property
| ownership and their boundaries, useful for hunting. onX, for
| example, and I think you can purchase 'ownership layers' on
| stuff like Avenza.
|
| I agree with what you're saying though, it would be cool to
| take something like those property owner layers and find the
| ultimate legal entity for stuff like LLCs owning land.
|
| E, only semi-related: In the 'urban design' part of the
| internet I've seen really cool mapping that puts bar charts on
| top of a city's grid, with the bar charts being how much tax
| revenue the city generates. It's really stark to see
| skyscraper-sized bars in downtown cores and mostly flat all
| around where cities have zoned residential separate from
| commercial, or even where suburbs tax less than the core city.
| throwup238 wrote:
| _> There are a lot of GIS / mapping software that shows
| property ownership and their boundaries, useful for hunting.
| onX, for example, and I think you can purchase 'ownership
| layers' on stuff like Avenza._
|
| Gaia GPS [1] is the one I use. It's got a lot of layers for
| free including land ownership which properly shows all of my
| neighbors plots. I use it often when collecting rock
| specimens and mushrooms to make sure I'm on public land that
| allows it or to figure out who to seek permission from.
|
| [1] https://www.gaiagps.com/
| ProjectArcturis wrote:
| Whalewisdom and gurufocus have similar offerings. Not sure if
| they are 100% free.
| hbcondo714 wrote:
| Yeah, I'll throw my SEC Filings site https://Last10K.com into
| the mix too that has a free feature on how a manager's
| portfolio changed by tagging which stocks are new / sold /
| increased / decreased from the previous to current quarter.
| Here's an example from the OP's "Popular" and "Top" filers:
|
| Tiger Global: https://last10k.com/sec-filings/1167483
|
| Ruane, Cunniff Goldfarb: https://last10k.com/sec-
| filings/1720792
| anonyonoor wrote:
| Both offer premium memberships, and can often be really
| restricting when viewing/downloading data.
|
| The main feature I added because of WhaleWisdom was the data
| download. For any filer you can download all data in CSV or
| JSON, as on WhaleWisdom that's unavailable. I also plan to add
| a bunch of features those sites have eventually.
| bklyn11201 wrote:
| Lots of competition here as services like WhaleWisdom are quite
| powerful at the basics around 13F.
|
| Some ideas:
|
| * Cluster the 13Fs into buckets. Performance buckets and
| volatility buckets and aggressiveness buckets. * Build model
| portfolios that blend holdings from the best performers. * Do
| some basic regime analysis and find which 13F filers perform best
| during the various regimes.
| seanhunter wrote:
| Nice job! Working on things is really the only way to get better
| and this is a great project to sink your teeth into.
|
| My advice is: Keep working, keep learning. If you love computers
| and want to work for a startup you absolutely have what it takes
| to make that happen. And if there are no startups near you which
| are right for you, you can found your own.
| toomuchtodo wrote:
| Please consider contributing data from this to https://www.data-
| liberation-project.org/
|
| https://www.data-liberation-project.org/datasets/
|
| Awesome work!!
| anonyonoor wrote:
| Awesome project, I have submitted a request.
| jzebedee wrote:
| This is a fantastic project. Thank you for releasing it!
|
| Do you have a plan to expand with new features and are you
| looking for contribution?
|
| Will the database be updated automatically?
| anonyonoor wrote:
| I plan to add a lot of features, and all suggestions are
| appreciated.
|
| As for contribution, I am definitely looking for it. I have not
| been in the open-source field for long so I don't exactly know
| how to get it, but I would highly appreciate it if anyone could
| help.
|
| Contribution would be especially helpful since I was still
| learning a lot of the technologies I used while I built this
| project, and the code is prone to newbie mistakes.
| greatNespresso wrote:
| I have learned something today, thank you for that! The pitch is
| clear and the fact that you put so much work in open sourcing it
| is really impressive.
| ramathornn wrote:
| This is a cool concept, great job on the project so far!
| ashish10 wrote:
| Impressive work. Just a small comment - It seems to not able to
| track the prices after bonus or a stock split. If you can adjust
| the paid price for stock to account for that. Like for google i
| see the price: $1413.61
| rvnx wrote:
| same with AMZN (Berkshire Hataway holdings for example), 1kUSD
| -> 100 USD because of stock split (eventually shows -90%
| performance)
| Tijdreiziger wrote:
| 504: GATEWAY_TIMEOUT Code: FUNCTION_INVOCATION_TIMEOUT
|
| If the data changes irregularly, you're probably better off
| making it a static site and having a script update it
| periodically, also to avoid excessive cloud charges (since you
| seem to be hosting this on Vercel).
| anonyonoor wrote:
| Vercel hosts the front-end, but the back-end is whats down
| right now. I thought I could rely on my Always Free Oracle
| cloud instance but I guess not.
|
| The problem with making a static site is that there are over
| 800,000 SEC filers, so it would be impossible to query all of
| them and store it.
|
| I hadn't expected so much traffic, so I really have no clue how
| to handle this without excessive cloud charges. The best I've
| done so far is to look into free hosting for open-source
| projeccts and add a donation link to the homepage.
| thecosas wrote:
| I think your site may be getting hugged to death right now. I
| have a feeling you'll learn a lot more about scalability after
| being on the front page of HN :-)
| anonyonoor wrote:
| Wow, you really nailed it on the head.
|
| I have been tearing my hair out for the last hour trying to get
| my Always Free Oracle instance running again.
| neom wrote:
| So you're 17. It's a pretty unique niche for a young person, so
| I'd be interested to know where your curiosity in this comes
| from, and even more so, why you decided to share the output of
| your curiosity? What got you interested? Where do you see it
| going? Are other people around you at your stage in life also
| interested in this stuff?
|
| imo you're on a great path, stick with it!
| sroussey wrote:
| Hi! This looks great. I am playing with SEC data at Embarc.com
| and found that ingesting the filings is no fun. Well, if it is
| xml, it is fine. But 8k filings are all HTML. Thankfully they
| have standard section names.
|
| Anyhow, are you downloading the sec filings locally and
| processing them? It can be a lot of files! The EDGAR database has
| a lot of files in there. I download stuff daily, add to sqlite,
| and then process into various other things. I had to do some app
| side compression as the sqlite file gets big!
| anonyonoor wrote:
| For the search database, I did have to manually download each
| and every company, all 856,000 of them. To cut down on size
| though, I included all data points except for filings. This is
| because they're large, but also because they're updated often.
| By excluding them the database stays more up-to-date.
|
| Other than the search database which needs to be available on
| demand, the rest of the filers are queried and analyzed on
| demand. This is required because some filers get really, really
| big. Blackrock Inc alone is about a 30MB file.
| multicast wrote:
| Very interesting project, I like the overview. I also really like
| that you took the finance industry as a theme for your project.
|
| >> Every company in the United States
|
| Sorry for being so fussy but I highly recommended changing the
| word 'company' / not using it in the future, as the title is
| quite misleading. No private company in the US has to register
| with the SEC or has to file with the SEC. 'Investment advisors',
| who also go by other aliases like 'asset manager', have to file a
| 13F filing only if they a) are registered with the SEC due to
| fund marketing purposes and b) if they have, as you already
| mentioned, over $100 million dollars under management (not 'in
| holdings'). This is also why large family offices (.e.g. Bayshore
| Global Management of Sergey Brin) won't show up in any SEC
| records as they meet the second but not the first criteria - same
| goes pretty much for any non asset-management company (e.g.
| McDonald's) as they do not raise money for fund vehicles.
| However, you have take this into account on your website, and
| further below you wrote "money manager" which is correct in
| finance jargon.
|
| I hope this gives you a better understanding, keep up the great
| work.
| anonyonoor wrote:
| I geniunely did not know that there was a real difference
| between companies and asset managers. Sorry for the confusion.
|
| Thanks for informing me, and for the kind words, I'll make sure
| to avoid using the word company from now on.
___________________________________________________________________
(page generated 2024-03-08 23:00 UTC)