Allocation -Target Table

Comments

• VidasMatelis

  July 26

  Check quotes for VFEG.L in Quotes folder and then check in QuotesIntraDay folder. UK symbols sometimes return quotes in pounds, sometimes in pence.
  When you establish that for example historical quotes are in pounds, but intraday in pence, then you can use FactorHistory or FactorIntraDay parameters to adjust your quotes.
  In psConfig.txt file for Yahoo simple list specification format is:
  Symbol,MinDate,MaxDate,IntraDayFlag[Y|N],[DividendFlag[Y|N],FactorHistory,FactorIntraDay,FactorDividend
  
  So you can specify factor just for intraday as follows:
  VFEG.L,,Y,N,,10
  Or there might be a need to specify 0.1 factor, I am not sure in your case.
  
  If factor needed for historical quotes, after changing FactorHistory you might want to delete existing quotes for that symbol in Quotes subfolder.
  
  
• MikeP

  July 27

  Thank you for your reply. I can confirm the prices in Historical and Intraday quotes files were in Pounds.
  
  I reviewed the Demo Source spreadsheet and noted the issue I was seeing could be linked to what is needed to be populated in the SymbolAllocation tab. I had an entry VFEG.L 10% as was in the Allocation Table and it was dividing the total by the 10%.
  
  I removed the above entry from the SymbolAllocation table - and it resolved the miscalculation so all good now.
  
  The reporting is still not accurate because I have 2 Developed World ETF's and 1 Developed World ex-UK Fund and as a result there is an overlap for regions and would like to use the % for each region. As it is not possible to add more than one Index in the Allocation Table. Am I right to understand correctly that I can enter different % by region in the SymbolAllocation table and the PowerBI will consolidate the totals into the Allocation Table?
  
  
  
• VidasMatelis

  July 29

  If the symbol has just one allocation, then you enter that in Symbol table column Allocation.
  If you want to split symbol allocation, then you should use SymbolAllocation table. You have to make sure that for each symbol total allocation sum is 100%.
  When you have multiple allocations per symbol (for example by region), then Allocation Target report will calculate Allo Actual % by splitting symbol total to different allocations.
  
  
• MikeP

  July 29

  Thank you for explaining how to populate the SymbolAllocation Table. I am getting better at using the PortfolioSlicer and intending to start adding actual data.
  
  On the same topic, another question that came to mind is whether to add VFEG.L and assign it 100% in the SymbolSector table like below?
  
  
  
  
  
• VidasMatelis

  July 31

  I am not sure what are you trying to do, but above assignments are not right.
  That is because VFEG.L is TOTAL sum of ALL percent should be 100 and in your assignments just Other has 100% and there are other splits.
• MikeP

  July 31 edited July 31

  Thank you for your reply. Yes, I got a little confused, I was not sure whether to enter splits or as a single .
  
  But then I realized if I enter as above for this ETF that consists of different sectors/regions, then should I want to create reports (which i have yet to figure out) i will not get the granular reporting.
  
  Ignore my question.