|












| |
JLMSim: Order Impact Output Description
(This page contains wide tables. Please print in landscape mode.)
One of the output files produced by the run with input to be
found in
JLMSimInput for Case M23a NrS16NrIT8_1000_50_200NL -1.txt
is the Order Impact Analysis File
Order Impact Analysis for Case M23a NrS16NrIT8_1000_50_200NL -1 t GE 100.xls
This is the .xls, slightly reformatted, version of a .csv output file.
Note that, in addition to the usual case description information
added to most output files, this Order Impact Analysis File name includes the phrase "t GE 100." This indicates that the order
impact information reported here excludes the first 99 days (literally, time >= day 100). The
starting date of the analysis is an input parameter.
For each Investor Template, for each security and for buy and sell separately, the
Order Impact Analysis provides information
concerning the 25 largest orders placed during the course of the simulation. Below are the table headings and
the first ten lines of results.
Order Impact Analysis for Case M23a NrS16NrIT8_1000_50_200NL -1 t GE 100.csv
Investor
Template |
Seq
Number |
Account
Status |
Security
Number |
Buy
Sell |
Amount
Wanted |
Amount
Obtained |
Start
Time |
Start
Bid |
Start
Offer |
St B/O
Avg |
Avg
Price |
End
Time |
End
Bid |
End
Offer |
End B/O
Avg |
|
0 |
736 |
0 |
0 |
Buy |
60,890 |
0 |
3562.12 |
213.45 |
-1.00 |
-1.00 |
-1.00 |
3563.12 |
217.74 |
219.92 |
218.83 |
|
0 |
736 |
0 |
0 |
Buy |
60,862 |
0 |
3736.12 |
204.18 |
206.01 |
205.09 |
-1.00 |
3737.12 |
227.81 |
229.65 |
228.73 |
|
0 |
736 |
0 |
0 |
Buy |
59,841 |
0 |
3563.12 |
217.74 |
219.92 |
218.83 |
-1.00 |
3564.12 |
228.23 |
231.09 |
229.66 |
|
0 |
736 |
0 |
0 |
Buy |
58,066 |
0 |
3849.12 |
204.83 |
204.83 |
204.83 |
-1.00 |
3850.12 |
208.85 |
208.87 |
208.86 |
|
0 |
736 |
0 |
0 |
Buy |
57,558 |
0 |
3940.12 |
201.48 |
201.45 |
201.46 |
187.21 |
3941.12 |
209.65 |
211.66 |
210.65 |
|
0 |
736 |
0 |
0 |
Buy |
54,194 |
0 |
3090.12 |
187.44 |
189.73 |
188.58 |
-1.00 |
3091.12 |
203.13 |
-1.00 |
-1.00 |
|
0 |
736 |
0 |
0 |
Buy |
50,728 |
0 |
3817.12 |
193.82 |
197.44 |
195.63 |
-1.00 |
3818.12 |
218.24 |
220.80 |
219.52 |
|
0 |
736 |
0 |
0 |
Buy |
48,372 |
0 |
3757.12 |
199.75 |
-1.00 |
-1.00 |
-1.00 |
3758.12 |
207.79 |
209.85 |
208.82 |
|
0 |
736 |
0 |
0 |
Buy |
48,046 |
0 |
3561.12 |
202.91 |
205.04 |
203.97 |
-1.00 |
3562.12 |
213.45 |
-1.00 |
-1.00 |
|
0 |
736 |
0 |
0 |
Buy |
46,905 |
0 |
3928.12 |
201.06 |
201.67 |
201.36 |
-1.00 |
3929.12 |
207.07 |
209.11 |
208.09 |
|
0 |
736 |
0 |
0 |
Buy |
42,892 |
13,639 |
3885.12 |
204.50 |
204.55 |
204.52 |
202.70 |
3886.12 |
215.10 |
219.16 |
217.13 |
|
0 |
736 |
0 |
0 |
Buy |
42,575 |
0 |
3581.12 |
212.93 |
214.74 |
213.83 |
-1.00 |
3582.12 |
237.59 |
241.43 |
239.51 |
It is recommended that you freeze the pane with the cursor on the first line of output, under the heading
"Amount Wanted." This will allow you to keep track of the Investor Template number, security number, and buy or sell
mode currently being displayed. In particular, the first, fourth and fifth entries in
the rows shown indicate
that these
rows report on the largest attempted purchases by investors of Template 0 for
Security 0. We term these "purchase attempts" rather than
"purchase orders"
since the
attempt may have been placed in several orders.
The amount
shown is the amount which the investor requested of the trader.
The second entry in each of these rows shows that each of the dozen largest
purchase attempts for Security 0 by investors of Template 0 were by the specific
investor with sequence number 736. The third entry indicates the investor's
status, thus
| Code |
|
Status |
| 0 |
|
OK |
| 1 |
|
Margin Call |
| 2 |
|
Defunct |
Investor 0-736 was
in OK status when the purchase attempts occurred. The sixth and seventh entries
in the first row indicate that 0-736 wanted 60,890 shares and got none.
Further, among the twelve largest purchase attempts by any investor of
Template 0, all by 0-736, in no instance did the investor buy all he sought. In
eleven cases the investor got none. The following extract shows that an
investor of Template 1 was much more successful in getting large buy orders
executed. One difference between the two Investor Templates lies in the
differing Trader Template used and the aggressiveness of the respective
traders. See Input File Documentation.
Investor
Template |
Seq
Number |
Account
Status |
Security
Number |
Buy
Sell |
Amount
Wanted |
Amount
Obtained |
Start
Time |
Start
Bid |
Start
Offer |
St B/O
Avg |
Avg
Price |
End
Time |
End
Bid |
End
Offer |
End B/O
Avg |
|
1 |
651 |
0 |
0 |
Buy |
12,801 |
12,801 |
2090.62 |
216.80 |
216.89 |
216.84 |
218.09 |
2090.82 |
216.89 |
218.12 |
217.50 |
|
1 |
651 |
0 |
0 |
Buy |
10,627 |
10,627 |
1110.62 |
229.00 |
231.24 |
230.12 |
229.00 |
1111.02 |
229.00 |
231.24 |
230.12 |
|
1 |
651 |
0 |
0 |
Buy |
10,237 |
10,237 |
1350.62 |
163.18 |
163.22 |
163.20 |
164.56 |
1351.04 |
164.81 |
166.32 |
165.57 |
|
1 |
651 |
0 |
0 |
Buy |
10,206 |
10,206 |
2870.62 |
186.07 |
186.11 |
186.09 |
186.11 |
2870.62 |
186.07 |
186.11 |
186.09 |
|
1 |
651 |
0 |
0 |
Buy |
8,494 |
8,494 |
1790.62 |
190.05 |
193.87 |
191.96 |
194.66 |
1790.82 |
191.95 |
195.83 |
193.89 |
|
1 |
651 |
0 |
0 |
Buy |
8,390 |
8,390 |
1010.62 |
219.85 |
222.01 |
220.93 |
219.85 |
1011.02 |
219.85 |
222.01 |
220.93 |
|
1 |
651 |
0 |
0 |
Buy |
8,321 |
8,321 |
810.62 |
214.91 |
214.93 |
214.92 |
216.48 |
811.02 |
217.04 |
219.13 |
218.09 |
|
1 |
651 |
0 |
0 |
Buy |
7,972 |
7,972 |
2310.62 |
185.72 |
185.78 |
185.75 |
185.78 |
2310.62 |
185.72 |
185.78 |
185.75 |
|
1 |
651 |
0 |
0 |
Buy |
7,367 |
7,367 |
350.62 |
198.21 |
198.22 |
198.22 |
198.34 |
350.82 |
198.21 |
200.19 |
199.20 |
|
1 |
651 |
0 |
0 |
Buy |
7,280 |
7,280 |
1430.62 |
178.97 |
-1.00 |
-1.00 |
185.74 |
1432.32 |
184.40 |
186.08 |
185.24 |
|
1 |
651 |
0 |
0 |
Buy |
7,213 |
7,213 |
2210.62 |
203.90 |
203.94 |
203.92 |
203.94 |
2210.62 |
203.90 |
203.94 |
203.92 |
|
1 |
651 |
0 |
0 |
Buy |
6,932 |
6,932 |
2490.62 |
224.55 |
224.62 |
224.58 |
224.62 |
2490.62 |
224.55 |
224.62 |
224.58 |
The twelve largest purchase
attempts for Security 0 by investors of Template 1 were placed by 1-651. Columns
labeled "Start time," "Start Bid," "Start Offer," and
"St B/O AVG" show that the largest amount sought was 12,801 shares at time (in
days) of 2090.62. At the time the best bid was $216.80; the best offer was
$216.89. Thus the bid/asked average was about $216.845, shown here as $216.84
under the heading St[art] B/O AVG. The column titled AVG PRICE shows that
$218.09 was the average price at which the shares were purchased. The columns
labeled "End Time," "EndBid," "End Offer," and
"End B/O Avg" show that the
order was completed about two-tenths of a day later, at 2090.82 At that time
the best bid was $216.89; the best offer was $218.12 for a bid/offer average of
$217.50. Thus Investor 1-651's trader obtained the entire 12,801 shares at a
small premium to the initial bid/asked average and at almost the ending offer
price. In general, in all twelve cases 1-651 obtained the entire position
desired, usually at little or no premium to the initial bid/offer average.
Note 1: "-1.00" in a bid or asked column
indicates the absence of the bid or offer.
Note 2: JLMSim trades are conducted in whole
shares but not necessarily whole lots.
Back to Top |