JLM Simulator Documentation


Home
Overview
Input File
Daily Reports
Estimates
Order Impact
Parameters
Trace File
WhoDoesWhat
Release Notes
Case Studies
License

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


© 2009 Jacobs Levy Equity Management. All rights reserved.
For problems or questions regarding this website contact JLM_Sim@jacobslevy.com.
Last updated: June 30, 2005