{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Read_Me","P&L Tool","Asset Class P&L"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read_Me","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["In order for this spreadsheet to work, you must…"]
[]
["1) Enable Macros"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2) Open the VB Editor"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3) Write the macro"]

{"sheet":"P&L Tool","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Last:","13:35:31"]
[]
["Type","Symbol","Positions","Purch Date","Purch Price ($)","Last Price ($)","Change ($)","ITD ($)","YTD ($)","P&L ($)"]
["EQUITY","AA",{"$f":"'Asset Class P&L'!G5","v":5000},"2011-10-03",9.1199999999999992,{"$f":"'Asset Class P&L'!D5","v":8.92},{"$f":"'Asset Class P&L'!E5","v":-0.17},{"$f":"'Asset Class P&L'!I5","v":-17900},{"$f":"(E4-15.8)*C4","v":-33400.000000000007},{"$f":"'Asset Class P&L'!J4","v":-2790}]
["EQUITY","T",{"$f":"'Asset Class P&L'!G6","v":2500},"2011-08-05",28.49,{"$f":"'Asset Class P&L'!D6","v":28.81},{"$f":"'Asset Class P&L'!E6","v":0.16},{"$f":"'Asset Class P&L'!I6","v":2174.9999999999936},{"$f":"(F5-28.01)*C5","v":1999.999999999993},{"$f":"'Asset Class P&L'!J5","v":-850.00000000000011}]
["EQUITY","ORCL",{"$f":"'Asset Class P&L'!G4","v":3000},"2011-11-07",{"$f":"'Asset Class P&L'!H4","v":31.9},{"$f":"'Asset Class P&L'!D4","v":29.87},{"$f":"'Asset Class P&L'!E4","v":-0.93},{"$f":"'Asset Class P&L'!I4","v":-6089.9999999999927},{"$f":"(E6-31.39)*C6","v":1529.9999999999941},{"$f":"'Asset Class P&L'!J4","v":-2790}]
["OPTION","ORCL",{"$f":"'Asset Class P&L'!G11","v":300},"2011-11-15",{"$f":"'Asset Class P&L'!F11","v":10.15},{"$f":"'Asset Class P&L'!H11","v":9.98},{"$f":"'Asset Class P&L'!I11","v":-0.77},{"$f":"'Asset Class P&L'!J11","v":-83.999999999999801},{"$f":"IF(E6>20,((27-20)*300),(-9.911*300))","v":2100},{"$f":"'Asset Class P&L'!J11","v":-83.999999999999801}]
["BOND","ORCL ",{"$f":"'Asset Class P&L'!C17","v":500},"2011-03-01",{"$f":"'Asset Class P&L'!B17","v":108},{"$f":"'Asset Class P&L'!D17","v":115.188},-0.2,{"$f":"'Asset Class P&L'!J17","v":3594.0000000000014},{"$f":"'Asset Class P&L'!I17","v":57594},{"$f":"'Asset Class P&L'!K17","v":-7.9999999999955662}]
["FUTURE","CL",{"$f":"'Asset Class P&L'!F22","v":1000},"2011-09-05",{"$f":"'Asset Class P&L'!G22","v":89.38},{"$f":"'Asset Class P&L'!H22","v":95.43},{"$f":"'Asset Class P&L'!I22","v":0.06},{"$f":"'Asset Class P&L'!K22","v":6050.0000000000109},{"$f":"(F9-91.55)*C9","v":3880.0000000000095},{"$f":"'Asset Class P&L'!L22","v":60.000000000002274}]
[null,null,null,null,null,null,"Total:",{"$f":"SUM(H6:H9)","v":3470.0000000000196},{"$f":"SUM(I6:I9)","v":65104},{"$f":"SUM(J6:J9)","v":-2821.9999999999932}]
[]
[]
["Note : The web service connections have been removed, new ones can be set when you sign up for a free trial at:",null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"https://www.xignite.com/MyAccount/Register.aspx\",\"Xignite Free Trial\")","v":"Xignite Free Trial"}]

{"sheet":"Asset Class P&L","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Equity:"]
[]
["ns1:Symbol","ns1:Name","ns1:Date","ns1:LastPrice","ns1:ChangeFromMarketOpen","ns1:ChangeFromLastMarketClose","Positions","Purchase Price","ITD","P&L"]
["ORCL","Oracle Corporation","12/14/2011",29.87,-0.93,-0.96,3000,31.9,{"$f":"(D4-H4)*G4","v":-6089.9999999999927},{"$f":"G4*E4","v":-2790}]
["AA","Alcoa Inc.","12/14/2011",8.92,-0.17,-0.12,5000,12.5,{"$f":"(D5-H5)*G5","v":-17900},-850.00000000000011]
["T","AT&T Inc.","12/14/2011",28.81,0.16,-0.23,2500,27.94,2174.9999999999936,400]
[]
["Options:"]
[]
["ns1:BaseSymbol","ns1:Type","ns1:Month","ns1:Year","ns1:StrikePrice","Purchase Price","Positions","ns1:Last","ns1:Change","P&L"]
["ORCL","Call",1,2012,20,10.15,300,9.98,-0.77,{"$f":"IF(D4>20,((D4-20-F11)*300),(-15.55*300))","v":-83.999999999999801}]
[]
[]
["Fixed Income (Bonds)"]
[]
["ns1:ShortName","Purchase Price","Position ","ns1:TradePrice","ns1:YieldToMaturity","ns1:PriceForYieldCalculation","ns1:DailyOpen","Last Year Close","YTD","ITD","P&L"]
["5.25 Oracle 16 Nts",108,500,115.188,1.3594999999999999,114.977,115.20399999999999,0,{"$f":"(D17-H17)*C17","v":57594},{"$f":"(D17-B17)*C17","v":3594.0000000000014},{"$f":"(D17-G17)*C17","v":-7.9999999999955662}]
[]
["Futures"]
[]
["ns1:Symbol","ns1:Name","ns1:Month","ns1:Year","ns1:Type","Position","Purchase Price","ns1:Last","ns1:Change","Previous Close","ITD","P&L"]
["CL","Crude Oil",3,2012,"Future",1000,89.38,95.43,0.06,95.37,{"$f":"(H22-G22)*F22","v":6050.0000000000109},{"$f":"(H22-J22)*F22","v":60.000000000002274}]