news


※上記の広告は60日以上更新のないWIKIに表示されています。更新することで広告が下部へ移動します。

◆portfolio
 title
   port no,row,dscr1~31
 calc
   A7:A15  =SUM(D7:AH7)
◆acct-prev
 title
   G2   price by Units
   G3   price by 1Unit
   I5   in JPY(RoundDown)
   AO5  in JPY(Round)
   BU5  in Units
   A6:AM6 file,SMA No,acct No,cash,p-cash,NAV,t-cash,DSCR1~31
   AO6:BS6  DSCR1~31
   BU6:CY6  DSCR1~31
 calc
   I4 =ROUNDDOWN(BU4*I$3,0)
   AO4 =ROUND(BU4*AO$3,0)
   I3:AM3  I2/10000 -> copy
   AO2:BS2 =I2 -> copy
   AO3:BS3 =I3 -> copy
 data
   I2:AM2 price
◆acct-port
 title
   D1:AJ1 port folio col,"D","E",・・・
   A6:AJ6 file,SMA No,port,row,DSCR1~31
 calc
   F4  =INDIRECT("portfolio!"&F$1&$E4)
◆model
 title
   A6:AJ6 file,SMA No,port,row,DSCR1~31
 calc
   E4  =ROUND('acct-prev'!$G4*'acct-port'!F4,0)
◆diff
 title
   E5   in JPY All
   AK5  in JPY Buy
   BQ5  in JPY sell
   A6:AI6 file,SMA No,acct No,port,DSCR1~31
   AK6:BO6 DSCR1~31
   BQ6:CU6 DSCR1~31
 calc
   E4  =model!E4-'acct-prev'!AO4
   AK4  =IF(E4>0,E4,0)
   BQ4  =IF(E4<0,E4,0)
◆trades
 title
   E5  in Units
   AK5 in JPY
   A6:AI6 file,SMA No,acct No,port,DSCR1~31
   AK6:BO6 DSCR1~31
   BQ6:CU6 DSCR1~31
 calc
   E2:AI2 ='acct-prev'!AO2 -> copy
   E3:AI3 =E2*0.985/10000 -> copy
   E4  =ROUNDDOWN(diff!BQ4/E$3,0)