Originally Posted by geoffrey.mcgill
<ext:TabPanel ID="Pages"
runat="server"
Region="Center"
LayoutOnTabChange="true" MonitorResize="true" Layout="FitLayout"
Header="false"
>
<Items>
<ext:FormPanel ID="FormPanel1"
runat="server"
Title="Period Statistics"
Frame="true"
BodyPadding="3"
Width="1500"
Height="600">
<Bin>
<ext:Store
ID="CompanyStore"
runat="server" OnSubmitData="Store1_Submit" >
<Model>
<ext:Model ID="Model1" runat="server">
<Fields>
<ext:ModelField Name="Account" Mapping="Account" />
<ext:ModelField Name="Period_Returns" Mapping="Period_Returns" Type="Float" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Bin>
<FieldDefaults LabelAlign="Left" MsgTarget="Side" />
<LayoutConfig>
<ext:VBoxLayoutConfig Align="Stretch" />
</LayoutConfig>
<Items>
<ext:Panel ID="Panel3"
runat="server"
Flex="1"
Border="false"
BodyStyle="background-color: transparent;">
<LayoutConfig>
<ext:HBoxLayoutConfig Align="Stretch" />
</LayoutConfig>
<Items>
<ext:GridPanel
ID="CompanyGrid"
runat="server"
Flex="5" AutoDoLayout="true"
Title="Calculated Statistics"
StoreID="CompanyStore">
<TopBar>
<ext:Toolbar ID="Toolbar2" runat="server">
<Items>
<ext:ToolbarFill ID="ToolbarFill1" runat="server" />
<ext:Button ID="Button3" runat="server" Text="To Excel" Icon="PageExcel">
<Listeners>
<Click Handler="submitValue(#{CompanyGrid}, #{FormatType}, 'xls');" />
</Listeners>
</ext:Button>
<ext:Button ID="Button1" runat="server" Text="Export To Pdf" Icon="PageWhiteAcrobat">
<DirectEvents>
<Click OnEvent="ExportEt" IsUpload="true" >
<ExtraParams>
<ext:Parameter Name="data" Value="#{CompanyGrid}.getRowsValues()" Mode="Raw" Encode="true" />
<ext:Parameter Name="format" Value="pdf" Mode="Value" />
</ExtraParams>
</Click>
</DirectEvents>
</ext:Button>
</Items>
</ext:Toolbar>
</TopBar>
<ColumnModel>
<Columns>
<ext:Column
ID="Account"
runat="server"
Text="Account"
Width="120"
DataIndex="Account"
StyleSpec="font-weight: bold;" />
<ext:Column ID="Column1"
runat="server"
Text="Period Returns"
Width="100"
DataIndex="Period_Returns"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00')+ '%';" />
</ext:Column>
<ext:Column ID="Column10"
runat="server"
Text="Compound ROR"
Width="110"
DataIndex="Compound_ROR"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00')+ '%';" />
</ext:Column>
<ext:Column ID="Column2"
runat="server"
Text="Standard Deviation"
Width="120"
DataIndex="Standard_Deviation"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00')+ '%';" />
</ext:Column>
<ext:Column ID="Column3"
runat="server"
Text="Sharpe Ratio"
Width="100"
DataIndex="Sharpe_Ratio"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00');" />
</ext:Column>
<ext:Column ID="Column4"
runat="server"
Text="Annualized Sharpe Ratio"
Width="140"
DataIndex="Annualized_Sharpe_Ratio"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00') ;" />
</ext:Column>
<ext:Column ID="Column5"
runat="server"
Text="Omega"
Width="75"
DataIndex="Omega"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00') ;" />
</ext:Column>
<ext:Column ID="Column6"
runat="server"
Text="Sortino Ratio"
Width="100"
DataIndex="Sortino_Ratio"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00');" />
</ext:Column>
<ext:Column ID="Column7"
runat="server"
Text="Maximum Drawdown"
Width="120"
DataIndex="Maximum_Drawdown"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00')+ '%';" />
</ext:Column>
<ext:Column ID="Column8"
runat="server"
Text="Calmer Ratio"
Width="90"
DataIndex="Calmer_Ratio"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00');" />
</ext:Column>
<ext:Column ID="Column9"
runat="server"
Text="Sterling Ratio"
Width="90"
DataIndex="Sterling_Ratio"
Align="Right" StyleSpec="font-weight: bold;">
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00') ;" />
</ext:Column>
</Columns>
</ColumnModel>
<Listeners>
<SelectionChange Fn="onSelectionChange" />
</Listeners>
</ext:GridPanel>
<ext:Panel ID="Panel4"
runat="server"
Flex="3"
Title="Risk Return Details"
MarginSpec="0 0 0 5">
<LayoutConfig>
<ext:VBoxLayoutConfig Align="Stretch" />
</LayoutConfig>
<Items>
<ext:Chart ID="Chart1"
runat="server"
Margin="0"
InsetPadding="20"
Flex="1"
StandardTheme="Blue"
Animate="true">
<Store>
<ext:Store
ID="RadarStore"
runat="server"
Data="<%# RadarData %>"
AutoDataBind="true">
<Model>
<ext:Model ID="Model2" runat="server">
<Fields>
<ext:ModelField Name="Name" />
<ext:ModelField Name="Data" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<Axes>
<ext:RadialAxis Steps="5" Maximum="50" />
</Axes>
<Series>
<ext:RadarSeries
XField="Name"
YField="Data"
ShowInLegend="false"
ShowMarkers="true">
<MarkerConfig Radius="4" Size="4" />
<Style Fill="rgb(194,214,240)" Opacity="0.5" StrokeWidth="0.5" />
</ext:RadarSeries>
</Series>
</ext:Chart>
</Items>
</ext:Panel>
</Items>
</ext:Panel>
<ext:Panel ID="Panel2" runat="server" Height="200" Layout="FitLayout" MarginSpec="0 0 3 0" Title="Annualized Sharpe Ratios">
<Items>
<ext:Chart
ID="BarChart1"
runat="server"
Flex="1"
Shadow="true"
Animate="true"
StoreID="CompanyStore" Legend="false">
<Axes>
<ext:NumericAxis Position="Left" Fields="Sharpe_Ratio" Minimum="0" Hidden="true" >
<Label>
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00');" />
</Label>
</ext:NumericAxis>
<ext:CategoryAxis Position="Bottom" Fields="Account">
<Label Font="9px Arial">
<Rotate Degrees="315" />
<Renderer Handler="return Ext.String.ellipsis(value, 15, false);" />
</Label>
</ext:CategoryAxis>
</Axes>
<Series>
<ext:ColumnSeries
Axis="Left"
Highlight="true"
XField="Account"
YField="Sharpe_Ratio">
<Style Fill="#456d9f" />
<HighlightConfig Fill="#a2b5ca" />
<Label
Contrast="true"
Display="InsideEnd"
Field="Sharpe_Ratio"
Color="#000"
Orientation="Vertical"
TextAnchor="middle"
>
<Renderer Handler="return Ext.util.Format.number(value, '0,0.00');" />
</Label>
<Listeners>
<ItemMouseUp Fn="onMouseUp" />
</Listeners>
<Tips TrackMouse="true" Width="200" Height="28">
<Renderer Handler="this.setTitle(storeItem.get('Account') + ': ' + Ext.util.Format.number(storeItem.get('Sharpe_Ratio'),'0,0.00'));" />
</Tips>
</ext:ColumnSeries>
</Series>
</ext:Chart>
</Items>
</ext:Panel>
</Items>
</ext:FormPanel>
<ext:Panel runat="server" ID="AreaPanel" Title="Area Chart" Layout="FitLayout">
<TopBar>
<ext:Toolbar runat="server">
<Items>
<%-- <ext:Button ID="Button1"
runat="server"
Text="Export Chart to the Server"
Icon="DiskDownload"
Handler="exportChart"
/>--%>
</Items>
</ext:Toolbar>
</TopBar>
<Items>
<%-- <ext:Chart
ID="Chart2"
runat="server"
Legend="true"
Animate="true">
<Background>
<Gradient Angle="90" GradientID="Gradient1">
<Stops>
<ext:GradientStop Color="#feffff" Offset="0" />
<ext:GradientStop Color="#d2ebf9" Offset="60" />
</Stops>
</Gradient>
</Background>
<Store>
<ext:Store ID="AreaStore"
runat="server" >
<Model>
<ext:Model ID="Model3" runat="server">
<Fields>
<ext:ModelField Name="Period_Date"> </ext:ModelField>
<ext:ModelField Name="ABC FUND LP" />
<ext:ModelField Name="SP500" />
<ext:ModelField Name="SP501" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<Axes>
<ext:NumericAxis
Fields="ABC FUND LP,SP500,SP501"
Title="Number of Hits"
Minimum="0">
</ext:NumericAxis>
<ext:CategoryAxis
Position="Bottom"
Fields="Period_Date"
Title="Accounts"
Grid="false">
<Label>
<Rotate Degrees="315" />
<Renderer Handler="return Ext.util.Format.date(value,'M d,Y');" />
</Label>
</ext:CategoryAxis>
</Axes>
<Series>
<ext:AreaSeries
Axis="Left"
XField="Period_Date"
YField="ABC FUND LP,SP500,SP501">
<Style Opacity="0.93" />
</ext:AreaSeries>
</Series>
</ext:Chart>--%>
</Items>
</ext:Panel>
<ext:Panel runat="server" ID="Panel5" Title="Bar Chart" Layout="FitLayout">
<TopBar>
<ext:Toolbar ID="Toolbar1" runat="server">
<Items>
<%-- <ext:Button ID="Button2"
runat="server"
Text="Export Chart to the Server"
Icon="DiskDownload"
/>--%>
</Items>
</ext:Toolbar>
</TopBar>
<Items>
<%-- <ext:Chart
ID="Chart3"
runat="server"
Legend="true"
Animate="true"><LegendConfig Position="Bottom"></LegendConfig>
<Background>
<Gradient Angle="90" GradientID="Gradient1">
<Stops>
<ext:GradientStop Color="#feffff" Offset="0" />
<ext:GradientStop Color="#d2ebf9" Offset="60" />
</Stops>
</Gradient>
</Background>
<Store>
<ext:Store ID="Store2"
runat="server" >
<Model>
<ext:Model ID="Model6" runat="server">
<Fields>
<ext:ModelField Name="Period_Date"> </ext:ModelField>
<ext:ModelField Name="ABC FUND LP" />
<ext:ModelField Name="SP500" />
<ext:ModelField Name="SP501" />
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<Axes>
<%-- <ext:NumericAxis
Fields="Monthly_Returns"
Title="Number of Hits"
Minimum="0">
</ext:NumericAxis>
<ext:CategoryAxis
Position="Bottom"
Fields="Period_Date"
Title="Accounts"
Grid="false">
<Label>
<Rotate Degrees="315" />
<Renderer Handler="return Ext.util.Format.date(value,'M d,Y');" />
</Label>
</ext:CategoryAxis>
</Axes>
<ext:NumericAxis Fields="ABC FUND LP,SP500,SP501" Position="Left" Grid="true" Minimum="0"/>
<ext:CategoryAxis Position="Bottom" Fields="Period_Date">
<Label Font="9px Arial">
<Rotate Degrees="315" />
<Renderer Handler="return Ext.util.Format.date(value,'M d,Y');" />
</Label>
</ext:CategoryAxis>
</Axes>
<Series>
<ext:ColumnSeries
Axis="Bottom"
Highlight="true"
XField="Period_Date"
YField="ABC FUND LP,SP500,SP501">
<Style Fill="#456d9f" />
<HighlightConfig Fill="#a2b5ca" />
</ext:ColumnSeries>
</Series>
</ext:Chart>--%>
</Items>
</ext:Panel>
</Items>
</ext:TabPanel>
Posting Permissions
| Frameworks and Tools for .NET Developers