copy data from file a to file b help please

R

rjhe22

New Member
Joined
Jan 7, 2013
Messages
24
can some one please help as this is wrecking my head

i want to copy a file that looks like this
Code: 
[TABLE="width: 4237"]
<tbody>[TR]
[TD="align: right"]01/11/2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class Level[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Check to Share Registry[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Partnership Code[/TD]
[TD]Partnership Name[/TD]
[TD]Class Code[/TD]
[TD]Class Name[/TD]
[TD]Entity Code[/TD]
[TD]Entity Legal Name[/TD]
[TD]Sub-entity Code[/TD]
[TD]Sub-entity Legal Name[/TD]
[TD]Capital Account Code[/TD]
[TD]Currency Code[/TD]
[TD]Management Fee Percentage[/TD]
[TD]Incentive Fee Percentage[/TD]
[TD]Subscription Fees %[/TD]
[TD]Redemption Fee %[/TD]
[TD]Switching Fee %[/TD]
[TD] Prior day NAV / Share[/TD]
[TD] Prior day Net Assets[/TD]
[TD] Prior day Shares[/TD]
[TD] Subscriptions[/TD]
[TD] Subscription Fees[/TD]
[TD] Net Subscriptions[/TD]
[TD] Redemptions[/TD]
[TD] Starting Cum Accrued Incentive Fee[/TD]
[TD] Starting Gross Adjusted NAV[/TD]
[TD] Shares Contributed[/TD]
[TD] Shares Withdrawn[/TD]
[TD] Total Shares[/TD]
[TD] Crystallized Perf fees[/TD]
[TD] Opening Acrued Incentive fees[/TD]
[TD] FUND OWNERSHIP %[/TD]
[TD] Trading PNL[/TD]
[TD] Class Specific Income/Expense[/TD]
[TD] Management Fee Asset Base[/TD]
[TD] Management Fee[/TD]
[TD] Gross NAV[/TD]
[TD] Gross NAV per Share[/TD]
[TD] NAV at start of Calculation Period / Share[/TD]
[TD] Cumulative Change in GAV[/TD]
[TD] Current Index[/TD]
[TD] HWM[/TD]
[TD] Cumulative Change in Index[/TD]
[TD] Cumulative Performance tracking Vs Index[/TD]
[TD] Daily Incentive Fee[/TD]
[TD] Cumulative Incentive Fee[/TD]
[TD]  NAV After Incentive Fee[/TD]
[TD]  NAV per Share[/TD]
[TD]Daily Perf[/TD]
[TD][/TD]
[TD] Sub Fees payable to Fund %[/TD]
[TD] Subscription Fees Payable to Fund[/TD]
[TD][/TD]
[TD] Per Advent Partner[/TD]
[TD] Difference[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/IA2[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]0.80%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,214.91[/TD]
[TD="align: right"]28,728,786.73[/TD]
[TD="align: right"]23,646.81[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]10,970.65[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]28,717,816.08[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]9.03[/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]20.71%[/TD]
[TD]    317,473.93[/TD]
[TD]          -[/TD]
[TD]   29,035,290.01[/TD]
[TD]-     634.65[/TD]
[TD]     29,034,655.35[/TD]
[TD] 1,228.32[/TD]
[TD] 1,262.20[/TD]
[TD="align: right"]-2.68%[/TD]
[TD] 1,022.80[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]2.28%[/TD]
[TD="align: right"]-4.96%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]29,034,655.35[/TD]
[TD] 1,228.32[/TD]
[TD="align: right"]1.10%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA1[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.20%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD]    830.19[/TD]
[TD="align: right"]105,906,325.16[/TD]
[TD="align: right"]127,569.47[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]508,435.13[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]105,397,890.03[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]612.44[/TD]
[TD="align: right"]126,957.04[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]76.01%[/TD]
[TD] 1,165,168.07[/TD]
[TD]          -[/TD]
[TD] 106,563,058.11[/TD]
[TD]-  3,493.87[/TD]
[TD]   106,559,564.24[/TD]
[TD]    839.34[/TD]
[TD]    867.67[/TD]
[TD="align: right"]-3.27%[/TD]
[TD] 1,022.80[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]2.28%[/TD]
[TD="align: right"]-5.55%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]106,559,564.24[/TD]
[TD]    839.34[/TD]
[TD="align: right"]1.10%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]126,957.04[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA2[/TD]
[TD]RA- Retail Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.45%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,557.06[/TD]
[TD="align: right"]4,543,675.00[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,543,675.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.28%[/TD]
[TD]      50,230.09[/TD]
[TD]          -[/TD]
[TD]     4,593,905.09[/TD]
[TD]-     182.00[/TD]
[TD]        4,593,723.09[/TD]
[TD] 1,574.21[/TD]
[TD] 1,633.45[/TD]
[TD="align: right"]-3.63%[/TD]
[TD] 1,022.80[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]2.28%[/TD]
[TD="align: right"]-5.91%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,593,723.16[/TD]
[TD] 1,574.21[/TD]
[TD="align: right"]1.10%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]139,178,786.89[/TD]
[TD="align: right"]154,134.39[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]519,405.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]138,659,381.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]621.47[/TD]
[TD="align: right"]153,512.92[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]100.00%[/TD]
[TD] 1,532,872.09[/TD]
[TD]          -[/TD]
[TD] 140,192,253.20[/TD]
[TD]-  4,310.52[/TD]
[TD]  140,187,942.68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]140,187,942.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]153,512.92[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/11/2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class Level[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Check to Share Registry[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Partnership Code[/TD]
[TD]Partnership Name[/TD]
[TD]Class Code[/TD]
[TD]Class Name[/TD]
[TD]Entity Code[/TD]
[TD]Entity Legal Name[/TD]
[TD]Sub-entity Code[/TD]
[TD]Sub-entity Legal Name[/TD]
[TD]Capital Account Code[/TD]
[TD]Currency Code[/TD]
[TD]Management Fee Percentage[/TD]
[TD]Incentive Fee Percentage[/TD]
[TD]Subscription Fees %[/TD]
[TD]Redemption Fee %[/TD]
[TD]Switching Fee %[/TD]
[TD] Prior day NAV / Share[/TD]
[TD] Prior day Net Assets[/TD]
[TD] Prior day Shares[/TD]
[TD] Subscriptions[/TD]
[TD] Subscription Fees[/TD]
[TD] Net Subscriptions[/TD]
[TD] Redemptions[/TD]
[TD] Starting Cum Accrued Incentive Fee[/TD]
[TD] Starting Gross Adjusted NAV[/TD]
[TD] Shares Contributed[/TD]
[TD] Shares Withdrawn[/TD]
[TD] Total Shares[/TD]
[TD] Crystallized Perf fees[/TD]
[TD] Opening Acrued Incentive fees[/TD]
[TD] FUND OWNERSHIP %[/TD]
[TD] Trading PNL[/TD]
[TD] Class Specific Income/Expense[/TD]
[TD] Management Fee Asset Base[/TD]
[TD] Management Fee[/TD]
[TD] Gross NAV[/TD]
[TD] Gross NAV per Share[/TD]
[TD] NAV at start of Calculation Period / Share[/TD]
[TD] Cumulative Change in GAV[/TD]
[TD] Current Index[/TD]
[TD] HWM[/TD]
[TD] Cumulative Change in Index[/TD]
[TD] Cumulative Performance tracking Vs Index[/TD]
[TD] Daily Incentive Fee[/TD]
[TD] Cumulative Incentive Fee[/TD]
[TD]  NAV After Incentive Fee[/TD]
[TD]  NAV per Share[/TD]
[TD]Daily Perf[/TD]
[TD][/TD]
[TD] Sub Fees payable to Fund %[/TD]
[TD] Subscription Fees Payable to Fund[/TD]
[TD][/TD]
[TD] Per Advent Partner[/TD]
[TD] Difference[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/IA2[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]0.80%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,228.32[/TD]
[TD="align: right"]29,034,655.35[/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]29,034,655.35[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]20.77%[/TD]
[TD]      10,849.76[/TD]
[TD]          -[/TD]
[TD]   29,045,505.11[/TD]
[TD]-     634.87[/TD]
[TD]     29,044,870.24[/TD]
[TD] 1,228.75[/TD]
[TD] 1,262.20[/TD]
[TD="align: right"]-2.65%[/TD]
[TD] 1,018.74[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]1.87%[/TD]
[TD="align: right"]-4.52%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]29,044,870.24[/TD]
[TD] 1,228.75[/TD]
[TD="align: right"]0.04%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.20%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD]    839.34[/TD]
[TD="align: right"]106,559,564.24[/TD]
[TD="align: right"]126,957.04[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]401,664.06[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]106,157,900.18[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]478.55[/TD]
[TD="align: right"]126,478.49[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]75.94%[/TD]
[TD]      39,669.41[/TD]
[TD]          -[/TD]
[TD] 106,197,569.59[/TD]
[TD]-  3,481.89[/TD]
[TD]   106,194,087.70[/TD]
[TD]    839.62[/TD]
[TD]    867.67[/TD]
[TD="align: right"]-3.23%[/TD]
[TD] 1,018.74[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]1.87%[/TD]
[TD="align: right"]-5.11%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]106,194,087.70[/TD]
[TD]    839.62[/TD]
[TD="align: right"]0.03%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]126,478.49[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA2[/TD]
[TD]RA- Retail Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.45%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,574.21[/TD]
[TD="align: right"]4,593,723.16[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,593,723.16[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.29%[/TD]
[TD]       1,716.60[/TD]
[TD]          -[/TD]
[TD]     4,595,439.75[/TD]
[TD]-     182.06[/TD]
[TD]        4,595,257.69[/TD]
[TD] 1,574.74[/TD]
[TD] 1,633.45[/TD]
[TD="align: right"]-3.59%[/TD]
[TD] 1,018.74[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]1.87%[/TD]
[TD="align: right"]-5.47%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,595,257.76[/TD]
[TD] 1,574.74[/TD]
[TD="align: right"]0.03%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[TABLE="width: 4237"]
<tbody>[TR]
[TD="align: right"]01/11/2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class Level[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Check to Share Registry[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Partnership Code[/TD]
[TD]Partnership Name[/TD]
[TD]Class Code[/TD]
[TD]Class Name[/TD]
[TD]Entity Code[/TD]
[TD]Entity Legal Name[/TD]
[TD]Sub-entity Code[/TD]
[TD]Sub-entity Legal Name[/TD]
[TD]Capital Account Code[/TD]
[TD]Currency Code[/TD]
[TD]Management Fee Percentage[/TD]
[TD]Incentive Fee Percentage[/TD]
[TD]Subscription Fees %[/TD]
[TD]Redemption Fee %[/TD]
[TD]Switching Fee %[/TD]
[TD] Prior day NAV / Share[/TD]
[TD] Prior day Net Assets[/TD]
[TD] Prior day Shares[/TD]
[TD] Subscriptions[/TD]
[TD] Subscription Fees[/TD]
[TD] Net Subscriptions[/TD]
[TD] Redemptions[/TD]
[TD] Starting Cum Accrued Incentive Fee[/TD]
[TD] Starting Gross Adjusted NAV[/TD]
[TD] Shares Contributed[/TD]
[TD] Shares Withdrawn[/TD]
[TD] Total Shares[/TD]
[TD] Crystallized Perf fees[/TD]
[TD] Opening Acrued Incentive fees[/TD]
[TD] FUND OWNERSHIP %[/TD]
[TD] Trading PNL[/TD]
[TD] Class Specific Income/Expense[/TD]
[TD] Management Fee Asset Base[/TD]
[TD] Management Fee[/TD]
[TD] Gross NAV[/TD]
[TD] Gross NAV per Share[/TD]
[TD] NAV at start of Calculation Period / Share[/TD]
[TD] Cumulative Change in GAV[/TD]
[TD] Current Index[/TD]
[TD] HWM[/TD]
[TD] Cumulative Change in Index[/TD]
[TD] Cumulative Performance tracking Vs Index[/TD]
[TD] Daily Incentive Fee[/TD]
[TD] Cumulative Incentive Fee[/TD]
[TD]  NAV After Incentive Fee[/TD]
[TD]  NAV per Share[/TD]
[TD]Daily Perf[/TD]
[TD][/TD]
[TD] Sub Fees payable to Fund %[/TD]
[TD] Subscription Fees Payable to Fund[/TD]
[TD][/TD]
[TD] Per Advent Partner[/TD]
[TD] Difference[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/IA2[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]0.80%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,214.91[/TD]
[TD="align: right"]28,728,786.73[/TD]
[TD="align: right"]23,646.81[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]10,970.65[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]28,717,816.08[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]9.03[/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]20.71%[/TD]
[TD]    317,473.93[/TD]
[TD]          -[/TD]
[TD]   29,035,290.01[/TD]
[TD]-     634.65[/TD]
[TD]     29,034,655.35[/TD]
[TD] 1,228.32[/TD]
[TD] 1,262.20[/TD]
[TD="align: right"]-2.68%[/TD]
[TD] 1,022.80[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]2.28%[/TD]
[TD="align: right"]-4.96%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]29,034,655.35[/TD]
[TD] 1,228.32[/TD]
[TD="align: right"]1.10%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA1[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.20%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD]    830.19[/TD]
[TD="align: right"]105,906,325.16[/TD]
[TD="align: right"]127,569.47[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]508,435.13[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]105,397,890.03[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]612.44[/TD]
[TD="align: right"]126,957.04[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]76.01%[/TD]
[TD] 1,165,168.07[/TD]
[TD]          -[/TD]
[TD] 106,563,058.11[/TD]
[TD]-  3,493.87[/TD]
[TD]   106,559,564.24[/TD]
[TD]    839.34[/TD]
[TD]    867.67[/TD]
[TD="align: right"]-3.27%[/TD]
[TD] 1,022.80[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]2.28%[/TD]
[TD="align: right"]-5.55%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]106,559,564.24[/TD]
[TD]    839.34[/TD]
[TD="align: right"]1.10%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]126,957.04[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA2[/TD]
[TD]RA- Retail Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.45%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,557.06[/TD]
[TD="align: right"]4,543,675.00[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,543,675.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.28%[/TD]
[TD]      50,230.09[/TD]
[TD]          -[/TD]
[TD]     4,593,905.09[/TD]
[TD]-     182.00[/TD]
[TD]        4,593,723.09[/TD]
[TD] 1,574.21[/TD]
[TD] 1,633.45[/TD]
[TD="align: right"]-3.63%[/TD]
[TD] 1,022.80[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]2.28%[/TD]
[TD="align: right"]-5.91%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,593,723.16[/TD]
[TD] 1,574.21[/TD]
[TD="align: right"]1.10%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]139,178,786.89[/TD]
[TD="align: right"]154,134.39[/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]519,405.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]138,659,381.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]621.47[/TD]
[TD="align: right"]153,512.92[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]100.00%[/TD]
[TD] 1,532,872.09[/TD]
[TD]          -[/TD]
[TD] 140,192,253.20[/TD]
[TD]-  4,310.52[/TD]
[TD]  140,187,942.68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]140,187,942.75[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]153,512.92[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/11/2012[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Class Level[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Check to Share Registry[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Partnership Code[/TD]
[TD]Partnership Name[/TD]
[TD]Class Code[/TD]
[TD]Class Name[/TD]
[TD]Entity Code[/TD]
[TD]Entity Legal Name[/TD]
[TD]Sub-entity Code[/TD]
[TD]Sub-entity Legal Name[/TD]
[TD]Capital Account Code[/TD]
[TD]Currency Code[/TD]
[TD]Management Fee Percentage[/TD]
[TD]Incentive Fee Percentage[/TD]
[TD]Subscription Fees %[/TD]
[TD]Redemption Fee %[/TD]
[TD]Switching Fee %[/TD]
[TD] Prior day NAV / Share[/TD]
[TD] Prior day Net Assets[/TD]
[TD] Prior day Shares[/TD]
[TD] Subscriptions[/TD]
[TD] Subscription Fees[/TD]
[TD] Net Subscriptions[/TD]
[TD] Redemptions[/TD]
[TD] Starting Cum Accrued Incentive Fee[/TD]
[TD] Starting Gross Adjusted NAV[/TD]
[TD] Shares Contributed[/TD]
[TD] Shares Withdrawn[/TD]
[TD] Total Shares[/TD]
[TD] Crystallized Perf fees[/TD]
[TD] Opening Acrued Incentive fees[/TD]
[TD] FUND OWNERSHIP %[/TD]
[TD] Trading PNL[/TD]
[TD] Class Specific Income/Expense[/TD]
[TD] Management Fee Asset Base[/TD]
[TD] Management Fee[/TD]
[TD] Gross NAV[/TD]
[TD] Gross NAV per Share[/TD]
[TD] NAV at start of Calculation Period / Share[/TD]
[TD] Cumulative Change in GAV[/TD]
[TD] Current Index[/TD]
[TD] HWM[/TD]
[TD] Cumulative Change in Index[/TD]
[TD] Cumulative Performance tracking Vs Index[/TD]
[TD] Daily Incentive Fee[/TD]
[TD] Cumulative Incentive Fee[/TD]
[TD]  NAV After Incentive Fee[/TD]
[TD]  NAV per Share[/TD]
[TD]Daily Perf[/TD]
[TD][/TD]
[TD] Sub Fees payable to Fund %[/TD]
[TD] Subscription Fees Payable to Fund[/TD]
[TD][/TD]
[TD] Per Advent Partner[/TD]
[TD] Difference[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/IA2[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]0.80%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,228.32[/TD]
[TD="align: right"]29,034,655.35[/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]29,034,655.35[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]20.77%[/TD]
[TD]      10,849.76[/TD]
[TD]          -[/TD]
[TD]   29,045,505.11[/TD]
[TD]-     634.87[/TD]
[TD]     29,044,870.24[/TD]
[TD] 1,228.75[/TD]
[TD] 1,262.20[/TD]
[TD="align: right"]-2.65%[/TD]
[TD] 1,018.74[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]1.87%[/TD]
[TD="align: right"]-4.52%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]29,044,870.24[/TD]
[TD] 1,228.75[/TD]
[TD="align: right"]0.04%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]23,637.78[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA[/TD]
[TD]RA- Institutional Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.20%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD]    839.34[/TD]
[TD="align: right"]106,559,564.24[/TD]
[TD="align: right"]126,957.04[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]401,664.06[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]106,157,900.18[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]478.55[/TD]
[TD="align: right"]126,478.49[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]75.94%[/TD]
[TD]      39,669.41[/TD]
[TD]          -[/TD]
[TD] 106,197,569.59[/TD]
[TD]-  3,481.89[/TD]
[TD]   106,194,087.70[/TD]
[TD]    839.62[/TD]
[TD]    867.67[/TD]
[TD="align: right"]-3.23%[/TD]
[TD] 1,018.74[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]1.87%[/TD]
[TD="align: right"]-5.11%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]106,194,087.70[/TD]
[TD]    839.62[/TD]
[TD="align: right"]0.03%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]126,478.49[/TD]
[TD="align: right"]-0.00[/TD]
[/TR]
[TR]
[TD]UBSUCITS[/TD]
[TD]First Norway Delta Fund[/TD]
[TD]NOK/RA2[/TD]
[TD]RA- Retail Investors[/TD]
[TD][/TD]
[TD]First Norway Delta Fund[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]NOK[/TD]
[TD="align: right"]1.45%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.1%[/TD]
[TD] 1,574.21[/TD]
[TD="align: right"]4,593,723.16[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,593,723.16[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.29%[/TD]
[TD]       1,716.60[/TD]
[TD]          -[/TD]
[TD]     4,595,439.75[/TD]
[TD]-     182.06[/TD]
[TD]        4,595,257.69[/TD]
[TD] 1,574.74[/TD]
[TD] 1,633.45[/TD]
[TD="align: right"]-3.59%[/TD]
[TD] 1,018.74[/TD]
[TD] 1,000.00[/TD]
[TD="align: right"]1.87%[/TD]
[TD="align: right"]-5.47%[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]4,595,257.76[/TD]
[TD] 1,574.74[/TD]
[TD="align: right"]0.03%[/TD]
[TD][/TD]
[TD="align: right"]0.1%[/TD]
[TD="align: right"]0.00[/TD]
[TD][/TD]
[TD="align: right"]2,918.11[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

to look like this

Code: 
[TABLE="width: 786"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]DATE[/TD]
[TD]NOK/IA1[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/IA2[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/RA1[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/RA 2[/TD]
[TD]Monthly Average[/TD]
[/TR]
[TR]
[TD="align: right"]01/11/2012[/TD]
[TD="align: right"]0.00%[/TD]
[TD][/TD]
[TD="align: right"]20.71%[/TD]
[TD] [/TD]
[TD="align: right"]76.01%[/TD]
[TD][/TD]
[TD="align: right"]3.28%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/11/2012[/TD]
[TD="align: right"]0.00%[/TD]
[TD][/TD]
[TD="align: right"]20.77%[/TD]
[TD] [/TD]
[TD="align: right"]75.94%[/TD]
[TD][/TD]
[TD="align: right"]3.29%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 786"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody></tbody>[/TABLE]

this one is for fund ownership % and is colum ad


i have this code done for it but it does not work

Code: 
Sub FUND_OWNERSHIP()Dim i As Long, LR As Long
Application.ScreenUpdating = False
On Error Resume Next
Set ms = Workbooks("UBS_FND_OngoingCharge_Calc.xlsx").Sheets("Allocation")
    With Worksheets("Allocation")
        LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row
          For i = 1 To LR
             If IsDate(.Cells(i, 1)) Then
                 .Cells(i, 1).Copy
                ms.Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
            End If
                If Len(.Cells(i, "AD")) And .Cells(i, "AD") = "FUND OWNERSHIP %" Then
                .Cells(i, "AD").Offset(1).Resize(4).Copy
                ms.Range("B" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Transpose:=True
              End If
          Next i
    End With
                
Application.CutCopyMode = 0
Columns(1).NumberFormat = "dd/mm/yyyy"
Application.ScreenUpdating = True


End Sub
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Hello rjhe22, I watched your details and the specified result you want, from what I observed the two dates of similar data is overly spread horizontally. One thing you can do is to give an explanation of how you determine the result you intend. It seems as if you need some calculation in the code. In short give a detail explanation to invoke help from this forum.

Thanks
 
Upvote 0
at the moment i dont need any calculation i just need to pull the info from under column fund ownership or column ad
and display them in another work book.

so from book 1 i need to pull the date first and put that in the first column\cell under the header
then after that look for the fund ownership column or column ad. there is 4 figures under that for each date and i just want to copy them and place them into cells in the second book.

only thing is the number from first file come like this
21.2%
100%
2.3%
etc
i want them to be pasted across and put them under the right column headers

my code above copies and pasted them over all right (well sometime it works and some times it doesnt which is very strange) but doesnt put them under right headers just put them in 1 after another
 
Upvote 0
ok
i seem to have it working now expect 1 thing
it is displaying like this
Code: 
[TABLE="width: 587"]
<tbody>[TR]
[TD]DATE[/TD]
[TD]NOK/IA1[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/IA2[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/RA1[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/RA 2[/TD]
[TD]Monthly Average[/TD]
[/TR]
[TR]
[TD="align: right"]01/11/2012[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]20.71%[/TD]
[TD="align: right"]76.01%[/TD]
[TD="align: right"]3.28%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/11/2012[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]20.77%[/TD]
[TD="align: right"]75.94%[/TD]
[TD="align: right"]3.29%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

but want it like this
Code: 
[TABLE="width: 587"]
<tbody>[TR]
[TD]DATE[/TD]
[TD]NOK/IA1[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/IA2[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/RA1[/TD]
[TD]Monthly Average[/TD]
[TD]NOK/RA 2[/TD]
[TD]Monthly Average[/TD]
[/TR]
[TR]
[TD="align: right"]01/11/2012[/TD]
[TD="align: right"]0.00%[/TD]
[TD][/TD]
[TD="align: right"]20.71%[/TD]
[TD][/TD]
[TD="align: right"]76.01%[/TD]
[TD][/TD]
[TD="align: right"]3.28%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/11/2012[/TD]
[TD="align: right"]0.00%[/TD]
[TD][/TD]
[TD="align: right"]20.77%[/TD]
[TD][/TD]
[TD="align: right"]75.94%[/TD]
[TD][/TD]
[TD="align: right"]3.29%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hello rjhe22 I was unable to run your code successfully. No data shows up after row 18 (Note I took the first two dates), but if you can run it and get what you got, then you have format problem. However, if that's your problem this should work for you.

Note: I deleted this line of code: Columns(1).NumberFormat = "dd/mm/yyyy" found before the statement: Application.ScreenUpdating = True


Sub FUND_OWNERSHIP()
Dim i As Long, LR As Long
Application.ScreenUpdating = False
On Error Resume Next
Set ms = Workbooks("UBS_FND_OngoingCharge_Calc.xlsx").Sheets("Allocation")
With Worksheets("Allocation")
LR = .Cells.Find("*", , , , xlByRows, xlPrevious).Row
For i = 1 To LR
If IsDate(.Cells(i, 1)) Then
.Cells(i, 1).Copy
MyDate = ms.Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial(xlPasteValues)
MyDate.NumberFormat = "dd/mm/yyyy"
End If
If Len(.Cells(i, "AD")) And .Cells(i, "AD") = "FUND OWNERSHIP %" Then
.Cells(i, "AD").Offset(1).Resize(4).Copy
MyData = Format(ms.Range("B" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial(Transpose:=True), Percent)

End If
Next i
End With

Application.CutCopyMode = 0


Application.ScreenUpdating = True




End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Conditional sum help?
Replies
5
Views
5K
stanleydgromjr
S

Forum statistics

Threads
1,221,444
Messages
6,159,914
Members
451,603
Latest member
SWahl

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top