//@Name:Reported ROE //@Description:Returns a share's ROE calulated using reported post-tax profit as opposed to normalised. //@Returns:Number //@Width:60 var var1 = 0; function init(status) { if (status == Loading || status == Editing) { var1 = storage.getAt(0); } if (status == Adding || status == Editing) { dlg = new Dialog("Settings...", 155, 55); dlg.addOkButton(); dlg.addCancelButton(); dlg.addIntEdit("INT1",8,-1,-1,-1,"","years ago",var1,0,10); if (dlg.show()==Dialog.Cancel) return false; var1 = dlg.getValue("INT1"); storage.setAt(0, var1); } setTitle("Reported ROE ("+var1+" yr ago") } function getVal(share) { var prof = share.getResult(-var1, Result.ReportedPostTax) var nav0 = share.getResult(-var1, Result.BookValue) var nav1 = share.getResult(-var1-1, Result.BookValue) var roe = prof / ((nav0+nav1)/2) * 100; if (roe==Infinity || roe==-Infinity) return return roe }