@include('common.header')
| Report Name |
: Portfolio Statement |
| As On |
: {{ $report_date }} |
| Sl. |
Trading Code |
Quantity |
Average Cost |
Total Cost |
Market Rate |
Market Value |
Unrealize Gain/Loss |
% Gain/Loss |
% Cost Value |
| Total |
Saleable |
| Marginable Securities |
@php
$unrealizeValueShowPlace = 0;
$totalCostAmountWithCom = 0;
$totalWeightCost = 0;
$totalMktAmount = 0;
$totalWeightMarket = 0;
$cashDividendTax = 20;
$totalGainLossWithCom = 0;
$marginableSecurities = 0;
$nonMarginableSecurities = 0;
$indCharge = 0;
$netGainLossWithMfee = 0;
$returnOnInvestments = 0.00;
$currentAssetsOrLiabilities = 0.00;
$totalIPOApplicationAmount = 0.00;
$totalRightApplicationAmount = 0.00;
$scripWiseStockDivFraction = 0.00;
$unclearCheque = 0.00;
$UNIQUE_MARGIN_NONMARGIN = '';
$TOTAL_COST_PRICE = 0;
$TOTAL_MARKET_PRICE = 0;
$TOTAL_GAINLOSS_PRICE = 0;
$MARGIN_DISPLAY = 0;
$TOTAL_MARGIN_SHARE_COST = 0;
$TOTAL_MARGIN_SHARE_MKT = 0;
@endphp
@foreach ($marginable_securities as $index => $securities)
@php
$instName = $securities->instrument_name;
$symbol = $securities->symbol;
$holdingShare = $securities->total_share;
$maturedShare = $securities->matured_share;
$avgRate = number_format($securities->avg_rate,2);
$closePrice = $securities->close_price;
$ycp = $securities->ycp;
$indTotalCostAmount = $securities->total_cost_amount;
$indTotalMktAmount = $securities->total_mkt_amount;
$indCharge = $securities->charge;
$sectorName = $securities->sector_name;
$marginNonmargin = $securities->margin_or_nonmargin_flag;
// $scripWiseStockDivFraction = 0;//$this->getStockDivFraction($pDate1,$portfolioCode,$securities->INSTRUMENT_DETAILS_ID);
// $pe_ratio = $securities->pe_ratio;
if($closePrice == 0) {
$bCom = 0;
$unGainLoss = 0;
$gainLossPercentWithCom = 0;
$netGL = 0;
$gainLossPercentWithoutCom = 0;
} else {
$bCom = (($indCharge*$indTotalMktAmount)/100);
$unGainLoss = (($indTotalMktAmount-$indTotalCostAmount));
if($indTotalCostAmount>0){
$gainLossPercentWithCom = (($unGainLoss*100)/$indTotalCostAmount);
$netGL = ($indTotalMktAmount-$indTotalCostAmount);
$gainLossPercentWithoutCom = (($netGL*100)/$indTotalCostAmount);
} else {
$gainLossPercentWithCom = 0.00;
$netGL = ($indTotalMktAmount-0);
$gainLossPercentWithoutCom = 0.00;
}
}
//echo $indTotalMktAmount;exit;
if($marginNonmargin == 'y') {
$marginableSecurities += $indTotalMktAmount;
} else {
$nonMarginableSecurities += $indTotalMktAmount;
}
$TOTAL_MARGIN_SHARE_COST += $securities->total_cost_amount;
$TOTAL_MARGIN_SHARE_MKT += $securities->total_mkt_amount;
$totalMktAmount += $indTotalMktAmount;
$totalCostAmountWithCom += $indTotalCostAmount;
$totalGainLossWithCom += $unGainLoss;
if($closePrice == 0) {
$changePricePercent = 0;
$weightCost = 0;
$weightMarket = 0;
$totGainLossPcttWithoutCom = 0;
} else {
if($ycp == 0) {
if($allCostAmount==0){
$weightCost = 0;
}else{
$weightCost = (($indTotalCostAmount*100)/$allCostAmount);
}
$changePricePercent = 0;
$weightMarket = 0;
$totGainLossPcttWithoutCom = 0;
} else {
$changePricePercent = ((($closePrice/$ycp)-1)*100);
$weightCost = (($indTotalCostAmount*100)/$allCostAmount);
$weightMarket = (($indTotalMktAmount*100)/$allMktAmount);
$totGainLossPcttWithoutCom =($totalGainLossWithCom/$totalCostAmountWithCom)*100;
}
}
if($totalCostAmountWithCom) {
$totGainLossPcttWithoutCom =($totalGainLossWithCom*100)/$totalCostAmountWithCom;
} else {
$totGainLossPcttWithoutCom = 0;
}
//echo $totGainLossPcttWithoutCom; exit;
$totalWeightCost += $weightCost;
$totalWeightMarket += $weightMarket;
if($unGainLoss<0){
$showUnGainLoss = '('.number_format(abs($unGainLoss),0).')';
}else{
$showUnGainLoss = number_format($unGainLoss,0);
}
if($gainLossPercentWithoutCom<0){
$showgainLossPercentWithoutCom = '('.number_format(abs($gainLossPercentWithoutCom),2).')';
}else{
$showgainLossPercentWithoutCom = number_format($gainLossPercentWithoutCom,2);
}
if($totalGainLossWithCom<0){
$showtotalGainLossWithCom = '('.number_format(abs($totalGainLossWithCom),2).')';
} else{
$showtotalGainLossWithCom = number_format($totalGainLossWithCom,2);
}
if($totGainLossPcttWithoutCom<0){
$showtotGainLossPcttWithoutCom = '('.number_format(abs($totGainLossPcttWithoutCom),2).')';
}else{
$showtotGainLossPcttWithoutCom = number_format($totGainLossPcttWithoutCom,2);
}
@endphp
| {{ ($index +1) }} |
{{ $symbol }} |
{{ number_format($holdingShare,2) }} |
{{ number_format($maturedShare,0) }} |
{{ $avgRate }} |
{{ number_format($indTotalCostAmount,2) }} |
{{ number_format($closePrice,2) }} |
{{ number_format($indTotalMktAmount,2) }} |
{{ $showUnGainLoss }} |
{{ $showgainLossPercentWithoutCom }} |
{{ number_format($weightCost,2) }} |
@endforeach
|
| Total Marginable Securities: |
{{ number_format($TOTAL_MARGIN_SHARE_COST,2) }} |
|
{{ number_format($TOTAL_MARGIN_SHARE_MKT,2) }} |
|
| Non Marginable Securities |
@php
$TOTAL_MARGIN_SHARE_COST = 0;
$TOTAL_MARGIN_SHARE_MKT = 0;
@endphp
@foreach ($non_marginable_securities as $index => $securities)
@php
$instName = $securities->instrument_name;
$symbol = $securities->symbol;
$holdingShare = $securities->total_share;
$maturedShare = $securities->matured_share;
$avgRate = number_format($securities->avg_rate,2);
$closePrice = $securities->close_price;
$ycp = $securities->ycp;
$indTotalCostAmount = $securities->total_cost_amount;
$indTotalMktAmount = $securities->total_mkt_amount;
$indCharge = $securities->charge;
$sectorName = $securities->sector_name;
$marginNonmargin = $securities->margin_or_nonmargin_flag;
// $scripWiseStockDivFraction = 0;//$this->getStockDivFraction($pDate1,$portfolioCode,$securities->INSTRUMENT_DETAILS_ID);
// $pe_ratio = $securities->pe_ratio;
if($closePrice == 0) {
$bCom = 0;
$unGainLoss = 0;
$gainLossPercentWithCom = 0;
$netGL = 0;
$gainLossPercentWithoutCom = 0;
} else {
$bCom = (($indCharge*$indTotalMktAmount)/100);
$unGainLoss = (($indTotalMktAmount-$indTotalCostAmount));
if($indTotalCostAmount>0){
$gainLossPercentWithCom = (($unGainLoss*100)/$indTotalCostAmount);
$netGL = ($indTotalMktAmount-$indTotalCostAmount);
$gainLossPercentWithoutCom = (($netGL*100)/$indTotalCostAmount);
} else {
$gainLossPercentWithCom = 0.00;
$netGL = ($indTotalMktAmount-0);
$gainLossPercentWithoutCom = 0.00;
}
}
//echo $indTotalMktAmount;exit;
if($marginNonmargin == 'y') {
$marginableSecurities += $indTotalMktAmount;
} else {
$nonMarginableSecurities += $indTotalMktAmount;
}
$TOTAL_MARGIN_SHARE_COST += $securities->total_cost_amount;
$TOTAL_MARGIN_SHARE_MKT += $securities->total_mkt_amount;
$totalMktAmount += $indTotalMktAmount;
$totalCostAmountWithCom += $indTotalCostAmount;
$totalGainLossWithCom += $unGainLoss;
if($closePrice == 0) {
$changePricePercent = 0;
$weightCost = 0;
$weightMarket = 0;
$totGainLossPcttWithoutCom = 0;
} else {
if($ycp == 0) {
if($allCostAmount==0){
$weightCost = 0;
}else{
$weightCost = (($indTotalCostAmount*100)/$allCostAmount);
}
$changePricePercent = 0;
$weightMarket = 0;
$totGainLossPcttWithoutCom = 0;
} else {
$changePricePercent = ((($closePrice/$ycp)-1)*100);
$weightCost = (($indTotalCostAmount*100)/$allCostAmount);
$weightMarket = (($indTotalMktAmount*100)/$allMktAmount);
$totGainLossPcttWithoutCom =($totalGainLossWithCom/$totalCostAmountWithCom)*100;
}
}
if($totalCostAmountWithCom) {
$totGainLossPcttWithoutCom =($totalGainLossWithCom*100)/$totalCostAmountWithCom;
} else {
$totGainLossPcttWithoutCom = 0;
}
//echo $totGainLossPcttWithoutCom; exit;
$totalWeightCost += $weightCost;
$totalWeightMarket += $weightMarket;
if($unGainLoss<0){
$showUnGainLoss = '('.number_format(abs($unGainLoss),0).')';
}else{
$showUnGainLoss = number_format($unGainLoss,0);
}
if($gainLossPercentWithoutCom<0){
$showgainLossPercentWithoutCom = '('.number_format(abs($gainLossPercentWithoutCom),2).')';
}else{
$showgainLossPercentWithoutCom = number_format($gainLossPercentWithoutCom,2);
}
if($totalGainLossWithCom<0){
$showtotalGainLossWithCom = '('.number_format(abs($totalGainLossWithCom),2).')';
} else{
$showtotalGainLossWithCom = number_format($totalGainLossWithCom,2);
}
if($totGainLossPcttWithoutCom<0){
$showtotGainLossPcttWithoutCom = '('.number_format(abs($totGainLossPcttWithoutCom),2).')';
}else{
$showtotGainLossPcttWithoutCom = number_format($totGainLossPcttWithoutCom,2);
}
@endphp
| {{ ($index +1) }} |
{{ $symbol }} |
{{ number_format($holdingShare,2) }} |
{{ number_format($maturedShare,0) }} |
{{ $avgRate }} |
{{ number_format($indTotalCostAmount,2) }} |
{{ number_format($closePrice,2) }} |
{{ number_format($indTotalMktAmount,2) }} |
{{ $showUnGainLoss }} |
{{ $showgainLossPercentWithoutCom }} |
{{ number_format($weightCost,2) }} |
@endforeach
|
| Total Non Marginable Securities: |
{{ number_format($TOTAL_MARGIN_SHARE_COST,2) }} |
|
{{ number_format($TOTAL_MARGIN_SHARE_MKT,2) }} |
|
| |
| Total: |
{{ number_format($totalCostAmountWithCom,2) }} |
|
{{ number_format($totalMktAmount,2) }} |
{{ $showtotalGainLossWithCom }} |
{{ $showtotGainLossPcttWithoutCom }} |
{{ number_format($totalWeightCost,2) }} |
|
Warning: Undefined variable $accountStatus in C:\xampp\htdocs\uslwmcbil_api\resources\views\portfolio\index.blade.php on line 359
Warning: foreach() argument must be of type array|object, null given in C:\xampp\htdocs\uslwmcbil_api\resources\views\portfolio\index.blade.php on line 359
| Account Status Till Today |
| Current Balance / (Loan) |
{{ $showcurrentBalance }} |
|
Market value of Securities |
{{ number_format($totalMarketPrice,2) }} |
| Receivables Sales |
{{ number_format($totalRecievableSales,2) }} |
|
IPO Application |
{{ number_format($ipoApplication,2) }} |
| Unclear Cheque |
{{ number_format($unclearCheque,2) }} |
|
Blocked For IPO Application |
{{ number_format($blockIpoApplication,2) }} |
| Receivables Dividend |
{{ number_format($cashDivReceivable,2) }} |
|
Right Application |
{{ number_format($rightApplication,2) }} |
| Accrued Fees & Charges |
{{ number_format($accured,2) }} |
|
Fund Withdrawal Order |
{{ number_format($fund_withdraw_amount,2) }} |
| Current Assets / (Liabilities) |
{{ number_format($showTotalCurrAsstLiabilities,2) }} |
|
Equity at Cost |
{{ number_format($equity,2) }} |
|
|
|
Equity at Market Value |
{{ number_format($equityAtMv,2) }} |
| CMR Ratio |
{{number_format($cmrRatio,0)}}% |
|
|
|
| Deposit Withdraw Status |
| Deposit Amount |
{{ number_format($totalDeposit,2) }} |
|
|
|
| Total Fund Transfer In |
{{ number_format($transferIn,2) }} |
|
Loan Ratio |
1:{{ $loanRation }} |
| Realize Gain / ( Loss ) |
{{ $showrealizedAmount }} |
|
Purchase Power |
{{ $showavailableBalance }} |
| Dividend Income |
{{ number_format($dividendIncome,2) }} |
|
|
|
| Total Deposit |
{{ number_format($currentDeposit,2) }} |
|
|
|
| Fund Withdraw |
{{ number_format($totalWithDrawBalance,2) }} |
|
Dividend Income |
{{ number_format($dividendIncome,2) }} |
| Transfer Out |
{{ number_format($transferOut,2) }} |
|
Realize Gain / ( Loss ) |
{{ $showrealizedAmount }} |
| Total Withdrawal |
{{ number_format($totalWithdraw,2) }} |
|
Unrealize Gain / ( Loss ) |
{{ $showunrealizeGl }} |
| Net Deposit |
{{ number_format($netDeposit,2) }} |
|
Net Gain / (Loss) |
{{ $shownetGainLoss }} |
|
|
@include('common.footer')