JLMSim: WhoDoesWhat Output Description
One of the output files produced by the run with input to be found now in
JLMSimInput for Case M23a NrS16NrIT8_1000_50_200NL -1.txt
is
WhoDoesWhatIn Case M23a NrS16NrIT8_1000_50_200NL -1.cvs
The analogous .xls file to this .csv file can be obtained by reformatting all
of its cells to include commas in
their numbers, then saving the file in xls file type. (To select all cells in the original
Daily Reports for Case...csv file, click on the corner of the
worksheet, to the left of A and above 1. The entire sheet should change color to show that it has been selected. Then click
Fomat|Cells and select the tab labeled Number. Under Category select
Custom, then under Type select #,##0 and click
OK.)
For each simulated day and security, this file includes a table with one row for each
Investor
Template, such as the following for Day 36, Security 0. (The totals at the bottoms of the bought and sold columns were
added here.)
| Day | Inv Temp | Sec
0 Bought |
NrBuyers | SeqLargest | AmtLargest | AcctStatus | Sold | NrSellers | SeqLargest | AmtLargest | AcctStatus |
| 36 | 0 | 0 | 0 | 0 | 0 | 0 | 10,037 | 415 | 204 | 1,503 | 0 |
| 36 | 1 | 0 | 0 | 0 | 0 | 0 | 2,815 | 68 | 497 | 732 | 0 |
| 36 | 2 | 11,536 | 18 | 863 | 6,508 | 0 | 3,206 | 14 | 77 | 2,679 | 0 |
| 36 | 3 | 41,300 | 111 | 269 | 25,199 | 0 | 35,336 | 521 | 627 | 6,490 | 0 |
| 36 | 4 | 0 | 0 | 0 | 0 | 0 | 468 | 23 | 3 | 173 | 0 |
| 36 | 5 | 0 | 0 | 0 | 0 | 0 | 186 | 4 | 0 | 149 | 0 |
| 36 | 6 | 0 | 0 | 0 | 0 | 0 | 81 | 2 | 7 | 65 | 0 |
| 36 | 7 | 0 | 0 | 0 | 0 | 0 | 707 | 31 | 31 | 152 | 0 |
| 52,836 | 52,836 |
The table shows that of the 52,836 shares of Security 0 that were purchased on Day 36,
Template 3 investors bought 41,300. There were 111 Template 3 buyers. The one that bought the most was 3-269, who bought 25,199
shares. 521 Template 3 investors sold 35,336 shares. Of these, the largest seller (3-627) sold 6,490.
It is not unusual for investors of a given template to be buyers and sellers of the same security on the same day in a JLMSim run.
As a security's expected return changes, so does its ideal weight in the
portfolios of investors of a given template. Because of happenstance with respect to order execution or random deposits
and withdrawals, some investors of the template can have more than the ideal and others less as of a given
moment. The former will try to sell some; the latter will try to buy some. It is even possible for the same investor
to appear as both a buyer and a seller on the same day. Investors of Templates 0, 3, 4 and 7 reoptimize
daily. Before reoptimization on a given day, an investor's position in a given security may be below yesterday's
ideal; after reoptimization it may be above today's ideal.
The table for Day 36, Security 1 appears to the right of that for Day 36, Security 0; the table for Security 2 appears to the right
of that for Security 1; and so on for a total of ten tables in a row. The table for Day 36, Security 10 appears under that for
Day 36, Security 0. For a given day, the tables for the sixteen securities of the current run are arranged as follows.
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 |
This pattern can be used with any number of Investor Templates and any number of days, subject to one caveat. An Excel worksheet can have at most 65,536 lines. With sixteen Investor Templates, this row limit is sufficient for not quite 3,000 days. Specifically, the WhoDoesWhatIn Case M23a NrS16NrIT8_1000_50_200NL -1.xls file ends abruptly in the middle of Day 2,979.