Last active
May 17, 2018 13:24
-
-
Save maracuja/ba588e73de9981e1ab4ee3d1e0398723 to your computer and use it in GitHub Desktop.
Get financials from FAME
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
''' | |
Questions I want answered. | |
#1 I can get the 80k~ entities out of FAME | |
- try with one of Marya's searches √ | |
#2 I can ask for the data in the format that I want per company | |
- try with a complex list format | |
''' | |
'''This is #1''' | |
from suds.client import Client | |
client = Client("https://webservices.bvdep.com/Fame/remoteaccess.asmx?WSDL") | |
session_handle = client.service.Open('', '') | |
strategy_xml = '<Strategy Formula="(1&gt;0)*2*3" Path="Current"><Context /><Steps><Step UniqueId="DNFameNeo:bvd.FameNeo.Search.Companies.SearchStepDictionary+ActiveCompanies"><Parameters><Parameter Id="AndParameter" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="IdParameter" Type="ParameterId" Multiple="True" HasSelection="True"><Action Type="SingleAdd" Array="row_comma_separated" ItemId="Active;UnknownSituation" /></Parameter></Parameters><Comments /></Step><Step UniqueId="DNFameNeo:bvd.FameNeo.Search.Companies.SearchStepDictionary+MatrixSearch"><Strategy NeedsFromEvaluation="false" Path="Current.{bbd8cf0e-84c1-4880-a4d8-21895a407ce5}1"><Steps><Step UniqueId="DNFameNeo:bvd.FameNeo.Search.Companies.SearchStepDictionary+MatrixSearch&gt;Prop_MatrixValueSearchInstance"><Parameters><Parameter Id="To" Type="ParameterIntegral" HasSelection="False" /><Parameter Id="RangeEstimates" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="OtherPresentationLine" Type="ParameterId" HasSelection="False" /><Parameter Id="TargetValue" Type="ParameterDecimal" HasSelection="False" Unit="0" /><Parameter Id="PredefinedMinMax" Type="ParameterId" Multiple="True" HasSelection="False" /><Parameter Id="Min" Type="ParameterDecimal" HasSelection="False" Unit="3" /><Parameter Id="Variation" Type="ParameterId" HasSelection="True" Value="Value" /><Parameter Id="ExcludeMin" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="Max" Type="ParameterDecimal" HasSelection="False" Unit="3" /><Parameter Id="FilterForSegmentation" Type="ParameterBoolean" HasSelection="False" /><Parameter Id="Currency" Type="ParameterCurrency" HasSelection="True" Value="GBP" /><Parameter Id="BaseFilter" Type="ParameterSearchStrategy" HasSelection="True" HasNonSerializedStrategy="true" /><Parameter Id="ValueVariations" Type="ParameterId" HasSelection="True" Value="values" /><Parameter Id="Model" Type="ParameterId" HasSelection="False" /><Parameter Id="ExcludeMax" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="YearsCombine" Type="ParameterId" HasSelection="True" Value="AtLeastOneYear" /><Parameter Id="IncludeNas" Type="ParameterBoolean" HasSelection="False" /><Parameter Id="Periodicity" Type="ParameterFreeText" HasSelection="True" Value="year" /><Parameter Id="From" Type="ParameterIntegral" HasSelection="False" /><Parameter Id="ChanginSigne" Type="ParameterId" HasSelection="True" Value="negative to positive" /><Parameter Id="Years" Type="ParameterId" Multiple="True" HasSelection="True" SpecificDefault="0"><Action Type="SingleAdd" Array="row_comma_separated" ItemId="year-0;year-1;year-2" /></Parameter><Parameter Id="UseMostRecentFigure" Type="ParameterId" HasSelection="False" /><Parameter Id="AllWithAKnownValue" Type="ParameterBoolean" HasSelection="False" /><Parameter Id="TrendSigne" Type="ParameterId" HasSelection="True" Value="Positive" /><Parameter Id="Estimates" Type="ParameterBoolean" HasSelection="True" SpecificDefault="False" Value="False" /><Parameter Id="Top" Type="ParameterId" HasSelection="True" Value="2147483647" /><Parameter Id="PresentationLine" Type="ParameterPresentationLine" HasSelection="True" Value="U.EBTA" PresentationLineId="PROFIT_LOSS.EBTA" /><Parameter Id="Deciles" Type="ParameterId" Multiple="True" HasSelection="False" /><Parameter Id="Quartiles" Type="ParameterId" Multiple="True" HasSelection="False" /></Parameters><Comments /></Step></Steps></Strategy><Comments><Comment><Key>__CREATIONTIME__</Key><Text>17/05/2018 2:35:37 PM</Text></Comment></Comments></Step><Step UniqueId="DNFameNeo:bvd.FameNeo.Search.Companies.SearchStepDictionary+MatrixSearch"><Strategy Path="Current.{7a300fe3-f457-4795-9f3b-245c4a103e4d}12"><Steps><Step UniqueId="DNFameNeo:bvd.FameNeo.Search.Companies.SearchStepDictionary+MatrixSearch&gt;Prop_MatrixValueSearchInstance"><Parameters><Parameter Id="To" Type="ParameterIntegral" HasSelection="False" /><Parameter Id="RangeEstimates" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="OtherPresentationLine" Type="ParameterId" HasSelection="False" /><Parameter Id="TargetValue" Type="ParameterDecimal" HasSelection="False" Unit="0" /><Parameter Id="PredefinedMinMax" Type="ParameterId" Multiple="True" HasSelection="False" /><Parameter Id="Min" Type="ParameterDecimal" HasSelection="True" Value="0" Unit="3" /><Parameter Id="Variation" Type="ParameterId" HasSelection="True" Value="Value" /><Parameter Id="ExcludeMin" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="Max" Type="ParameterDecimal" HasSelection="True" Value="100000000" Unit="3" /><Parameter Id="FilterForSegmentation" Type="ParameterBoolean" HasSelection="False" /><Parameter Id="Currency" Type="ParameterCurrency" HasSelection="True" Value="GBP" /><Parameter Id="BaseFilter" Type="ParameterSearchStrategy" HasSelection="False" /><Parameter Id="ValueVariations" Type="ParameterId" HasSelection="True" Value="values" /><Parameter Id="Model" Type="ParameterId" HasSelection="False" /><Parameter Id="ExcludeMax" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Id="YearsCombine" Type="ParameterId" HasSelection="True" Value="AtLeastOneYear" /><Parameter Id="IncludeNas" Type="ParameterBoolean" HasSelection="False" /><Parameter Id="Periodicity" Type="ParameterFreeText" HasSelection="True" Value="year" /><Parameter Id="From" Type="ParameterIntegral" HasSelection="False" /><Parameter Id="ChanginSigne" Type="ParameterId" HasSelection="True" Value="negative to positive" /><Parameter Id="Years" Type="ParameterId" Multiple="True" HasSelection="True" SpecificDefault="0"><Action Type="SingleAdd" Array="row_comma_separated" ItemId="year-0;year-1;year-2;year-3" /></Parameter><Parameter Id="UseMostRecentFigure" Type="ParameterId" HasSelection="False" /><Parameter Id="AllWithAKnownValue" Type="ParameterBoolean" HasSelection="False" /><Parameter Id="TrendSigne" Type="ParameterId" HasSelection="True" Value="Positive" /><Parameter Id="Estimates" Type="ParameterBoolean" HasSelection="True" SpecificDefault="False" Value="False" /><Parameter Id="Top" Type="ParameterId" HasSelection="False" /><Parameter Id="PresentationLine" Type="ParameterPresentationLine" HasSelection="True" Value="U.TURN" PresentationLineId="PROFIT_LOSS.TURN" /><Parameter Id="Deciles" Type="ParameterId" Multiple="True" HasSelection="False" /><Parameter Id="Quartiles" Type="ParameterId" Multiple="True" HasSelection="False" /></Parameters><Comments /></Step></Steps></Strategy><Comments><Comment><Key>__CREATIONTIME__</Key><Text>17/05/2018 2:37:03 PM</Text></Comment></Comments></Step><Step UniqueId="DNFameNeo:bvd.FameNeo.Search.Companies.SearchStepDictionary+RegionPostcodeCity"><Parameters><Parameter Id="AddressType" Type="ParameterId" Multiple="True" HasSelection="True"><Action Type="SingleAdd" Array="row_comma_separated" ItemId="Primary;Registered" /></Parameter><Parameter Key="FINDALPHA.FreeText" Id="FreeText" Type="ParameterFreeText" HasSelection="False" /><Parameter Id="IdParameter" Type="ParameterId" Multiple="True" HasSelection="True"><Action Type="SingleAdd" ItemId="01" /><Action Type="SingleAdd" ItemId="02" /><Action Type="SingleAdd" ItemId="03" /><Action Type="SingleAdd" ItemId="04" /><Action Type="SingleAdd" ItemId="05" /><Action Type="SingleAdd" ItemId="06" /><Action Type="SingleAdd" ItemId="07" /><Action Type="SingleAdd" ItemId="09" /><Action Type="SingleAdd" ItemId="10" /><Action Type="SingleAdd" ItemId="11" /><Action Type="SingleAdd" ItemId="12" /><Action Type="SingleAdd" ItemId="13" /><Action Type="SingleAdd" ItemId="14" /></Parameter><Parameter Key="FINDALPHA.WholeWord" Id="WholeWord" Type="ParameterBoolean" HasSelection="True" Value="False" /><Parameter Key="FINDALPHA.FirstWord" Id="FirstWord" Type="ParameterBoolean" HasSelection="True" Value="False" /></Parameters><Comments><Comment><Key>__CREATIONTIME__</Key><Text>17/05/2018 2:38:43 PM</Text></Comment></Comments></Step></Steps></Strategy>' | |
strategy_type = 'RemoteAccessStrategy' | |
loaded_strategy = client.service.LoadStrategyFromXml(session_handle, strategy_xml, strategy_type) | |
query = "SELECT NAME, REGISTR, RO_ADDRX, INCORDATE FROM RemoteAccess.U" | |
results = client.service.GetData(session_handle, loaded_strategy, query, 0, 5, 'XML') | |
print results | |
'''This is #2''' | |
detailed_query = "DEFINE P1 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=0;],P2 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=0;],P3 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=1;],P4 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=2;],P5 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=3;],P6 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=4;],P7 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=5;],P8 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=6;],P9 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=7;],P10 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=8;],P11 AS [Parameters.Currency=GBP;Parameters.Units=3;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=9;],P12 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=1;],P13 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=2;],P14 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=3;],P15 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=4;],P16 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=5;],P17 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=6;],P18 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=7;],P19 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=8;],P20 AS [Parameters.Currency=SESSION;Parameters.Units=0;Parameters.DimensionSelName=NrOfYears;NrOfYears.Index=9;]; SELECT LINE LEGAL_ACCOUNT_INFO.NAME AS NAME, LINE CONTACT_DETAILS.RO_FPOST AS RO_FPOST, LINE IDENTIFICATION_NUMBERS.REGISTR AS REGISTR, LINE ACTIVITIES.SIC_CODE2007 AS SIC_CODE2007, LINE LEGAL_ACCOUNT_INFO.LY AS LY, LINE SIZE_MAIN_ACTIVITY.TRUN USING P1 AS TURN, LINE SIZE_MAIN_ACTIVITY.PR10 USING P2 AS PR10, LINE PROFIT_LOSS.TURN USING P1 AS TURN_1, LINE PROFIT_LOSS.TURN USING P3 AS TURN_2, LINE PROFIT_LOSS.TURN USING P4 AS TURN_3, LINE PROFIT_LOSS.TURN USING P5 AS TURN_4, LINE PROFIT_LOSS.TURN USING P6 AS TURN_5, LINE PROFIT_LOSS.TURN USING P7 AS TURN_6, LINE PROFIT_LOSS.TURN USING P8 AS TURN_7, LINE PROFIT_LOSS.TURN USING P9 AS TURN_8, LINE PROFIT_LOSS.TURN USING P10 AS TURN_9, LINE PROFIT_LOSS.TURN USING P11 AS TURN_10, LINE PROFIT_LOSS.UKTO USING P1 AS UKTO, LINE PROFIT_LOSS.UKTO USING P3 AS UKTO_1, LINE PROFIT_LOSS.UKTO USING P4 AS UKTO_2, LINE PROFIT_LOSS.UKTO USING P5 AS UKTO_3, LINE PROFIT_LOSS.UKTO USING P6 AS UKTO_4, LINE PROFIT_LOSS.UKTO USING P7 AS UKTO_5, LINE PROFIT_LOSS.UKTO USING P8 AS UKTO_6, LINE PROFIT_LOSS.UKTO USING P9 AS UKTO_7, LINE PROFIT_LOSS.UKTO USING P10 AS UKTO_8, LINE PROFIT_LOSS.UKTO USING P11 AS UKTO_9, LINE PROFIT_LOSS.EXTO USING P1 AS EXTO, LINE PROFIT_LOSS.EXTO USING P3 AS EXTO_1, LINE PROFIT_LOSS.EXTO USING P4 AS EXTO_2, LINE PROFIT_LOSS.EXTO USING P5 AS EXTO_3, LINE PROFIT_LOSS.EXTO USING P6 AS EXTO_4, LINE PROFIT_LOSS.EXTO USING P7 AS EXTO_5, LINE PROFIT_LOSS.EXTO USING P8 AS EXTO_6, LINE PROFIT_LOSS.EXTO USING P9 AS EXTO_7, LINE PROFIT_LOSS.EXTO USING P10 AS EXTO_8, LINE PROFIT_LOSS.EXTO USING P11 AS EXTO_9, LINE PROFIT_LOSS.COST USING P1 AS COST, LINE PROFIT_LOSS.COST USING P3 AS COST_1, LINE PROFIT_LOSS.COST USING P4 AS COST_2, LINE PROFIT_LOSS.COST USING P5 AS COST_3, LINE PROFIT_LOSS.COST USING P6 AS COST_4, LINE PROFIT_LOSS.COST USING P7 AS COST_5, LINE PROFIT_LOSS.COST USING P8 AS COST_6, LINE PROFIT_LOSS.COST USING P9 AS COST_7, LINE PROFIT_LOSS.COST USING P10 AS COST_8, LINE PROFIT_LOSS.COST USING P11 AS COST_9, LINE PROFIT_LOSS.IF20 USING P1 AS IF20, LINE PROFIT_LOSS.IF20 USING P3 AS IF20_1, LINE PROFIT_LOSS.IF20 USING P4 AS IF20_2, LINE PROFIT_LOSS.IF20 USING P5 AS IF20_3, LINE PROFIT_LOSS.IF20 USING P6 AS IF20_4, LINE PROFIT_LOSS.IF20 USING P7 AS IF20_5, LINE PROFIT_LOSS.IF20 USING P8 AS IF20_6, LINE PROFIT_LOSS.IF20 USING P9 AS IF20_7, LINE PROFIT_LOSS.IF20 USING P10 AS IF20_8, LINE PROFIT_LOSS.IF20 USING P11 AS IF20_9, LINE PROFIT_LOSS.IF01 USING P1 AS IF01, LINE PROFIT_LOSS.IF01 USING P3 AS IF01_1, LINE PROFIT_LOSS.IF01 USING P4 AS IF01_2, LINE PROFIT_LOSS.IF01 USING P5 AS IF01_3, LINE PROFIT_LOSS.IF01 USING P6 AS IF01_4, LINE PROFIT_LOSS.IF01 USING P7 AS IF01_5, LINE PROFIT_LOSS.IF01 USING P8 AS IF01_6, LINE PROFIT_LOSS.IF01 USING P9 AS IF01_7, LINE PROFIT_LOSS.IF01 USING P10 AS IF01_8, LINE PROFIT_LOSS.IF01 USING P11 AS IF01_9, LINE PROFIT_LOSS.GRPR USING P1 AS GRPR, LINE PROFIT_LOSS.GRPR USING P3 AS GRPR_1, LINE PROFIT_LOSS.GRPR USING P4 AS GRPR_2, LINE PROFIT_LOSS.GRPR USING P5 AS GRPR_3, LINE PROFIT_LOSS.GRPR USING P6 AS GRPR_4, LINE PROFIT_LOSS.GRPR USING P7 AS GRPR_5, LINE PROFIT_LOSS.GRPR USING P8 AS GRPR_6, LINE PROFIT_LOSS.GRPR USING P9 AS GRPR_7, LINE PROFIT_LOSS.GRPR USING P10 AS GRPR_8, LINE PROFIT_LOSS.GRPR USING P11 AS GRPR_9, LINE PROFIT_LOSS.IFC0 USING P1 AS IFC0, LINE PROFIT_LOSS.IFC0 USING P3 AS IFC0_1, LINE PROFIT_LOSS.IFC0 USING P4 AS IFC0_2, LINE PROFIT_LOSS.IFC0 USING P5 AS IFC0_3, LINE PROFIT_LOSS.IFC0 USING P6 AS IFC0_4, LINE PROFIT_LOSS.IFC0 USING P7 AS IFC0_5, LINE PROFIT_LOSS.IFC0 USING P8 AS IFC0_6, LINE PROFIT_LOSS.IFC0 USING P9 AS IFC0_7, LINE PROFIT_LOSS.IFC0 USING P10 AS IFC0_8, LINE PROFIT_LOSS.IFC0 USING P11 AS IFC0_9, LINE PROFIT_LOSS.IF02 USING P1 AS IF02, LINE PROFIT_LOSS.IF02 USING P3 AS IF02_1, LINE PROFIT_LOSS.IF02 USING P4 AS IF02_2, LINE PROFIT_LOSS.IF02 USING P5 AS IF02_3, LINE PROFIT_LOSS.IF02 USING P6 AS IF02_4, LINE PROFIT_LOSS.IF02 USING P7 AS IF02_5, LINE PROFIT_LOSS.IF02 USING P8 AS IF02_6, LINE PROFIT_LOSS.IF02 USING P9 AS IF02_7, LINE PROFIT_LOSS.IF02 USING P10 AS IF02_8, LINE PROFIT_LOSS.IF02 USING P11 AS IF02_9, LINE PROFIT_LOSS.IF03 USING P1 AS IF03, LINE PROFIT_LOSS.IF03 USING P3 AS IF03_1, LINE PROFIT_LOSS.IF03 USING P4 AS IF03_2, LINE PROFIT_LOSS.IF03 USING P5 AS IF03_3, LINE PROFIT_LOSS.IF03 USING P6 AS IF03_4, LINE PROFIT_LOSS.IF03 USING P7 AS IF03_5, LINE PROFIT_LOSS.IF03 USING P8 AS IF03_6, LINE PROFIT_LOSS.IF03 USING P9 AS IF03_7, LINE PROFIT_LOSS.IF03 USING P10 AS IF03_8, LINE PROFIT_LOSS.IF03 USING P11 AS IF03_9, LINE PROFIT_LOSS.OPPR USING P1 AS OPPR, LINE PROFIT_LOSS.OPPR USING P3 AS OPPR_1, LINE PROFIT_LOSS.OPPR USING P4 AS OPPR_2, LINE PROFIT_LOSS.OPPR USING P5 AS OPPR_3, LINE PROFIT_LOSS.OPPR USING P6 AS OPPR_4, LINE PROFIT_LOSS.OPPR USING P7 AS OPPR_5, LINE PROFIT_LOSS.OPPR USING P8 AS OPPR_6, LINE PROFIT_LOSS.OPPR USING P9 AS OPPR_7, LINE PROFIT_LOSS.OPPR USING P10 AS OPPR_8, LINE PROFIT_LOSS.OPPR USING P11 AS OPPR_9, LINE PROFIT_LOSS.OTHI USING P1 AS OTHI, LINE PROFIT_LOSS.OTHI USING P3 AS OTHI_1, LINE PROFIT_LOSS.OTHI USING P4 AS OTHI_2, LINE PROFIT_LOSS.OTHI USING P5 AS OTHI_3, LINE PROFIT_LOSS.OTHI USING P6 AS OTHI_4, LINE PROFIT_LOSS.OTHI USING P7 AS OTHI_5, LINE PROFIT_LOSS.OTHI USING P8 AS OTHI_6, LINE PROFIT_LOSS.OTHI USING P9 AS OTHI_7, LINE PROFIT_LOSS.OTHI USING P10 AS OTHI_8, LINE PROFIT_LOSS.OTHI USING P11 AS OTHI_9, LINE PROFIT_LOSS.IF21 USING P1 AS IF21, LINE PROFIT_LOSS.IF21 USING P3 AS IF21_1, LINE PROFIT_LOSS.IF21 USING P4 AS IF21_2, LINE PROFIT_LOSS.IF21 USING P5 AS IF21_3, LINE PROFIT_LOSS.IF21 USING P6 AS IF21_4, LINE PROFIT_LOSS.IF21 USING P7 AS IF21_5, LINE PROFIT_LOSS.IF21 USING P8 AS IF21_6, LINE PROFIT_LOSS.IF21 USING P9 AS IF21_7, LINE PROFIT_LOSS.IF21 USING P10 AS IF21_8, LINE PROFIT_LOSS.IF21 USING P11 AS IF21_9, LINE PROFIT_LOSS.EXIT USING P1 AS EXIT, LINE PROFIT_LOSS.EXIT USING P3 AS EXIT_1, LINE PROFIT_LOSS.EXIT USING P4 AS EXIT_2, LINE PROFIT_LOSS.EXIT USING P5 AS EXIT_3, LINE PROFIT_LOSS.EXIT USING P6 AS EXIT_4, LINE PROFIT_LOSS.EXIT USING P7 AS EXIT_5, LINE PROFIT_LOSS.EXIT USING P8 AS EXIT_6, LINE PROFIT_LOSS.EXIT USING P9 AS EXIT_7, LINE PROFIT_LOSS.EXIT USING P10 AS EXIT_8, LINE PROFIT_LOSS.EXIT USING P11 AS EXIT_9, LINE PROFIT_LOSS.IF26 USING P1 AS IF26, LINE PROFIT_LOSS.IF26 USING P3 AS IF26_1, LINE PROFIT_LOSS.IF26 USING P4 AS IF26_2, LINE PROFIT_LOSS.IF26 USING P5 AS IF26_3, LINE PROFIT_LOSS.IF26 USING P6 AS IF26_4, LINE PROFIT_LOSS.IF26 USING P7 AS IF26_5, LINE PROFIT_LOSS.IF26 USING P8 AS IF26_6, LINE PROFIT_LOSS.IF26 USING P9 AS IF26_7, LINE PROFIT_LOSS.IF26 USING P10 AS IF26_8, LINE PROFIT_LOSS.IF26 USING P11 AS IF26_9, LINE PROFIT_LOSS.IF27 USING P1 AS IF27, LINE PROFIT_LOSS.IF27 USING P3 AS IF27_1, LINE PROFIT_LOSS.IF27 USING P4 AS IF27_2, LINE PROFIT_LOSS.IF27 USING P5 AS IF27_3, LINE PROFIT_LOSS.IF27 USING P6 AS IF27_4, LINE PROFIT_LOSS.IF27 USING P7 AS IF27_5, LINE PROFIT_LOSS.IF27 USING P8 AS IF27_6, LINE PROFIT_LOSS.IF27 USING P9 AS IF27_7, LINE PROFIT_LOSS.IF27 USING P10 AS IF27_8, LINE PROFIT_LOSS.IF27 USING P11 AS IF27_9, LINE PROFIT_LOSS.IF28 USING P1 AS IF28, LINE PROFIT_LOSS.IF28 USING P3 AS IF28_1, LINE PROFIT_LOSS.IF28 USING P4 AS IF28_2, LINE PROFIT_LOSS.IF28 USING P5 AS IF28_3, LINE PROFIT_LOSS.IF28 USING P6 AS IF28_4, LINE PROFIT_LOSS.IF28 USING P7 AS IF28_5, LINE PROFIT_LOSS.IF28 USING P8 AS IF28_6, LINE PROFIT_LOSS.IF28 USING P9 AS IF28_7, LINE PROFIT_LOSS.IF28 USING P10 AS IF28_8, LINE PROFIT_LOSS.IF28 USING P11 AS IF28_9, LINE PROFIT_LOSS.IF29 USING P1 AS IF29, LINE PROFIT_LOSS.IF29 USING P3 AS IF29_1, LINE PROFIT_LOSS.IF29 USING P4 AS IF29_2, LINE PROFIT_LOSS.IF29 USING P5 AS IF29_3, LINE PROFIT_LOSS.IF29 USING P6 AS IF29_4, LINE PROFIT_LOSS.IF29 USING P7 AS IF29_5, LINE PROFIT_LOSS.IF29 USING P8 AS IF29_6, LINE PROFIT_LOSS.IF29 USING P9 AS IF29_7, LINE PROFIT_LOSS.IF29 USING P10 AS IF29_8, LINE PROFIT_LOSS.IF29 USING P11 AS IF29_9, LINE PROFIT_LOSS.PRBI USING P1 AS PRBI, LINE PROFIT_LOSS.PRBI USING P3 AS PRBI_1, LINE PROFIT_LOSS.PRBI USING P4 AS PRBI_2, LINE PROFIT_LOSS.PRBI USING P5 AS PRBI_3, LINE PROFIT_LOSS.PRBI USING P6 AS PRBI_4, LINE PROFIT_LOSS.PRBI USING P7 AS PRBI_5, LINE PROFIT_LOSS.PRBI USING P8 AS PRBI_6, LINE PROFIT_LOSS.PRBI USING P9 AS PRBI_7, LINE PROFIT_LOSS.PRBI USING P10 AS PRBI_8, LINE PROFIT_LOSS.PRBI USING P11 AS PRBI_9, LINE PROFIT_LOSS.IF04 USING P1 AS IF04, LINE PROFIT_LOSS.IF04 USING P3 AS IF04_1, LINE PROFIT_LOSS.IF04 USING P4 AS IF04_2, LINE PROFIT_LOSS.IF04 USING P5 AS IF04_3, LINE PROFIT_LOSS.IF04 USING P6 AS IF04_4, LINE PROFIT_LOSS.IF04 USING P7 AS IF04_5, LINE PROFIT_LOSS.IF04 USING P8 AS IF04_6, LINE PROFIT_LOSS.IF04 USING P9 AS IF04_7, LINE PROFIT_LOSS.IF04 USING P10 AS IF04_8, LINE PROFIT_LOSS.IF04 USING P11 AS IF04_9, LINE PROFIT_LOSS.INTE USING P1 AS INTE, LINE PROFIT_LOSS.INTE USING P3 AS INTE_1, LINE PROFIT_LOSS.INTE USING P4 AS INTE_2, LINE PROFIT_LOSS.INTE USING P5 AS INTE_3, LINE PROFIT_LOSS.INTE USING P6 AS INTE_4, LINE PROFIT_LOSS.INTE USING P7 AS INTE_5, LINE PROFIT_LOSS.INTE USING P8 AS INTE_6, LINE PROFIT_LOSS.INTE USING P9 AS INTE_7, LINE PROFIT_LOSS.INTE USING P10 AS INTE_8, LINE PROFIT_LOSS.INTE USING P11 AS INTE_9, LINE PROFIT_LOSS.IF16 USING P1 AS IF16, LINE PROFIT_LOSS.IF16 USING P3 AS IF16_1, LINE PROFIT_LOSS.IF16 USING P4 AS IF16_2, LINE PROFIT_LOSS.IF16 USING P5 AS IF16_3, LINE PROFIT_LOSS.IF16 USING P6 AS IF16_4, LINE PROFIT_LOSS.IF16 USING P7 AS IF16_5, LINE PROFIT_LOSS.IF16 USING P8 AS IF16_6, LINE PROFIT_LOSS.IF16 USING P9 AS IF16_7, LINE PROFIT_LOSS.IF16 USING P10 AS IF16_8, LINE PROFIT_LOSS.IF16 USING P11 AS IF16_9, LINE PROFIT_LOSS.IF17 USING P1 AS IF17, LINE PROFIT_LOSS.IF17 USING P3 AS IF17_1, LINE PROFIT_LOSS.IF17 USING P4 AS IF17_2, LINE PROFIT_LOSS.IF17 USING P5 AS IF17_3, LINE PROFIT_LOSS.IF17 USING P6 AS IF17_4, LINE PROFIT_LOSS.IF17 USING P7 AS IF17_5, LINE PROFIT_LOSS.IF17 USING P8 AS IF17_6, LINE PROFIT_LOSS.IF17 USING P9 AS IF17_7, LINE PROFIT_LOSS.IF17 USING P10 AS IF17_8, LINE PROFIT_LOSS.IF17 USING P11 AS IF17_9, LINE PROFIT_LOSS.IF18 USING P1 AS IF18, LINE PROFIT_LOSS.IF18 USING P3 AS IF18_1, LINE PROFIT_LOSS.IF18 USING P4 AS IF18_2, LINE PROFIT_LOSS.IF18 USING P5 AS IF18_3, LINE PROFIT_LOSS.IF18 USING P6 AS IF18_4, LINE PROFIT_LOSS.IF18 USING P7 AS IF18_5, LINE PROFIT_LOSS.IF18 USING P8 AS IF18_6, LINE PROFIT_LOSS.IF18 USING P9 AS IF18_7, LINE PROFIT_LOSS.IF18 USING P10 AS IF18_8, LINE PROFIT_LOSS.IF18 USING P11 AS IF18_9, LINE PROFIT_LOSS.IF19 USING P1 AS IF19, LINE PROFIT_LOSS.IF19 USING P3 AS IF19_1, LINE PROFIT_LOSS.IF19 USING P4 AS IF19_2, LINE PROFIT_LOSS.IF19 USING P5 AS IF19_3, LINE PROFIT_LOSS.IF19 USING P6 AS IF19_4, LINE PROFIT_LOSS.IF19 USING P7 AS IF19_5, LINE PROFIT_LOSS.IF19 USING P8 AS IF19_6, LINE PROFIT_LOSS.IF19 USING P9 AS IF19_7, LINE PROFIT_LOSS.IF19 USING P10 AS IF19_8, LINE PROFIT_LOSS.IF19 USING P11 AS IF19_9, LINE PROFIT_LOSS.IF30 USING P1 AS IF30, LINE PROFIT_LOSS.IF30 USING P3 AS IF30_1, LINE PROFIT_LOSS.IF30 USING P4 AS IF30_2, LINE PROFIT_LOSS.IF30 USING P5 AS IF30_3, LINE PROFIT_LOSS.IF30 USING P6 AS IF30_4, LINE PROFIT_LOSS.IF30 USING P7 AS IF30_5, LINE PROFIT_LOSS.IF30 USING P8 AS IF30_6, LINE PROFIT_LOSS.IF30 USING P9 AS IF30_7, LINE PROFIT_LOSS.IF30 USING P10 AS IF30_8, LINE PROFIT_LOSS.IF30 USING P11 AS IF30_9, LINE PROFIT_LOSS.PRBT USING P1 AS PRBT, LINE PROFIT_LOSS.PRBT USING P3 AS PRBT_1, LINE PROFIT_LOSS.PRBT USING P4 AS PRBT_2, LINE PROFIT_LOSS.PRBT USING P5 AS PRBT_3, LINE PROFIT_LOSS.PRBT USING P6 AS PRBT_4, LINE PROFIT_LOSS.PRBT USING P7 AS PRBT_5, LINE PROFIT_LOSS.PRBT USING P8 AS PRBT_6, LINE PROFIT_LOSS.PRBT USING P9 AS PRBT_7, LINE PROFIT_LOSS.PRBT USING P10 AS PRBT_8, LINE PROFIT_LOSS.PRBT USING P11 AS PRBT_9, LINE PROFIT_LOSS.TAXA USING P1 AS TAXA, LINE PROFIT_LOSS.TAXA USING P3 AS TAXA_1, LINE PROFIT_LOSS.TAXA USING P4 AS TAXA_2, LINE PROFIT_LOSS.TAXA USING P5 AS TAXA_3, LINE PROFIT_LOSS.TAXA USING P6 AS TAXA_4, LINE PROFIT_LOSS.TAXA USING P7 AS TAXA_5, LINE PROFIT_LOSS.TAXA USING P8 AS TAXA_6, LINE PROFIT_LOSS.TAXA USING P9 AS TAXA_7, LINE PROFIT_LOSS.TAXA USING P10 AS TAXA_8, LINE PROFIT_LOSS.TAXA USING P11 AS TAXA_9, LINE PROFIT_LOSS.PRAT USING P1 AS PRAT, LINE PROFIT_LOSS.PRAT USING P3 AS PRAT_1, LINE PROFIT_LOSS.PRAT USING P4 AS PRAT_2, LINE PROFIT_LOSS.PRAT USING P5 AS PRAT_3, LINE PROFIT_LOSS.PRAT USING P6 AS PRAT_4, LINE PROFIT_LOSS.PRAT USING P7 AS PRAT_5, LINE PROFIT_LOSS.PRAT USING P8 AS PRAT_6, LINE PROFIT_LOSS.PRAT USING P9 AS PRAT_7, LINE PROFIT_LOSS.PRAT USING P10 AS PRAT_8, LINE PROFIT_LOSS.PRAT USING P11 AS PRAT_9, LINE PROFIT_LOSS.EXTR USING P1 AS EXTR, LINE PROFIT_LOSS.EXTR USING P3 AS EXTR_1, LINE PROFIT_LOSS.EXTR USING P4 AS EXTR_2, LINE PROFIT_LOSS.EXTR USING P5 AS EXTR_3, LINE PROFIT_LOSS.EXTR USING P6 AS EXTR_4, LINE PROFIT_LOSS.EXTR USING P7 AS EXTR_5, LINE PROFIT_LOSS.EXTR USING P8 AS EXTR_6, LINE PROFIT_LOSS.EXTR USING P9 AS EXTR_7, LINE PROFIT_LOSS.EXTR USING P10 AS EXTR_8, LINE PROFIT_LOSS.EXTR USING P11 AS EXTR_9, LINE PROFIT_LOSS.MINT USING P1 AS MINT, LINE PROFIT_LOSS.MINT USING P3 AS MINT_1, LINE PROFIT_LOSS.MINT USING P4 AS MINT_2, LINE PROFIT_LOSS.MINT USING P5 AS MINT_3, LINE PROFIT_LOSS.MINT USING P6 AS MINT_4, LINE PROFIT_LOSS.MINT USING P7 AS MINT_5, LINE PROFIT_LOSS.MINT USING P8 AS MINT_6, LINE PROFIT_LOSS.MINT USING P9 AS MINT_7, LINE PROFIT_LOSS.MINT USING P10 AS MINT_8, LINE PROFIT_LOSS.MINT USING P11 AS MINT_9, LINE PROFIT_LOSS.PRPE USING P1 AS PRPE, LINE PROFIT_LOSS.PRPE USING P3 AS PRPE_1, LINE PROFIT_LOSS.PRPE USING P4 AS PRPE_2, LINE PROFIT_LOSS.PRPE USING P5 AS PRPE_3, LINE PROFIT_LOSS.PRPE USING P6 AS PRPE_4, LINE PROFIT_LOSS.PRPE USING P7 AS PRPE_5, LINE PROFIT_LOSS.PRPE USING P8 AS PRPE_6, LINE PROFIT_LOSS.PRPE USING P9 AS PRPE_7, LINE PROFIT_LOSS.PRPE USING P10 AS PRPE_8, LINE PROFIT_LOSS.PRPE USING P11 AS PRPE_9, LINE PROFIT_LOSS.DIVI USING P1 AS DIVI, LINE PROFIT_LOSS.DIVI USING P3 AS DIVI_1, LINE PROFIT_LOSS.DIVI USING P4 AS DIVI_2, LINE PROFIT_LOSS.DIVI USING P5 AS DIVI_3, LINE PROFIT_LOSS.DIVI USING P6 AS DIVI_4, LINE PROFIT_LOSS.DIVI USING P7 AS DIVI_5, LINE PROFIT_LOSS.DIVI USING P8 AS DIVI_6, LINE PROFIT_LOSS.DIVI USING P9 AS DIVI_7, LINE PROFIT_LOSS.DIVI USING P10 AS DIVI_8, LINE PROFIT_LOSS.DIVI USING P11 AS DIVI_9, LINE PROFIT_LOSS.RETP USING P1 AS RETP, LINE PROFIT_LOSS.RETP USING P3 AS RETP_1, LINE PROFIT_LOSS.RETP USING P4 AS RETP_2, LINE PROFIT_LOSS.RETP USING P5 AS RETP_3, LINE PROFIT_LOSS.RETP USING P6 AS RETP_4, LINE PROFIT_LOSS.RETP USING P7 AS RETP_5, LINE PROFIT_LOSS.RETP USING P8 AS RETP_6, LINE PROFIT_LOSS.RETP USING P9 AS RETP_7, LINE PROFIT_LOSS.RETP USING P10 AS RETP_8, LINE PROFIT_LOSS.RETP USING P11 AS RETP_9, LINE PROFIT_LOSS.DEPR USING P1 AS DEPR, LINE PROFIT_LOSS.DEPR USING P3 AS DEPR_1, LINE PROFIT_LOSS.DEPR USING P4 AS DEPR_2, LINE PROFIT_LOSS.DEPR USING P5 AS DEPR_3, LINE PROFIT_LOSS.DEPR USING P6 AS DEPR_4, LINE PROFIT_LOSS.DEPR USING P7 AS DEPR_5, LINE PROFIT_LOSS.DEPR USING P8 AS DEPR_6, LINE PROFIT_LOSS.DEPR USING P9 AS DEPR_7, LINE PROFIT_LOSS.DEPR USING P10 AS DEPR_8, LINE PROFIT_LOSS.DEPR USING P11 AS DEPR_9, LINE PROFIT_LOSS.IF31 USING P1 AS IF31, LINE PROFIT_LOSS.IF31 USING P3 AS IF31_1, LINE PROFIT_LOSS.IF31 USING P4 AS IF31_2, LINE PROFIT_LOSS.IF31 USING P5 AS IF31_3, LINE PROFIT_LOSS.IF31 USING P6 AS IF31_4, LINE PROFIT_LOSS.IF31 USING P7 AS IF31_5, LINE PROFIT_LOSS.IF31 USING P8 AS IF31_6, LINE PROFIT_LOSS.IF31 USING P9 AS IF31_7, LINE PROFIT_LOSS.IF31 USING P10 AS IF31_8, LINE PROFIT_LOSS.IF31 USING P11 AS IF31_9, LINE PROFIT_LOSS.IF32 USING P1 AS IF32, LINE PROFIT_LOSS.IF32 USING P3 AS IF32_1, LINE PROFIT_LOSS.IF32 USING P4 AS IF32_2, LINE PROFIT_LOSS.IF32 USING P5 AS IF32_3, LINE PROFIT_LOSS.IF32 USING P6 AS IF32_4, LINE PROFIT_LOSS.IF32 USING P7 AS IF32_5, LINE PROFIT_LOSS.IF32 USING P8 AS IF32_6, LINE PROFIT_LOSS.IF32 USING P9 AS IF32_7, LINE PROFIT_LOSS.IF32 USING P10 AS IF32_8, LINE PROFIT_LOSS.IF32 USING P11 AS IF32_9, LINE PROFIT_LOSS.IMTA USING P1 AS IMTA, LINE PROFIT_LOSS.IMTA USING P3 AS IMTA_1, LINE PROFIT_LOSS.IMTA USING P4 AS IMTA_2, LINE PROFIT_LOSS.IMTA USING P5 AS IMTA_3, LINE PROFIT_LOSS.IMTA USING P6 AS IMTA_4, LINE PROFIT_LOSS.IMTA USING P7 AS IMTA_5, LINE PROFIT_LOSS.IMTA USING P8 AS IMTA_6, LINE PROFIT_LOSS.IMTA USING P9 AS IMTA_7, LINE PROFIT_LOSS.IMTA USING P10 AS IMTA_8, LINE PROFIT_LOSS.IMTA USING P11 AS IMTA_9, LINE PROFIT_LOSS.AUDF USING P1 AS AUDF, LINE PROFIT_LOSS.AUDF USING P3 AS AUDF_1, LINE PROFIT_LOSS.AUDF USING P4 AS AUDF_2, LINE PROFIT_LOSS.AUDF USING P5 AS AUDF_3, LINE PROFIT_LOSS.AUDF USING P6 AS AUDF_4, LINE PROFIT_LOSS.AUDF USING P7 AS AUDF_5, LINE PROFIT_LOSS.AUDF USING P8 AS AUDF_6, LINE PROFIT_LOSS.AUDF USING P9 AS AUDF_7, LINE PROFIT_LOSS.AUDF USING P10 AS AUDF_8, LINE PROFIT_LOSS.AUDF USING P11 AS AUDF_9, LINE PROFIT_LOSS.NADF USING P1 AS NADF, LINE PROFIT_LOSS.NADF USING P3 AS NADF_1, LINE PROFIT_LOSS.NADF USING P4 AS NADF_2, LINE PROFIT_LOSS.NADF USING P5 AS NADF_3, LINE PROFIT_LOSS.NADF USING P6 AS NADF_4, LINE PROFIT_LOSS.NADF USING P7 AS NADF_5, LINE PROFIT_LOSS.NADF USING P8 AS NADF_6, LINE PROFIT_LOSS.NADF USING P9 AS NADF_7, LINE PROFIT_LOSS.NADF USING P10 AS NADF_8, LINE PROFIT_LOSS.NADF USING P11 AS NADF_9, LINE PROFIT_LOSS.IF40 USING P1 AS IF40, LINE PROFIT_LOSS.IF40 USING P3 AS IF40_1, LINE PROFIT_LOSS.IF40 USING P4 AS IF40_2, LINE PROFIT_LOSS.IF40 USING P5 AS IF40_3, LINE PROFIT_LOSS.IF40 USING P6 AS IF40_4, LINE PROFIT_LOSS.IF40 USING P7 AS IF40_5, LINE PROFIT_LOSS.IF40 USING P8 AS IF40_6, LINE PROFIT_LOSS.IF40 USING P9 AS IF40_7, LINE PROFIT_LOSS.IF40 USING P10 AS IF40_8, LINE PROFIT_LOSS.IF40 USING P11 AS IF40_9, LINE PROFIT_LOSS.IF41 USING P1 AS IF41, LINE PROFIT_LOSS.IF41 USING P3 AS IF41_1, LINE PROFIT_LOSS.IF41 USING P4 AS IF41_2, LINE PROFIT_LOSS.IF41 USING P5 AS IF41_3, LINE PROFIT_LOSS.IF41 USING P6 AS IF41_4, LINE PROFIT_LOSS.IF41 USING P7 AS IF41_5, LINE PROFIT_LOSS.IF41 USING P8 AS IF41_6, LINE PROFIT_LOSS.IF41 USING P9 AS IF41_7, LINE PROFIT_LOSS.IF41 USING P10 AS IF41_8, LINE PROFIT_LOSS.IF41 USING P11 AS IF41_9, LINE PROFIT_LOSS.IF42 USING P1 AS IF42, LINE PROFIT_LOSS.IF42 USING P3 AS IF42_1, LINE PROFIT_LOSS.IF42 USING P4 AS IF42_2, LINE PROFIT_LOSS.IF42 USING P5 AS IF42_3, LINE PROFIT_LOSS.IF42 USING P6 AS IF42_4, LINE PROFIT_LOSS.IF42 USING P7 AS IF42_5, LINE PROFIT_LOSS.IF42 USING P8 AS IF42_6, LINE PROFIT_LOSS.IF42 USING P9 AS IF42_7, LINE PROFIT_LOSS.IF42 USING P10 AS IF42_8, LINE PROFIT_LOSS.IF42 USING P11 AS IF42_9, LINE PROFIT_LOSS.IF44 USING P1 AS IF44, LINE PROFIT_LOSS.IF44 USING P3 AS IF44_1, LINE PROFIT_LOSS.IF44 USING P4 AS IF44_2, LINE PROFIT_LOSS.IF44 USING P5 AS IF44_3, LINE PROFIT_LOSS.IF44 USING P6 AS IF44_4, LINE PROFIT_LOSS.IF44 USING P7 AS IF44_5, LINE PROFIT_LOSS.IF44 USING P8 AS IF44_6, LINE PROFIT_LOSS.IF44 USING P9 AS IF44_7, LINE PROFIT_LOSS.IF44 USING P10 AS IF44_8, LINE PROFIT_LOSS.IF44 USING P11 AS IF44_9, LINE PROFIT_LOSS.AMGO USING P1 AS AMGO, LINE PROFIT_LOSS.AMGO USING P3 AS AMGO_1, LINE PROFIT_LOSS.AMGO USING P4 AS AMGO_2, LINE PROFIT_LOSS.AMGO USING P5 AS AMGO_3, LINE PROFIT_LOSS.AMGO USING P6 AS AMGO_4, LINE PROFIT_LOSS.AMGO USING P7 AS AMGO_5, LINE PROFIT_LOSS.AMGO USING P8 AS AMGO_6, LINE PROFIT_LOSS.AMGO USING P9 AS AMGO_7, LINE PROFIT_LOSS.AMGO USING P10 AS AMGO_8, LINE PROFIT_LOSS.AMGO USING P11 AS AMGO_9, LINE PROFIT_LOSS.IF33 USING P1 AS IF33, LINE PROFIT_LOSS.IF33 USING P3 AS IF33_1, LINE PROFIT_LOSS.IF33 USING P4 AS IF33_2, LINE PROFIT_LOSS.IF33 USING P5 AS IF33_3, LINE PROFIT_LOSS.IF33 USING P6 AS IF33_4, LINE PROFIT_LOSS.IF33 USING P7 AS IF33_5, LINE PROFIT_LOSS.IF33 USING P8 AS IF33_6, LINE PROFIT_LOSS.IF33 USING P9 AS IF33_7, LINE PROFIT_LOSS.IF33 USING P10 AS IF33_8, LINE PROFIT_LOSS.IF33 USING P11 AS IF33_9, LINE PROFIT_LOSS.IF34 USING P1 AS IF34, LINE PROFIT_LOSS.IF34 USING P3 AS IF34_1, LINE PROFIT_LOSS.IF34 USING P4 AS IF34_2, LINE PROFIT_LOSS.IF34 USING P5 AS IF34_3, LINE PROFIT_LOSS.IF34 USING P6 AS IF34_4, LINE PROFIT_LOSS.IF34 USING P7 AS IF34_5, LINE PROFIT_LOSS.IF34 USING P8 AS IF34_6, LINE PROFIT_LOSS.IF34 USING P9 AS IF34_7, LINE PROFIT_LOSS.IF34 USING P10 AS IF34_8, LINE PROFIT_LOSS.IF34 USING P11 AS IF34_9, LINE PROFIT_LOSS.IF35 USING P1 AS IF35, LINE PROFIT_LOSS.IF35 USING P3 AS IF35_1, LINE PROFIT_LOSS.IF35 USING P4 AS IF35_2, LINE PROFIT_LOSS.IF35 USING P5 AS IF35_3, LINE PROFIT_LOSS.IF35 USING P6 AS IF35_4, LINE PROFIT_LOSS.IF35 USING P7 AS IF35_5, LINE PROFIT_LOSS.IF35 USING P8 AS IF35_6, LINE PROFIT_LOSS.IF35 USING P9 AS IF35_7, LINE PROFIT_LOSS.IF35 USING P10 AS IF35_8, LINE PROFIT_LOSS.IF35 USING P11 AS IF35_9, LINE PROFIT_LOSS.IF36 USING P1 AS IF36, LINE PROFIT_LOSS.IF36 USING P3 AS IF36_1, LINE PROFIT_LOSS.IF36 USING P4 AS IF36_2, LINE PROFIT_LOSS.IF36 USING P5 AS IF36_3, LINE PROFIT_LOSS.IF36 USING P6 AS IF36_4, LINE PROFIT_LOSS.IF36 USING P7 AS IF36_5, LINE PROFIT_LOSS.IF36 USING P8 AS IF36_6, LINE PROFIT_LOSS.IF36 USING P9 AS IF36_7, LINE PROFIT_LOSS.IF36 USING P10 AS IF36_8, LINE PROFIT_LOSS.IF36 USING P11 AS IF36_9, LINE PROFIT_LOSS.IF37 USING P1 AS IF37, LINE PROFIT_LOSS.IF37 USING P3 AS IF37_1, LINE PROFIT_LOSS.IF37 USING P4 AS IF37_2, LINE PROFIT_LOSS.IF37 USING P5 AS IF37_3, LINE PROFIT_LOSS.IF37 USING P6 AS IF37_4, LINE PROFIT_LOSS.IF37 USING P7 AS IF37_5, LINE PROFIT_LOSS.IF37 USING P8 AS IF37_6, LINE PROFIT_LOSS.IF37 USING P9 AS IF37_7, LINE PROFIT_LOSS.IF37 USING P10 AS IF37_8, LINE PROFIT_LOSS.IF37 USING P11 AS IF37_9, LINE PROFIT_LOSS.IF38 USING P1 AS IF38, LINE PROFIT_LOSS.IF38 USING P3 AS IF38_1, LINE PROFIT_LOSS.IF38 USING P4 AS IF38_2, LINE PROFIT_LOSS.IF38 USING P5 AS IF38_3, LINE PROFIT_LOSS.IF38 USING P6 AS IF38_4, LINE PROFIT_LOSS.IF38 USING P7 AS IF38_5, LINE PROFIT_LOSS.IF38 USING P8 AS IF38_6, LINE PROFIT_LOSS.IF38 USING P9 AS IF38_7, LINE PROFIT_LOSS.IF38 USING P10 AS IF38_8, LINE PROFIT_LOSS.IF38 USING P11 AS IF38_9, LINE PROFIT_LOSS.IF39 USING P1 AS IF39, LINE PROFIT_LOSS.IF39 USING P3 AS IF39_1, LINE PROFIT_LOSS.IF39 USING P4 AS IF39_2, LINE PROFIT_LOSS.IF39 USING P5 AS IF39_3, LINE PROFIT_LOSS.IF39 USING P6 AS IF39_4, LINE PROFIT_LOSS.IF39 USING P7 AS IF39_5, LINE PROFIT_LOSS.IF39 USING P8 AS IF39_6, LINE PROFIT_LOSS.IF39 USING P9 AS IF39_7, LINE PROFIT_LOSS.IF39 USING P10 AS IF39_8, LINE PROFIT_LOSS.IF39 USING P11 AS IF39_9, LINE PROFIT_LOSS.REMU USING P1 AS REMU, LINE PROFIT_LOSS.REMU USING P3 AS REMU_1, LINE PROFIT_LOSS.REMU USING P4 AS REMU_2, LINE PROFIT_LOSS.REMU USING P5 AS REMU_3, LINE PROFIT_LOSS.REMU USING P6 AS REMU_4, LINE PROFIT_LOSS.REMU USING P7 AS REMU_5, LINE PROFIT_LOSS.REMU USING P8 AS REMU_6, LINE PROFIT_LOSS.REMU USING P9 AS REMU_7, LINE PROFIT_LOSS.REMU USING P10 AS REMU_8, LINE PROFIT_LOSS.REMU USING P11 AS REMU_9, LINE PROFIT_LOSS.WASA USING P1 AS WASA, LINE PROFIT_LOSS.WASA USING P3 AS WASA_1, LINE PROFIT_LOSS.WASA USING P4 AS WASA_2, LINE PROFIT_LOSS.WASA USING P5 AS WASA_3, LINE PROFIT_LOSS.WASA USING P6 AS WASA_4, LINE PROFIT_LOSS.WASA USING P7 AS WASA_5, LINE PROFIT_LOSS.WASA USING P8 AS WASA_6, LINE PROFIT_LOSS.WASA USING P9 AS WASA_7, LINE PROFIT_LOSS.WASA USING P10 AS WASA_8, LINE PROFIT_LOSS.WASA USING P11 AS WASA_9, LINE PROFIT_LOSS.SOSC USING P1 AS SOSC, LINE PROFIT_LOSS.SOSC USING P3 AS SOSC_1, LINE PROFIT_LOSS.SOSC USING P4 AS SOSC_2, LINE PROFIT_LOSS.SOSC USING P5 AS SOSC_3, LINE PROFIT_LOSS.SOSC USING P6 AS SOSC_4, LINE PROFIT_LOSS.SOSC USING P7 AS SOSC_5, LINE PROFIT_LOSS.SOSC USING P8 AS SOSC_6, LINE PROFIT_LOSS.SOSC USING P9 AS SOSC_7, LINE PROFIT_LOSS.SOSC USING P10 AS SOSC_8, LINE PROFIT_LOSS.SOSC USING P11 AS SOSC_9, LINE PROFIT_LOSS.PECO USING P1 AS PECO, LINE PROFIT_LOSS.PECO USING P3 AS PECO_1, LINE PROFIT_LOSS.PECO USING P4 AS PECO_2, LINE PROFIT_LOSS.PECO USING P5 AS PECO_3, LINE PROFIT_LOSS.PECO USING P6 AS PECO_4, LINE PROFIT_LOSS.PECO USING P7 AS PECO_5, LINE PROFIT_LOSS.PECO USING P8 AS PECO_6, LINE PROFIT_LOSS.PECO USING P9 AS PECO_7, LINE PROFIT_LOSS.PECO USING P10 AS PECO_8, LINE PROFIT_LOSS.PECO USING P11 AS PECO_9, LINE PROFIT_LOSS.IF14 USING P1 AS IF14, LINE PROFIT_LOSS.IF14 USING P3 AS IF14_1, LINE PROFIT_LOSS.IF14 USING P4 AS IF14_2, LINE PROFIT_LOSS.IF14 USING P5 AS IF14_3, LINE PROFIT_LOSS.IF14 USING P6 AS IF14_4, LINE PROFIT_LOSS.IF14 USING P7 AS IF14_5, LINE PROFIT_LOSS.IF14 USING P8 AS IF14_6, LINE PROFIT_LOSS.IF14 USING P9 AS IF14_7, LINE PROFIT_LOSS.IF14 USING P10 AS IF14_8, LINE PROFIT_LOSS.IF14 USING P11 AS IF14_9, LINE PROFIT_LOSS.DIRR USING P1 AS DIRR, LINE PROFIT_LOSS.DIRR USING P3 AS DIRR_1, LINE PROFIT_LOSS.DIRR USING P4 AS DIRR_2, LINE PROFIT_LOSS.DIRR USING P5 AS DIRR_3, LINE PROFIT_LOSS.DIRR USING P6 AS DIRR_4, LINE PROFIT_LOSS.DIRR USING P7 AS DIRR_5, LINE PROFIT_LOSS.DIRR USING P8 AS DIRR_6, LINE PROFIT_LOSS.DIRR USING P9 AS DIRR_7, LINE PROFIT_LOSS.DIRR USING P10 AS DIRR_8, LINE PROFIT_LOSS.DIRR USING P11 AS DIRR_9, LINE PROFIT_LOSS.DIFE USING P1 AS DIFE, LINE PROFIT_LOSS.DIFE USING P3 AS DIFE_1, LINE PROFIT_LOSS.DIFE USING P4 AS DIFE_2, LINE PROFIT_LOSS.DIFE USING P5 AS DIFE_3, LINE PROFIT_LOSS.DIFE USING P6 AS DIFE_4, LINE PROFIT_LOSS.DIFE USING P7 AS DIFE_5, LINE PROFIT_LOSS.DIFE USING P8 AS DIFE_6, LINE PROFIT_LOSS.DIFE USING P9 AS DIFE_7, LINE PROFIT_LOSS.DIFE USING P10 AS DIFE_8, LINE PROFIT_LOSS.DIFE USING P11 AS DIFE_9, LINE PROFIT_LOSS.COPC USING P1 AS COPC, LINE PROFIT_LOSS.COPC USING P3 AS COPC_1, LINE PROFIT_LOSS.COPC USING P4 AS COPC_2, LINE PROFIT_LOSS.COPC USING P5 AS COPC_3, LINE PROFIT_LOSS.COPC USING P6 AS COPC_4, LINE PROFIT_LOSS.COPC USING P7 AS COPC_5, LINE PROFIT_LOSS.COPC USING P8 AS COPC_6, LINE PROFIT_LOSS.COPC USING P9 AS COPC_7, LINE PROFIT_LOSS.COPC USING P10 AS COPC_8, LINE PROFIT_LOSS.COPC USING P11 AS COPC_9, LINE PROFIT_LOSS.ODIE USING P1 AS ODIE, LINE PROFIT_LOSS.ODIE USING P3 AS ODIE_1, LINE PROFIT_LOSS.ODIE USING P4 AS ODIE_2, LINE PROFIT_LOSS.ODIE USING P5 AS ODIE_3, LINE PROFIT_LOSS.ODIE USING P6 AS ODIE_4, LINE PROFIT_LOSS.ODIE USING P7 AS ODIE_5, LINE PROFIT_LOSS.ODIE USING P8 AS ODIE_6, LINE PROFIT_LOSS.ODIE USING P9 AS ODIE_7, LINE PROFIT_LOSS.ODIE USING P10 AS ODIE_8, LINE PROFIT_LOSS.ODIE USING P11 AS ODIE_9, LINE PROFIT_LOSS.HPDI USING P1 AS HPDI, LINE PROFIT_LOSS.HPDI USING P3 AS HPDI_1, LINE PROFIT_LOSS.HPDI USING P4 AS HPDI_2, LINE PROFIT_LOSS.HPDI USING P5 AS HPDI_3, LINE PROFIT_LOSS.HPDI USING P6 AS HPDI_4, LINE PROFIT_LOSS.HPDI USING P7 AS HPDI_5, LINE PROFIT_LOSS.HPDI USING P8 AS HPDI_6, LINE PROFIT_LOSS.HPDI USING P9 AS HPDI_7, LINE PROFIT_LOSS.HPDI USING P10 AS HPDI_8, LINE PROFIT_LOSS.HPDI USING P11 AS HPDI_9, LINE PROFIT_LOSS.EBTA USING P1 AS EBTA, LINE PROFIT_LOSS.EBTA USING P3 AS EBTA_1, LINE PROFIT_LOSS.EBTA USING P4 AS EBTA_2, LINE PROFIT_LOSS.EBTA USING P5 AS EBTA_3, LINE PROFIT_LOSS.EBTA USING P6 AS EBTA_4, LINE PROFIT_LOSS.EBTA USING P7 AS EBTA_5, LINE PROFIT_LOSS.EBTA USING P8 AS EBTA_6, LINE PROFIT_LOSS.EBTA USING P9 AS EBTA_7, LINE PROFIT_LOSS.EBTA USING P10 AS EBTA_8, LINE PROFIT_LOSS.EBTA USING P11 AS EBTA_9, LINE PROFIT_LOSS.PR10 USING P2 AS PR10_1, LINE PROFIT_LOSS.PR10 USING P12 AS PR10_2, LINE PROFIT_LOSS.PR10 USING P13 AS PR10_3, LINE PROFIT_LOSS.PR10 USING P14 AS PR10_4, LINE PROFIT_LOSS.PR10 USING P15 AS PR10_5, LINE PROFIT_LOSS.PR10 USING P16 AS PR10_6, LINE PROFIT_LOSS.PR10 USING P17 AS PR10_7, LINE PROFIT_LOSS.PR10 USING P18 AS PR10_8, LINE PROFIT_LOSS.PR10 USING P19 AS PR10_9, LINE PROFIT_LOSS.PR10 USING P20 AS PR10_10, LINE CASHFLOW.CF01 USING P1 AS CF01, LINE CASHFLOW.CF01 USING P3 AS CF01_1, LINE CASHFLOW.CF01 USING P4 AS CF01_2, LINE CASHFLOW.CF01 USING P5 AS CF01_3, LINE CASHFLOW.CF01 USING P6 AS CF01_4, LINE CASHFLOW.CF01 USING P7 AS CF01_5, LINE CASHFLOW.CF01 USING P8 AS CF01_6, LINE CASHFLOW.CF01 USING P9 AS CF01_7, LINE CASHFLOW.CF01 USING P10 AS CF01_8, LINE CASHFLOW.CF01 USING P11 AS CF01_9, LINE CASHFLOW.CF02 USING P1 AS CF02, LINE CASHFLOW.CF02 USING P3 AS CF02_1, LINE CASHFLOW.CF02 USING P4 AS CF02_2, LINE CASHFLOW.CF02 USING P5 AS CF02_3, LINE CASHFLOW.CF02 USING P6 AS CF02_4, LINE CASHFLOW.CF02 USING P7 AS CF02_5, LINE CASHFLOW.CF02 USING P8 AS CF02_6, LINE CASHFLOW.CF02 USING P9 AS CF02_7, LINE CASHFLOW.CF02 USING P10 AS CF02_8, LINE CASHFLOW.CF02 USING P11 AS CF02_9, LINE CASHFLOW.CF03 USING P1 AS CF03, LINE CASHFLOW.CF03 USING P3 AS CF03_1, LINE CASHFLOW.CF03 USING P4 AS CF03_2, LINE CASHFLOW.CF03 USING P5 AS CF03_3, LINE CASHFLOW.CF03 USING P6 AS CF03_4, LINE CASHFLOW.CF03 USING P7 AS CF03_5, LINE CASHFLOW.CF03 USING P8 AS CF03_6, LINE CASHFLOW.CF03 USING P9 AS CF03_7, LINE CASHFLOW.CF03 USING P10 AS CF03_8, LINE CASHFLOW.CF03 USING P11 AS CF03_9, LINE CASHFLOW.CF04 USING P1 AS CF04, LINE CASHFLOW.CF04 USING P3 AS CF04_1, LINE CASHFLOW.CF04 USING P4 AS CF04_2, LINE CASHFLOW.CF04 USING P5 AS CF04_3, LINE CASHFLOW.CF04 USING P6 AS CF04_4, LINE CASHFLOW.CF04 USING P7 AS CF04_5, LINE CASHFLOW.CF04 USING P8 AS CF04_6, LINE CASHFLOW.CF04 USING P9 AS CF04_7, LINE CASHFLOW.CF04 USING P10 AS CF04_8, LINE CASHFLOW.CF04 USING P11 AS CF04_9, LINE CASHFLOW.CF07 USING P1 AS CF07, LINE CASHFLOW.CF07 USING P3 AS CF07_1, LINE CASHFLOW.CF07 USING P4 AS CF07_2, LINE CASHFLOW.CF07 USING P5 AS CF07_3, LINE CASHFLOW.CF07 USING P6 AS CF07_4, LINE CASHFLOW.CF07 USING P7 AS CF07_5, LINE CASHFLOW.CF07 USING P8 AS CF07_6, LINE CASHFLOW.CF07 USING P9 AS CF07_7, LINE CASHFLOW.CF07 USING P10 AS CF07_8, LINE CASHFLOW.CF07 USING P11 AS CF07_9, LINE CASHFLOW.CF08 USING P1 AS CF08, LINE CASHFLOW.CF08 USING P3 AS CF08_1, LINE CASHFLOW.CF08 USING P4 AS CF08_2, LINE CASHFLOW.CF08 USING P5 AS CF08_3, LINE CASHFLOW.CF08 USING P6 AS CF08_4, LINE CASHFLOW.CF08 USING P7 AS CF08_5, LINE CASHFLOW.CF08 USING P8 AS CF08_6, LINE CASHFLOW.CF08 USING P9 AS CF08_7, LINE CASHFLOW.CF08 USING P10 AS CF08_8, LINE CASHFLOW.CF08 USING P11 AS CF08_9, LINE CASHFLOW.CF09 USING P1 AS CF09, LINE CASHFLOW.CF09 USING P3 AS CF09_1, LINE CASHFLOW.CF09 USING P4 AS CF09_2, LINE CASHFLOW.CF09 USING P5 AS CF09_3, LINE CASHFLOW.CF09 USING P6 AS CF09_4, LINE CASHFLOW.CF09 USING P7 AS CF09_5, LINE CASHFLOW.CF09 USING P8 AS CF09_6, LINE CASHFLOW.CF09 USING P9 AS CF09_7, LINE CASHFLOW.CF09 USING P10 AS CF09_8, LINE CASHFLOW.CF09 USING P11 AS CF09_9, LINE CASHFLOW.CF10 USING P1 AS CF10, LINE CASHFLOW.CF10 USING P3 AS CF10_1, LINE CASHFLOW.CF10 USING P4 AS CF10_2, LINE CASHFLOW.CF10 USING P5 AS CF10_3, LINE CASHFLOW.CF10 USING P6 AS CF10_4, LINE CASHFLOW.CF10 USING P7 AS CF10_5, LINE CASHFLOW.CF10 USING P8 AS CF10_6, LINE CASHFLOW.CF10 USING P9 AS CF10_7, LINE CASHFLOW.CF10 USING P10 AS CF10_8, LINE CASHFLOW.CF10 USING P11 AS CF10_9, LINE CASHFLOW.CF05 USING P1 AS CF05, LINE CASHFLOW.CF05 USING P3 AS CF05_1, LINE CASHFLOW.CF05 USING P4 AS CF05_2, LINE CASHFLOW.CF05 USING P5 AS CF05_3, LINE CASHFLOW.CF05 USING P6 AS CF05_4, LINE CASHFLOW.CF05 USING P7 AS CF05_5, LINE CASHFLOW.CF05 USING P8 AS CF05_6, LINE CASHFLOW.CF05 USING P9 AS CF05_7, LINE CASHFLOW.CF05 USING P10 AS CF05_8, LINE CASHFLOW.CF05 USING P11 AS CF05_9, LINE CASHFLOW.CF06 USING P1 AS CF06, LINE CASHFLOW.CF06 USING P3 AS CF06_1, LINE CASHFLOW.CF06 USING P4 AS CF06_2, LINE CASHFLOW.CF06 USING P5 AS CF06_3, LINE CASHFLOW.CF06 USING P6 AS CF06_4, LINE CASHFLOW.CF06 USING P7 AS CF06_5, LINE CASHFLOW.CF06 USING P8 AS CF06_6, LINE CASHFLOW.CF06 USING P9 AS CF06_7, LINE CASHFLOW.CF06 USING P10 AS CF06_8, LINE CASHFLOW.CF06 USING P11 AS CF06_9, LINE PROFILE.TRUN USING P1 AS TURN_11, LINE PROFILE.TRUN USING P3 AS TURN_12, LINE PROFILE.TRUN USING P4 AS TURN_13, LINE PROFILE.TRUN USING P5 AS TURN_14, LINE PROFILE.TRUN USING P6 AS TURN_15, LINE PROFILE.TRUN USING P7 AS TURN_16, LINE PROFILE.TRUN USING P8 AS TURN_17, LINE PROFILE.TRUN USING P9 AS TURN_18, LINE PROFILE.TRUN USING P10 AS TURN_19, LINE PROFILE.TRUN USING P11 AS TURN_20, LINE PROFILE.PR02 USING P1 AS PR02, LINE PROFILE.PR02 USING P3 AS PR02_1, LINE PROFILE.PR02 USING P4 AS PR02_2, LINE PROFILE.PR02 USING P5 AS PR02_3, LINE PROFILE.PR02 USING P6 AS PR02_4, LINE PROFILE.PR02 USING P7 AS PR02_5, LINE PROFILE.PR02 USING P8 AS PR02_6, LINE PROFILE.PR02 USING P9 AS PR02_7, LINE PROFILE.PR02 USING P10 AS PR02_8, LINE PROFILE.PR02 USING P11 AS PR02_9, LINE PROFILE.PR03 USING P1 AS PR03, LINE PROFILE.PR03 USING P3 AS PR03_1, LINE PROFILE.PR03 USING P4 AS PR03_2, LINE PROFILE.PR03 USING P5 AS PR03_3, LINE PROFILE.PR03 USING P6 AS PR03_4, LINE PROFILE.PR03 USING P7 AS PR03_5, LINE PROFILE.PR03 USING P8 AS PR03_6, LINE PROFILE.PR03 USING P9 AS PR03_7, LINE PROFILE.PR03 USING P10 AS PR03_8, LINE PROFILE.PR03 USING P11 AS PR03_9, LINE PROFILE.PR04 USING P1 AS PR04, LINE PROFILE.PR04 USING P3 AS PR04_1, LINE PROFILE.PR04 USING P4 AS PR04_2, LINE PROFILE.PR04 USING P5 AS PR04_3, LINE PROFILE.PR04 USING P6 AS PR04_4, LINE PROFILE.PR04 USING P7 AS PR04_5, LINE PROFILE.PR04 USING P8 AS PR04_6, LINE PROFILE.PR04 USING P9 AS PR04_7, LINE PROFILE.PR04 USING P10 AS PR04_8, LINE PROFILE.PR04 USING P11 AS PR04_9, LINE PROFILE.PR05 USING P2 AS PR05, LINE PROFILE.PR05 USING P12 AS PR05_1, LINE PROFILE.PR05 USING P13 AS PR05_2, LINE PROFILE.PR05 USING P14 AS PR05_3, LINE PROFILE.PR05 USING P15 AS PR05_4, LINE PROFILE.PR05 USING P16 AS PR05_5, LINE PROFILE.PR05 USING P17 AS PR05_6, LINE PROFILE.PR05 USING P18 AS PR05_7, LINE PROFILE.PR05 USING P19 AS PR05_8, LINE PROFILE.PR05 USING P20 AS PR05_9, LINE PROFILE.PR06 USING P2 AS PR06, LINE PROFILE.PR06 USING P12 AS PR06_1, LINE PROFILE.PR06 USING P13 AS PR06_2, LINE PROFILE.PR06 USING P14 AS PR06_3, LINE PROFILE.PR06 USING P15 AS PR06_4, LINE PROFILE.PR06 USING P16 AS PR06_5, LINE PROFILE.PR06 USING P17 AS PR06_6, LINE PROFILE.PR06 USING P18 AS PR06_7, LINE PROFILE.PR06 USING P19 AS PR06_8, LINE PROFILE.PR06 USING P20 AS PR06_9, LINE PROFILE.PR07 USING P2 AS PR07, LINE PROFILE.PR07 USING P12 AS PR07_1, LINE PROFILE.PR07 USING P13 AS PR07_2, LINE PROFILE.PR07 USING P14 AS PR07_3, LINE PROFILE.PR07 USING P15 AS PR07_4, LINE PROFILE.PR07 USING P16 AS PR07_5, LINE PROFILE.PR07 USING P17 AS PR07_6, LINE PROFILE.PR07 USING P18 AS PR07_7, LINE PROFILE.PR07 USING P19 AS PR07_8, LINE PROFILE.PR07 USING P20 AS PR07_9, LINE PROFILE.PR08 USING P2 AS PR08, LINE PROFILE.PR08 USING P12 AS PR08_1, LINE PROFILE.PR08 USING P13 AS PR08_2, LINE PROFILE.PR08 USING P14 AS PR08_3, LINE PROFILE.PR08 USING P15 AS PR08_4, LINE PROFILE.PR08 USING P16 AS PR08_5, LINE PROFILE.PR08 USING P17 AS PR08_6, LINE PROFILE.PR08 USING P18 AS PR08_7, LINE PROFILE.PR08 USING P19 AS PR08_8, LINE PROFILE.PR08 USING P20 AS PR08_9, LINE PROFILE.PR09 USING P2 AS PR09, LINE PROFILE.PR09 USING P12 AS PR09_1, LINE PROFILE.PR09 USING P13 AS PR09_2, LINE PROFILE.PR09 USING P14 AS PR09_3, LINE PROFILE.PR09 USING P15 AS PR09_4, LINE PROFILE.PR09 USING P16 AS PR09_5, LINE PROFILE.PR09 USING P17 AS PR09_6, LINE PROFILE.PR09 USING P18 AS PR09_7, LINE PROFILE.PR09 USING P19 AS PR09_8, LINE PROFILE.PR09 USING P20 AS PR09_9, LINE PROFILE.PR10 USING P2 AS PR10_11, LINE PROFILE.PR10 USING P12 AS PR10_12, LINE PROFILE.PR10 USING P13 AS PR10_13, LINE PROFILE.PR10 USING P14 AS PR10_14, LINE PROFILE.PR10 USING P15 AS PR10_15, LINE PROFILE.PR10 USING P16 AS PR10_16, LINE PROFILE.PR10 USING P17 AS PR10_17, LINE PROFILE.PR10 USING P18 AS PR10_18, LINE PROFILE.PR10 USING P19 AS PR10_19, LINE PROFILE.PR10 USING P20 AS PR10_20 FROM RemoteAccess.U" | |
results = client.service.GetData(session_handle, loaded_strategy, detailed_query, 0, 5, 'XML') | |
print results |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Notes
strategy_xml
detailed_query
you need to first save a search and then save a list format for that search and give it a name. To get to the list format screen you click the ``Add``` button in the search results screen lol