return to table of content

Show HN: Wallstreetlocal – View investments from America's biggest companies

cobertos
7 replies
1d23h

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
5 replies
1d21h

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
3 replies
1d20h

> 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/

doctoboggan
2 replies
1d16h

Thanks for the pointer, I just downloaded the app. What is the name of the layer showing property boundaries for free? I can see the “Private Land (US)” but it’s prompting me to sign up for premium when I click on it.

throwup238
1 replies
1d16h

Oooff that's my mistake. I might be grandfathered in on the premium layers and didn't realize.

doctoboggan
0 replies
1d14h

Ah ok yeah I thought that was too good to be true. Currently using onX for this but am paying $30/year for the private land layer

gopher_space
0 replies
1d1h

Most of the information these services draw from is publicly available, and the stuff that isn’t is of questionable accuracy.

cman1444
0 replies
1d11h

The app landglide does what you're saying pretty well.

multicast
3 replies
1d19h

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
1 replies
1d12h

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
0 replies
1d4h

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
0 replies
1d19h

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.

sroussey
2 replies
1d20h

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
1 replies
1d19h

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.

sroussey
0 replies
1d18h

I get the list of filings, and for now only download the ones I want, which are related to S-1 or 8k (there are lot that are related, including withdrawals of a filing, updates to a filing, etc., and some companies use an S-4 etc).

Right now I scan the list of daily filings, and for every cik I mark them as dirty. Another pass looks at ciks marked dirty, and downloads the xml or json of the filings. I then scan for anything new, create filing rows and mark them as dirty so to speak.

Annual reports can be big, and for my purposes I don't need them so I skip them. The HTML of these things is garbage! But a lot of financial data is in the company facts which is nice and clean.

Tijdreiziger
2 replies
1d21h

  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
1 replies
1d19h

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.

password4321
0 replies
1d16h

You can query a SQLite DB entirely client side over HTTP: https://github.com/proofrock/ws4sqlite

The pre-processed data would have to be served from somewhere though. I'm not sure if GitHub could be used to host.

If not, Scaleway Stardust includes a bit of disk, 75GB free S3-compatible storage, and most importantly: free 100mbps outbound data transfer for < $4/month.

There are probably other cheap shared web hosts that claim unlimited data transfer but not sure they'll deliver.

ProjectArcturis
2 replies
1d23h

Whalewisdom and gurufocus have similar offerings. Not sure if they are 100% free.

anonyonoor
0 replies
1d19h

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.

anonyonoor
0 replies
1d19h

Awesome project, I have submitted a request.

thecosas
1 replies
1d20h

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
0 replies
1d19h

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.

simpletone
1 replies
1d15h

The Securities and Exchange Commission (SEC) keeps record of every company in the United States.

No. SEC keeps tabs on publicly traded companies, large institutional investors and the like. Hence the 'securities' and 'exchange'. Most companies in the US are private and not publicly traded. And most companies are not asset managers.

and valuable analysis is often hidden behind a paywall.

Sure, but that's because analysis is valuable.

I made this project to better democratize SEC filings

The SEC already makes the information publicly available via their edgar system.

In the comments, I'd appreciate any and all advice, as well as feedback on how to improve the site.

I'm not sure who your target audience is. Finance companies already have internal teams pulling this kind data for them or they buy it from finance data providers. As for the general public, what need do they have for top 'filers'? As for me, I'd rather dump the data into a database or excel and query it rather than looking at a static page.

At the very least, don't make the site static. Try to add a spreadsheet. Or at the very least a sorting option. Also, vanguard, blackrock, etc aren't top filers. They are the largest or top asset managers. Maybe tie news stories to each asset manager? And more data? But as I said, not sure what the value here is for the end user. Why would I or anyone else ever use your site? Or better yet, what do you use the site for?

OJFord
0 replies
1d8h

Private companies don't have to file 13Fs, sure, but it's not true that the SEC doesn't 'keep tabs on' them, they still have to be non-fraudulent in their private offerings, etc.

neom
1 replies
1d20h

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!

anonyonoor
0 replies
1d19h

My cousin told me about 13F filers about a year and a half ago, and I was shocked to find out that all SEC data is public. After I saw that a lot of sites restrict data for SEC filings, I set out to find the SEC filings directly and make them more accessible.

This project was a way to use my web development experience for a good cause, and to learn a lot along the way. I hope to improve the project thouroughly though user suggestion, then maybe hand it off to other people. Like I said in my post, my main goal is to one day get into start-ups, so I can create good in the world through them. This is hopefully the first step in that journey.

Thanks for your kind words.

kyleleelarson
1 replies
1d6h

I am working on a somewhat similar project, for searching items 1 and 1a in 10-k annual reports, that I am hoping to release in the near future. I would be interested to hear what lessons you end up learning about scaling up to handle the interest you got from HN.

anonyonoor
0 replies
22h34m

Definitely limit the more disk heavy features, or spend more time (and money) on infastructure. I was running the whole site on an 8vCPU 24GB RAM VM, and it almost immediately crashed due to the high disk reads.

This is likely due to the fact that the database is huge, and providing that data on demand is very resource intensive- especially when there are forty different people sending many requests a second.

If you don't want to compromise on data though, look into spending a little bit more time/money on infrastructure. I wish I had deployed the project on Kubernetes, instead of what I ended up doing.

jzebedee
1 replies
1d22h

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
0 replies
1d22h

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.

carlossouza
1 replies
1d17h

Congrats on the project!

Here’s an idea to monetize it: implement collaborative filtering (example: funds in rows, assets in columns).

Once you do it, you will be able to cluster similar funds. Let’s say X funds have the asset A, but Y funds do not have it, and X and Y belong to the same cluster. Thus, if you recommend asset A to the Y funds, there’s a high probability they’d add it to their portfolio (if property pitched). This is roughly how Netflix recommends movies, Spotify recommends songs, etc.

A lot of players in the industry would pay high $$$ for a recommender system like that. And you already made 80%: it’s only missing the final machine learning part (which is the fun part :))

anonyonoor
0 replies
1d17h

This is a great idea, especially since I am already learning machine learning with Python right now. I will try this, thanks.

bdjsiqoocwk
1 replies
1d23h

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
0 replies
1d22h

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/

ashish10
1 replies
1d21h

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
0 replies
1d20h

same with AMZN (Berkshire Hataway holdings for example), 1kUSD -> 100 USD because of stock split (eventually shows -90% performance)

seanhunter
0 replies
1d23h

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.

randomcarbloke
0 replies
1d3h

Isn't there a website where you can view the trades by day of executives at large companies and see what moves they're making?

I used to have it bookmarked

ramathornn
0 replies
1d22h

This is a cool concept, great job on the project so far!

greatNespresso
0 replies
1d22h

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.

bklyn11201
0 replies
1d23h

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.

bigfatfrock
0 replies
1d12h

Great work, keep going!