//AFL adjusment right issue
//pastikan anda telah backup database
//Right Issue = jumlah saham bertambah dan jumlah equity bertambah
//sebelum jalankan explore, pilih TICKER yg ada action right issue
//input tgl paling awal s/d tgl Cum RIGHT
//pilih current, run explore, save as , beri nama sesuai ticker , save file dgn akhiran CSV
//masuk submenu import wizard, pick file ini, lalu import ( warning hanya boleh dilakukan SATU KALI saja )
//ketika anda sudah lakukan import, jangan run lagi explore-nya.
NS = 41 ;//input new stock
OS = 10 ;//input old stock
NP = 100 ;//input right issue price
no =( O*Os + np*ns )/( OS + NS ) ;//new open
nh =( H*Os + np*ns )/( OS + NS ) ;//new high
nl =( L*Os + np*ns )/( OS + NS ) ;//new low
nc =( C*Os + np*ns )/( OS + NS ) ;//new close
Filter=C>0;
AddColumn(no,"open ",1.3);
AddColumn(nh,"high ",1.3);
AddColumn(nl,"low ",1.3);
AddColumn(nc,"close ",1.3);
AddColumn(V,"volume ",1.0);
//pastikan anda telah backup database
//Right Issue = jumlah saham bertambah dan jumlah equity bertambah
//sebelum jalankan explore, pilih TICKER yg ada action right issue
//input tgl paling awal s/d tgl Cum RIGHT
//pilih current, run explore, save as , beri nama sesuai ticker , save file dgn akhiran CSV
//masuk submenu import wizard, pick file ini, lalu import ( warning hanya boleh dilakukan SATU KALI saja )
//ketika anda sudah lakukan import, jangan run lagi explore-nya.
NS = 41 ;//input new stock
OS = 10 ;//input old stock
NP = 100 ;//input right issue price
no =( O*Os + np*ns )/( OS + NS ) ;//new open
nh =( H*Os + np*ns )/( OS + NS ) ;//new high
nl =( L*Os + np*ns )/( OS + NS ) ;//new low
nc =( C*Os + np*ns )/( OS + NS ) ;//new close
Filter=C>0;
AddColumn(no,"open ",1.3);
AddColumn(nh,"high ",1.3);
AddColumn(nl,"low ",1.3);
AddColumn(nc,"close ",1.3);
AddColumn(V,"volume ",1.0);
__._,_.___
No comments:
Post a Comment