Readit News logoReadit News
Posted by u/anonyonoor a year ago
Show HN: Wallstreetlocal – View investments from America's biggest companiesgithub.com/bruhbruhroblox...
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.

cobertos · a year ago
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 · a year ago
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 · a year ago
> 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/

gopher_space · a year ago
Most of the information these services draw from is publicly available, and the stuff that isn’t is of questionable accuracy.
cman1444 · a year ago
The app landglide does what you're saying pretty well.
multicast · a year ago
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.

pmalynin · a year ago
I think that’s not entirely correct either, for example Nvidia had to file a 13F for its holdings after their value of ARM shares exceeded 100M. And the requirement I believe is not for investment advisors (which is its own thing, see Register Investment Advisors from the SEC), but broadly extends to institutional investment managers which is a lot looser of a definition that can certainly include private companies like broker-dealers, in addition to hedge funds, RIC, etc as well as public corporation like Nvidia depending on the types of activities they are involved in.
multicast · a year ago
Good point, I did not mention that. Non-registered investment advisors are also included but this relates more to banks, bank holdings and broker/dealers (e.g. investment banks) who trade on 'investment discretion'[1]. Thus it means entities that are not registered as an investment advisor but still invest on behalf of outside clients and not their own book. This does clearly not apply to Nvidia. It is highly unlikely and not logical that they would manage money for third parties in the name of the public corporate entity, just for a pure side hustle. As that would not contribute much financially (in terms of fees that are earned from managing money on behalf of others) nor to their core business.

The reason for this 13F filing, as you already guessed to some extent, is that Nvidia is a publicly traded company. As such it is subject to a wide range of SEC filings including those from section 13[2].

Nvidia seems to be a rare case. Acquiring public equity, as a company - especially as a public one, just for the purpose of managing concurrent assets, is very unusual but not out of the question - just away from the textbook. Given the fact that its ARM, whose acquisition failed before Nvidia filed the 13F, it could also serve some other purpose, e.g. showing that interest is still present.

[1] https://www.sec.gov/divisions/investment/13ffaq#:~:text=Bank....

[2] https://www.legalandcompliance.com/securities-law/sec-report...

anonyonoor · a year ago
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.

Dead Comment

ashish10 · a year ago
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 · a year ago
same with AMZN (Berkshire Hataway holdings for example), 1kUSD -> 100 USD because of stock split (eventually shows -90% performance)
seanhunter · a year ago
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.

bklyn11201 · a year ago
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.

greatNespresso · a year ago
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.
toomuchtodo · a year ago
Please consider contributing data from this to https://www.data-liberation-project.org/

https://www.data-liberation-project.org/datasets/

Awesome work!!

anonyonoor · a year ago
Awesome project, I have submitted a request.
amai · a year ago
Strange, suddenly Vanguard Group doesn't show up anymore under top filers: https://www.wallstreetlocal.com/recommended/top But they should be the same amount of assets like Black Rock: https://en.wikipedia.org/wiki/List_of_asset_management_firms

Why did they vanish from the list? Maybe a data bug?