Trade Deficits and Trading

There's been a lot of talk over the years about the trade deficit as concerns imports and exports. I understand that concept - we buy more than we sell, so money is leaving the country. I also understand, roughly, that that's a bad thing. Well, I used to understand that. Looking at a section of the previous link, there seem to be a lot of smart people that think trade deficits could be a good thing. That may be a topic for later.

I've been curious as to whether money is actually leaving the country, overall. This balance of trade really only covers the import and export of physical goods and real services, as near as I can tell. I can find no indication that the portion of treasury auctions purchased by foreign entities counts as either an export or import. This statistic also doesn't count profits and losses from stock trades, bonds, forex trades, etc.

Awesomely enough, some of that data can be found. It looks like I could spend a few years sifting through the data at the Treasury International Capital (TIC) site. It took me most of a day to read the FAQ! But, there's some absolutely great data, such as this grand total table of foreign transactions. And these grand total tables of foreign liabilities and foreign claims. And this other table of derivatives contracts stuff. There's a lot of information to read on how to use all this information. Then there's this table of everything (Flow of Funds Accounts) over at the Federal Reserve statistics site.

Perhaps you can see why I said I found a lot more information than I expected to. I still don't think this covers everything. For one, the FAQ says there are a lot of errors due to a variety of factors. And even with all these statistics being complete, I don't think they would be able to answer my question. I'm still not sure if these show any profitability in all these trades, and I'm almost positive they don't cover forex transactions, since that has an average daily volume of $3.98 trillion, and I don't see any figures with large enough values to cover that. I have to admit that I'm tired of looking into it at the moment. However, if anyone has the answer, or even just another piece of the puzzle, please do let me know in the comments!