RIA Wire Articles · July 30, 2026 · By Karilyn Colegrove, Publisher, RIA Wire

How to Lose Your Mind at the SEC

The data is public.

That is the first problem.

Every month the SEC makes Form ADV information available to anyone who wants it. In theory this should settle the matter. A resourceful person could download the files, sort the records, and assemble a perfectly adequate list of mid-sized RIAs without paying anyone a cent. The government has already collected the information. All that remains is the easy part of making it usable.

The easy part is where people begin to come undone.

The Attractive Idea of Free Information

Form ADV filings contain the basic facts that appear to matter: registration dates, reported assets, locations, and other details that help determine whether a firm belongs in the $100M to $500M range. The information is official. It is regularly updated. It is, in the narrow sense, free.

This produces a tidy and appealing story. Why would anyone pay for a prospect list when the underlying records are already published by the federal government? The story is logical. It is the kind of story that thrives best when it is never subjected to prolonged contact with reality.

Then the Files Are Opened

The raw data arrives in a condition that only a career regulator could love. Multiple tables that must be linked. Fields that require interpretation. Formatting that seems designed to test character. Records that look complete until they are examined closely. What appeared simple from a comfortable distance becomes a small, unpaid research project the moment it lands on the screen.

Most people begin with energy. They download the files. They build a few filters. They produce something that is nearly usable. Then the next month's data appears, the previous work begins to age, and the nearly usable file reveals itself as a temporary and slightly defective accomplishment.

The public record is current.

A clean, reliable version of the public record is a different creature entirely.

The Quiet Tax on Doing It Yourself

There is nothing particularly virtuous about spending hours reconciling government data formats if the actual goal is to speak with firms that are still in a buying window. Time spent cleaning files is time not spent on conversations. Time spent rebuilding the same logic each month is time that could have been used while decisions were still being made.

The do-it-yourself approach consumes, with great reliability, the very resource it claims to conserve. It looks efficient in conversation. In practice it often produces a list that is both late and imperfect in ways that only become obvious after the outreach has already underperformed.

Some people genuinely enjoy this kind of work. They are rare. Most salespeople are measured on conversations and revenue, not on their ability to maintain a private data-cleaning operation in parallel with their real job.

The Data Is Public. The Headache Is Optional.

The existence of public Form ADV data allows everyone to maintain a pleasant and low-effort belief: that current information is freely available to anyone with a bit of initiative. Technically the belief is correct. Practically it leaves out the important part. The distance between “available” and “ready to use this week” is where the difficulty lives, and it is not a small distance.

Commercial list businesses have understood this gap for years and have charged accordingly. Some have charged a great deal. The option of handling the raw files yourself remains open, of course. It simply requires a recurring willingness to perform the same unglamorous labor every month while the firms themselves continue to move in and out of their most receptive periods.

Those who want the information without the monthly descent into regulatory formatting tend to make other arrangements. Those who continue to wrestle with the raw files eventually discover the same lesson, usually after several cycles of optimism followed by quiet exhaustion:

The SEC does not prevent you from using its data.

It merely makes the experience memorable.