Is there a way to import classification / taxonomy data from a CSV file? Say I have an ETF or Fund whose data isn’t available on ETF-Data and so won’t automatically update its sectors and regions. I’d like to have a CSV that has these details and import them… or copy-paste them somewhere even.
3 Likes
It would be handy to have Global Industry Classification Standard codes available. This code demonstrates it’s not neccessarily standard:
>>> import yfinance as yf
>>> symbol = "BHP"
>>> exchange = "ASX"
>>> exchange_code = ".AX"
>>> stock = yf.Ticker(symbol + exchange_code)
>>> stock.info['symbol']
'BHP.AX'
>>>
>>>
>>> stock.info['quoteType']
'EQUITY'
>>> stock.info['sector']
'Basic Materials'
>>> stock.info['industry']
'Other Industrial Metals & Mining'
>>> stock.info['market']
'au_market'
did you ever find an answer to this? i’m trying to do the same thing
Thank you @flywire
I’m considering writing a script to gather the data so the format of the data is whatever it needs to be for PP: JSON, CSV… The problem is that i don’t see anything in the import menu or anywhere else to import taxonomies and i’m trying to avoid writing directly to the portfolio XML since that seems brittle and not the intended way to import data to PP given that there is an “Import” mechanism in it
I’m just trying to design a solution based on what’s available to import it into PP
The process is the same. Start with the desired output (ie enter taxonomies for a security into PP), export the taxonomies, and work out the process to use on the data from there. This includes where to source the taxonomies from.
If there is no option to import the data then it would be appropriate to raise an enhancement request once the rest of the process is worked out and sample data is available.
1 Like
I already did that for everything else to know the right format and how to write it so it’s importable by PP and everything else works. It works for all deposit, securities account and Master Data. The problem is that I can’t export taxonomies. But even if I do find the format, i wouldn’t even know how to import taxonomies
Does this work for you? you say to “export the taxonomies”, can you say where in the UI or CLI to go to export (or import) taxonomies?
i exported the kommer sample’s Master Data and the taxonomies are not there. I exported as Brokerage account and taxonomies are not there
I’m using 0.59.4 on Linux
This is all I got from the kommer exports
Brokerage_Account.csv
Date,Type,Value,Transaction Currency,Gross Amount,Currency Gross Amount,Exchange Rate,Fees,Taxes,Shares,ISIN,WKN,Ticker Symbol,Security Name,Note
2019-01-07T00:00,Buy,"2,946.83",EUR,,,,9.95,0.00,24,IE00B4WXJJ64,A0RL83,EUNH,iShares Core Euro Government Bond UCITS ETF (Dist),
2019-01-07T00:00,Buy,"1,330.25",EUR,,,,9.90,0.00,61,IE00B1YZSC51,A0MZWQ,IQQY,iShares Core MSCI Europe UCITS ETF EUR (Dist),
2019-01-08T00:00,Buy,"1,408.43",EUR,,,,0.00,9.95,331,IE00BDFL4P12,A2DK6R,SXRS,iShares Diversified Commodity Swap UCITS ETF,
2019-01-07T00:00,Buy,"2,122.72",EUR,,,,0.00,9.95,64,IE00B0M63177,A0HGWC,IQQE,iShares MSCI EM UCITS ETF (Dist),
2019-01-07T00:00,Buy,"1,635.28",EUR,,,,0.00,9.95,39,IE00B14X4M10,A0J201,IQQN,iShares MSCI North America UCITS ETF,
2019-01-07T00:00,Buy,486.40,EUR,,,,4.95,0.00,10,LU0392495023,ETF114,X014,Lyxor MSCI Pacific UCITS ETF,
Master_data.csv
ISIN,WKN,Ticker Symbol,Security Name,Currency,Note
"",,^GDAXI,Dax,,
"",,^DJI,Dow Jones,,
"",,^IXIC,NASDAQ Composite,,
"",,,MSCI World,,
IE00B1YZSC51,A0MZWQ,IQQY,iShares Core MSCI Europe UCITS ETF EUR (Dist),EUR,
IE00B14X4M10,A0J201,IQQN,iShares MSCI North America UCITS ETF,EUR,
LU0392495023,ETF114,X014,Lyxor MSCI Pacific UCITS ETF,EUR,
IE00B0M63177,A0HGWC,IQQE,iShares MSCI EM UCITS ETF (Dist),EUR,
IE00B4WXJJ64,A0RL83,EUNH,iShares Core Euro Government Bond UCITS ETF (Dist),EUR,
IE00BDFL4P12,A2DK6R,SXRS,iShares Diversified Commodity Swap UCITS ETF,EUR,
"",,DE,Germany (Harmonized Consumer Priced Index),,
The main issue is what Taxonomy data source you have found and what you want to load. To export kommer taxonomies you need to View, each Taxonomy, and Export data as csv.
I can’t see a way of importing Taxonomies. That will be an enhacement request when the data files have been designed.
Asset Classes
Levels 1,Levels 2,Levels 3,Weight,Color,ACTUAL %,ACTUAL % of Total,ACTUAL Value
Asset Classes,,,,,100.00,100.00,"12,875.76"
Asset Classes,Cash,,,,5.91,5.91,760.92
Asset Classes,Cash,Deposit Account,100.00,,34.29,2.03,260.92
Asset Classes,Cash,Call Money Account,100.00,,65.71,3.88,500.00
Asset Classes,Equity,,,,55.81,55.81,"7,185.76"
Asset Classes,Equity,iShares Core MSCI Europe UCITS ETF EUR (Dist),100.00,,23.06,12.87,"1,657.37"
Asset Classes,Equity,iShares MSCI EM UCITS ETF (Dist),100.00,,31.41,17.53,"2,256.83"
Asset Classes,Equity,iShares MSCI North America UCITS ETF,100.00,,37.80,21.09,"2,715.96"
Asset Classes,Equity,Lyxor MSCI Pacific UCITS ETF,100.00,,7.73,4.32,555.60
Asset Classes,Equity,Dax,100.00,,0.00,0.00,0.00
Asset Classes,Equity,Dow Jones,100.00,,0.00,0.00,0.00
Asset Classes,Equity,NASDAQ Composite,100.00,,0.00,0.00,0.00
Asset Classes,Debt,,,,20.80,20.80,"2,678.28"
Asset Classes,Debt,iShares Core Euro Government Bond UCITS ETF (Dist),100.00,,100.00,20.80,"2,678.28"
Asset Classes,Real Estate,,,,0.00,0.00,0.00
Asset Classes,Commodity,,,,17.48,17.48,"2,250.80"
Asset Classes,Commodity,iShares Diversified Commodity Swap UCITS ETF,100.00,,100.00,17.48,"2,250.80"
Without Classification,,,,,0.00,0.00,0.00
Without Classification,Germany (Harmonized Consumer Priced Index),,100.00,,0.00,0.00,0.00
Without Classification,MSCI World,,100.00,,0.00,0.00,0.00
Asset Allocation
Levels 1,Levels 2,Levels 3,Levels 4,Weight,Color,ACTUAL %,ACTUAL % of Total,ACTUAL Value
Asset Allocation,,,,,,100.00,100.00,"12,875.76"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),,,,,73.29,73.29,"9,436.56"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),USA / North America,,,,28.78,21.09,"2,715.96"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),USA / North America,iShares MSCI North America UCITS ETF,100.00,,100.00,21.09,"2,715.96"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Western Europe,,,,17.56,12.87,"1,657.37"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Western Europe,iShares Core MSCI Europe UCITS ETF EUR (Dist),100.00,,100.00,12.87,"1,657.37"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Japan / Australia,,,,5.89,4.32,555.60
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Japan / Australia,Lyxor MSCI Pacific UCITS ETF,100.00,,100.00,4.32,555.60
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Assets Emerging Markets,,,,23.92,17.53,"2,256.83"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Assets Emerging Markets,iShares MSCI EM UCITS ETF (Dist),100.00,,100.00,17.53,"2,256.83"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Real Estate Worldwide,,,,0.00,0.00,0.00
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Commodities,,,,23.85,17.48,"2,250.80"
Asset Allocation,Risk-Based Portfolio Part (World Portfolio),Commodities,iShares Diversified Commodity Swap UCITS ETF,100.00,,100.00,17.48,"2,250.80"
Asset Allocation,Risk-Free Portfolio Part,,,,,26.71,26.71,"3,439.20"
Asset Allocation,Risk-Free Portfolio Part,Deposit Account,,100.00,,7.59,2.03,260.92
Asset Allocation,Risk-Free Portfolio Part,Call Money Account,,100.00,,14.54,3.88,500.00
Asset Allocation,Risk-Free Portfolio Part,iShares Core Euro Government Bond UCITS ETF (Dist),,100.00,,77.88,20.80,"2,678.28"
Without Classification,,,,,,0.00,0.00,0.00
Without Classification,Dax,,,100.00,,0.00,0.00,0.00
Without Classification,Dow Jones,,,100.00,,0.00,0.00,0.00
Without Classification,Germany (Harmonized Consumer Priced Index),,,100.00,,0.00,0.00,0.00
Without Classification,MSCI World,,,100.00,,0.00,0.00,0.00
Without Classification,NASDAQ Composite,,,100.00,,0.00,0.00,0.00
Industries_(GICS,_Sectors)
Levels 1,Levels 2,Levels 3,Weight,Color,ACTUAL %,ACTUAL % of Total,ACTUAL Value
"Industries (GICS, Sectors)",,,,,75.16,75.16,"9,677.88"
"Industries (GICS, Sectors)",Energy,,,,2.59,1.95,251.12
"Industries (GICS, Sectors)",Energy,iShares Core MSCI Europe UCITS ETF EUR (Dist),4.42,,29.17,0.57,73.26
"Industries (GICS, Sectors)",Energy,iShares MSCI North America UCITS ETF,2.56,,27.69,0.54,69.53
"Industries (GICS, Sectors)",Energy,iShares MSCI EM UCITS ETF (Dist),4.80,,43.14,0.84,108.33
"Industries (GICS, Sectors)",Materials,,,,4.34,3.26,420.33
"Industries (GICS, Sectors)",Materials,iShares Core MSCI Europe UCITS ETF EUR (Dist),8.25,,32.53,1.06,136.73
"Industries (GICS, Sectors)",Materials,iShares MSCI North America UCITS ETF,3.02,,19.51,0.64,82.02
"Industries (GICS, Sectors)",Materials,Lyxor MSCI Pacific UCITS ETF,7.36,,9.73,0.32,40.89
"Industries (GICS, Sectors)",Materials,iShares MSCI EM UCITS ETF (Dist),7.12,,38.23,1.25,160.69
"Industries (GICS, Sectors)",Industrials,,,,6.77,5.09,654.76
"Industries (GICS, Sectors)",Industrials,iShares Core MSCI Europe UCITS ETF EUR (Dist),14.47,,36.63,1.86,239.82
"Industries (GICS, Sectors)",Industrials,iShares MSCI North America UCITS ETF,8.41,,34.88,1.77,228.41
"Industries (GICS, Sectors)",Industrials,Lyxor MSCI Pacific UCITS ETF,16.43,,13.94,0.71,91.29
"Industries (GICS, Sectors)",Industrials,iShares MSCI EM UCITS ETF (Dist),4.22,,14.55,0.74,95.24
"Industries (GICS, Sectors)",Consumer Discretionary,,,,10.48,7.88,"1,014.42"
"Industries (GICS, Sectors)",Consumer Discretionary,iShares Core MSCI Europe UCITS ETF EUR (Dist),11.43,,18.67,1.47,189.44
"Industries (GICS, Sectors)",Consumer Discretionary,iShares MSCI North America UCITS ETF,11.92,,31.91,2.51,323.74
"Industries (GICS, Sectors)",Consumer Discretionary,Lyxor MSCI Pacific UCITS ETF,14.46,,7.92,0.62,80.34
"Industries (GICS, Sectors)",Consumer Discretionary,iShares MSCI EM UCITS ETF (Dist),18.65,,41.49,3.27,420.90
"Industries (GICS, Sectors)",Consumer Staples,,,,5.73,4.31,554.58
"Industries (GICS, Sectors)",Consumer Staples,iShares Core MSCI Europe UCITS ETF EUR (Dist),13.33,,39.84,1.72,220.93
"Industries (GICS, Sectors)",Consumer Staples,iShares MSCI North America UCITS ETF,6.12,,29.97,1.29,166.22
"Industries (GICS, Sectors)",Consumer Staples,Lyxor MSCI Pacific UCITS ETF,6.90,,6.91,0.30,38.34
"Industries (GICS, Sectors)",Consumer Staples,iShares MSCI EM UCITS ETF (Dist),5.72,,23.28,1.00,129.09
"Industries (GICS, Sectors)",Health Care,,,,7.72,5.81,747.49
"Industries (GICS, Sectors)",Health Care,iShares Core MSCI Europe UCITS ETF EUR (Dist),14.20,,31.49,1.83,235.35
"Industries (GICS, Sectors)",Health Care,iShares MSCI North America UCITS ETF,12.90,,46.87,2.72,350.36
"Industries (GICS, Sectors)",Health Care,Lyxor MSCI Pacific UCITS ETF,10.27,,7.63,0.44,57.06
"Industries (GICS, Sectors)",Health Care,iShares MSCI EM UCITS ETF (Dist),4.64,,14.01,0.81,104.72
"Industries (GICS, Sectors)",Financials,,,,11.14,8.38,"1,078.45"
"Industries (GICS, Sectors)",Financials,iShares Core MSCI Europe UCITS ETF EUR (Dist),15.60,,23.97,2.01,258.55
"Industries (GICS, Sectors)",Financials,iShares MSCI North America UCITS ETF,11.10,,27.95,2.34,301.47
"Industries (GICS, Sectors)",Financials,Lyxor MSCI Pacific UCITS ETF,17.96,,9.25,0.78,99.79
"Industries (GICS, Sectors)",Financials,iShares MSCI EM UCITS ETF (Dist),18.55,,38.82,3.25,418.64
"Industries (GICS, Sectors)",Information Technology,,,,14.39,10.82,"1,392.97"
"Industries (GICS, Sectors)",Information Technology,iShares Core MSCI Europe UCITS ETF EUR (Dist),7.55,,8.98,0.97,125.13
"Industries (GICS, Sectors)",Information Technology,iShares MSCI North America UCITS ETF,28.07,,54.73,5.92,762.37
"Industries (GICS, Sectors)",Information Technology,Lyxor MSCI Pacific UCITS ETF,10.47,,4.18,0.45,58.17
"Industries (GICS, Sectors)",Information Technology,iShares MSCI EM UCITS ETF (Dist),19.82,,32.11,3.47,447.30
"Industries (GICS, Sectors)",Communication Services,,,,6.77,5.09,655.62
"Industries (GICS, Sectors)",Communication Services,iShares Core MSCI Europe UCITS ETF EUR (Dist),3.94,,9.96,0.51,65.30
"Industries (GICS, Sectors)",Communication Services,iShares MSCI North America UCITS ETF,10.46,,43.33,2.21,284.09
"Industries (GICS, Sectors)",Communication Services,Lyxor MSCI Pacific UCITS ETF,7.51,,6.36,0.32,41.73
"Industries (GICS, Sectors)",Communication Services,iShares MSCI EM UCITS ETF (Dist),11.72,,40.34,2.05,264.50
"Industries (GICS, Sectors)",Utilities,,,,1.62,1.22,156.90
"Industries (GICS, Sectors)",Utilities,iShares Core MSCI Europe UCITS ETF EUR (Dist),4.96,,52.40,0.64,82.21
"Industries (GICS, Sectors)",Utilities,iShares MSCI North America UCITS ETF,2.75,,47.60,0.58,74.69
"Industries (GICS, Sectors)",Real Estate,,,,0.79,0.60,76.71
"Industries (GICS, Sectors)",Real Estate,Lyxor MSCI Pacific UCITS ETF,5.44,,39.40,0.23,30.22
"Industries (GICS, Sectors)",Real Estate,iShares MSCI EM UCITS ETF (Dist),2.06,,60.60,0.36,46.49
"Industries (GICS, Sectors)",GOVERNMENT,,,,27.64,20.77,"2,674.53"
"Industries (GICS, Sectors)",GOVERNMENT,iShares Core Euro Government Bond UCITS ETF (Dist),99.86,,100.00,20.77,"2,674.53"
Without Classification,,,,,24.84,24.84,"3,197.90"
Without Classification,Call Money Account,,100.00,,15.64,3.88,500.00
Without Classification,Dax,,100.00,,0.00,0.00,0.00
Without Classification,Deposit Account,,100.00,,8.16,2.03,260.92
Without Classification,Dow Jones,,100.00,,0.00,0.00,0.00
Without Classification,Germany (Harmonized Consumer Priced Index),,100.00,,0.00,0.00,0.00
Without Classification,iShares Core Euro Government Bond UCITS ETF (Dist),,0.14,,0.12,0.03,3.75
Without Classification,iShares Core MSCI Europe UCITS ETF EUR (Dist),,1.85,,0.96,0.24,30.66
Without Classification,iShares Diversified Commodity Swap UCITS ETF,,100.00,,70.38,17.48,"2,250.80"
Without Classification,iShares MSCI EM UCITS ETF (Dist),,2.70,,1.91,0.47,60.93
Without Classification,iShares MSCI North America UCITS ETF,,2.69,,2.28,0.57,73.06
Without Classification,Lyxor MSCI Pacific UCITS ETF,,3.20,,0.56,0.14,17.78
Without Classification,MSCI World,,100.00,,0.00,0.00,0.00
Without Classification,NASDAQ Composite,,100.00,,0.00,0.00,0.00
Regions
Levels 1,Levels 2,Levels 3,Levels 4,Levels 5,Weight,Color,ACTUAL %,ACTUAL % of Total,ACTUAL Value
Regions,,,,,,,73.83,73.83,"9,506.42"
Regions,Europe,,,,,,45.04,33.25,"4,281.42"
Regions,Europe,North Europe,,,,,15.11,5.02,646.84
Regions,Europe,North Europe,Denmark,,,,10.27,0.52,66.46
Regions,Europe,North Europe,Denmark,iShares Core MSCI Europe UCITS ETF EUR (Dist),4.01,,100.00,0.52,66.46
Regions,Europe,North Europe,Estonia,,,,0.00,0.00,0.00
Regions,Europe,North Europe,Finland,,,,10.09,0.51,65.27
Regions,Europe,North Europe,Finland,iShares Core MSCI Europe UCITS ETF EUR (Dist),1.66,,42.15,0.21,27.51
Regions,Europe,North Europe,Finland,iShares Core Euro Government Bond UCITS ETF (Dist),1.41,,57.85,0.29,37.76
Regions,Europe,North Europe,Great Britain,,,,57.83,2.91,374.07
Regions,Europe,North Europe,Great Britain,iShares Core MSCI Europe UCITS ETF EUR (Dist),22.57,,100.00,2.91,374.07
Regions,Europe,North Europe,Iceland,,,,0.00,0.00,0.00
Regions,Europe,North Europe,Ireland,,,,8.15,0.41,52.70
Regions,Europe,North Europe,Ireland,Lyxor MSCI Pacific UCITS ETF,0.23,,2.43,0.01,1.28
Regions,Europe,North Europe,Ireland,iShares Core Euro Government Bond UCITS ETF (Dist),1.92,,97.57,0.40,51.42
Regions,Europe,North Europe,Latvia,,,,0.00,0.00,0.00
Regions,Europe,North Europe,Lithuania,,,,0.00,0.00,0.00
Regions,Europe,North Europe,Norway,,,,0.00,0.00,0.00
Regions,Europe,North Europe,Sweden,,,,13.66,0.69,88.34
Regions,Europe,North Europe,Sweden,iShares Core MSCI Europe UCITS ETF EUR (Dist),5.33,,100.00,0.69,88.34
Regions,Europe,West Europe,,,,,56.21,18.69,"2,406.63"
Regions,Europe,West Europe,Austria,,,,3.92,0.73,94.28
Regions,Europe,West Europe,Austria,iShares Core Euro Government Bond UCITS ETF (Dist),3.52,,100.00,0.73,94.28
Regions,Europe,West Europe,Belgium,,,,6.49,1.21,156.14
Regions,Europe,West Europe,Belgium,iShares Core Euro Government Bond UCITS ETF (Dist),5.83,,100.00,1.21,156.14
Regions,Europe,West Europe,France,,,,39.78,7.43,957.29
Regions,Europe,West Europe,France,iShares Core MSCI Europe UCITS ETF EUR (Dist),17.78,,30.78,2.29,294.68
Regions,Europe,West Europe,France,iShares Core Euro Government Bond UCITS ETF (Dist),24.74,,69.22,5.15,662.61
Regions,Europe,West Europe,Germany,,,,30.13,5.63,725.17
Regions,Europe,West Europe,Germany,iShares Core MSCI Europe UCITS ETF EUR (Dist),14.99,,34.26,1.93,248.44
Regions,Europe,West Europe,Germany,iShares Core Euro Government Bond UCITS ETF (Dist),17.80,,65.74,3.70,476.73
Regions,Europe,West Europe,Liechtenstein,,,,0.00,0.00,0.00
Regions,Europe,West Europe,Luxembourg,,,,0.00,0.00,0.00
Regions,Europe,West Europe,Monaco,,,,0.00,0.00,0.00
Regions,Europe,West Europe,Netherlands,,,,9.29,1.74,223.49
Regions,Europe,West Europe,Netherlands,iShares Core MSCI Europe UCITS ETF EUR (Dist),6.18,,45.83,0.80,102.43
Regions,Europe,West Europe,Netherlands,iShares Core Euro Government Bond UCITS ETF (Dist),4.52,,54.17,0.94,121.06
Regions,Europe,West Europe,Switzerland,,,,10.40,1.94,250.26
Regions,Europe,West Europe,Switzerland,iShares Core MSCI Europe UCITS ETF EUR (Dist),15.10,,100.00,1.94,250.26
Regions,Europe,East Europe,,,,,1.57,0.52,67.03
Regions,Europe,East Europe,Belarus,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Bulgaria,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Czech Republic,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Hungary,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Poland,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Romania,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Russia,,,,100.00,0.52,67.03
Regions,Europe,East Europe,Russia,iShares MSCI EM UCITS ETF (Dist),2.97,,100.00,0.52,67.03
Regions,Europe,East Europe,Slovakia,,,,0.00,0.00,0.00
Regions,Europe,East Europe,Ukraine,,,,0.00,0.00,0.00
Regions,Europe,South Europe,,,,,27.12,9.02,"1,160.92"
Regions,Europe,South Europe,Albania,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Andorra,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Bosnia and Herzegovina,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Croatia,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Gibraltar,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Greece,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Italy,,,,56.97,5.14,661.37
Regions,Europe,South Europe,Italy,iShares Core MSCI Europe UCITS ETF EUR (Dist),3.82,,9.57,0.49,63.31
Regions,Europe,South Europe,Italy,iShares Core Euro Government Bond UCITS ETF (Dist),22.33,,90.43,4.64,598.06
Regions,Europe,South Europe,Malta,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Montenegro,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Portugal,,,,5.21,0.47,60.53
Regions,Europe,South Europe,Portugal,iShares Core Euro Government Bond UCITS ETF (Dist),2.26,,100.00,0.47,60.53
Regions,Europe,South Europe,San Marino,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Serbia,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Slovakia,,,,0.00,0.00,0.00
Regions,Europe,South Europe,Spain,,,,37.82,3.41,439.02
Regions,Europe,South Europe,Spain,iShares Core MSCI Europe UCITS ETF EUR (Dist),3.93,,14.84,0.51,65.13
Regions,Europe,South Europe,Spain,iShares Core Euro Government Bond UCITS ETF (Dist),13.96,,85.16,2.90,373.89
Regions,Europe,South Europe,Vatican city,,,,0.00,0.00,0.00
Regions,America,,,,,,29.83,22.03,"2,836.10"
Regions,America,North America,,,,,96.88,21.34,"2,747.63"
Regions,America,North America,Bermuda,,,,0.00,0.00,0.00
Regions,America,North America,Canada,,,,4.50,0.96,123.58
Regions,America,North America,Canada,iShares MSCI North America UCITS ETF,4.55,,100.00,0.96,123.58
Regions,America,North America,Greenland,,,,0.00,0.00,0.00
Regions,America,North America,Mexico,,,,1.43,0.30,39.27
Regions,America,North America,Mexico,iShares MSCI EM UCITS ETF (Dist),1.74,,100.00,0.30,39.27
Regions,America,North America,Saint-Pierre and Miquelon,,,,0.00,0.00,0.00
Regions,America,North America,United States,,,,94.07,20.07,"2,584.78"
Regions,America,North America,United States,iShares MSCI North America UCITS ETF,95.17,,100.00,20.07,"2,584.78"
Regions,America,Central America,,,,,0.00,0.00,0.00
Regions,America,Central America,Belize,,,,0.00,0.00,0.00
Regions,America,Central America,Costa Rica,,,,0.00,0.00,0.00
Regions,America,Central America,El Salvador,,,,0.00,0.00,0.00
Regions,America,Central America,Guatemala,,,,0.00,0.00,0.00
Regions,America,Central America,Honduras,,,,0.00,0.00,0.00
Regions,America,Central America,Nicaragua,,,,0.00,0.00,0.00
Regions,America,Central America,Panama,,,,0.00,0.00,0.00
Regions,America,Caribbean,,,,,0.00,0.00,0.00
Regions,America,Caribbean,American Virgin Islands,,,,0.00,0.00,0.00
Regions,America,Caribbean,Anguilla,,,,0.00,0.00,0.00
Regions,America,Caribbean,Antigua and Barbuda,,,,0.00,0.00,0.00
Regions,America,Caribbean,Aruba,,,,0.00,0.00,0.00
Regions,America,Caribbean,Bahamas,,,,0.00,0.00,0.00
Regions,America,Caribbean,Barbados,,,,0.00,0.00,0.00
Regions,America,Caribbean,British Virgin Islands,,,,0.00,0.00,0.00
Regions,America,Caribbean,Cayman Islands,,,,0.00,0.00,0.00
Regions,America,Caribbean,Cuba,,,,0.00,0.00,0.00
Regions,America,Caribbean,Dominica,,,,0.00,0.00,0.00
Regions,America,Caribbean,Dominican Republic,,,,0.00,0.00,0.00
Regions,America,Caribbean,Grenada,,,,0.00,0.00,0.00
Regions,America,Caribbean,Guadeloupe,,,,0.00,0.00,0.00
Regions,America,Caribbean,Haiti,,,,0.00,0.00,0.00
Regions,America,Caribbean,Jamaica,,,,0.00,0.00,0.00
Regions,America,Caribbean,Martinique,,,,0.00,0.00,0.00
Regions,America,Caribbean,Montserrat,,,,0.00,0.00,0.00
Regions,America,Caribbean,Puerto Rico,,,,0.00,0.00,0.00
Regions,America,Caribbean,Saint Martin,,,,0.00,0.00,0.00
Regions,America,Caribbean,Sint Maarten,,,,0.00,0.00,0.00
Regions,America,Caribbean,St. Barth�lemy,,,,0.00,0.00,0.00
Regions,America,Caribbean,St. Kitts and Nevis,,,,0.00,0.00,0.00
Regions,America,Caribbean,St. Lucia,,,,0.00,0.00,0.00
Regions,America,Caribbean,St. Vincent and the Grenadines,,,,0.00,0.00,0.00
Regions,America,Caribbean,Trinidad and Tobago,,,,0.00,0.00,0.00
Regions,America,Caribbean,Turks and Caicos Islands,,,,0.00,0.00,0.00
Regions,America,South America,,,,,3.12,0.69,88.47
Regions,America,South America,Argentina,,,,0.00,0.00,0.00
Regions,America,South America,Bolivia,,,,0.00,0.00,0.00
Regions,America,South America,Brazil,,,,100.00,0.69,88.47
Regions,America,South America,Brazil,iShares MSCI EM UCITS ETF (Dist),3.92,,100.00,0.69,88.47
Regions,America,South America,Chile,,,,0.00,0.00,0.00
Regions,America,South America,Colombia,,,,0.00,0.00,0.00
Regions,America,South America,Ecuador,,,,0.00,0.00,0.00
Regions,America,South America,Falkland Islands,,,,0.00,0.00,0.00
Regions,America,South America,French Guiana,,,,0.00,0.00,0.00
Regions,America,South America,Guyana,,,,0.00,0.00,0.00
Regions,America,South America,Paraguay,,,,0.00,0.00,0.00
Regions,America,South America,Peru,,,,0.00,0.00,0.00
Regions,America,South America,Suriname,,,,0.00,0.00,0.00
Regions,America,South America,Uruguay,,,,0.00,0.00,0.00
Regions,America,South America,Venezuela,,,,0.00,0.00,0.00
Regions,Asia,,,,,,23.11,17.06,"2,196.66"
Regions,Asia,West Asia (Near Asia),,,,,1.99,0.34,43.78
Regions,Asia,West Asia (Near Asia),Armenia,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Azerbaijan,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Bahrain,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Cyprus,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Georgia,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Iraq,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Israel,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Jordan,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Kuwait,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Lebanon,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Oman,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Qatar,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Saudi Arabia,,,,100.00,0.34,43.78
Regions,Asia,West Asia (Near Asia),Saudi Arabia,iShares MSCI EM UCITS ETF (Dist),1.94,,100.00,0.34,43.78
Regions,Asia,West Asia (Near Asia),Syria,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Turkey,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),United Arab Emirates,,,,0.00,0.00,0.00
Regions,Asia,West Asia (Near Asia),Yemen,,,,0.00,0.00,0.00
Regions,Asia,Central Asia,,,,,0.00,0.00,0.00
Regions,Asia,Central Asia,Kazakhstan,,,,0.00,0.00,0.00
Regions,Asia,Central Asia,Kyrgyzstan,,,,0.00,0.00,0.00
Regions,Asia,Central Asia,Tailandia,,,,0.00,0.00,0.00
Regions,Asia,Central Asia,Turkmenistan,,,,0.00,0.00,0.00
Regions,Asia,Central Asia,Uzbekistan,,,,0.00,0.00,0.00
Regions,Asia,East Asia,,,,,86.01,14.67,"1,889.41"
Regions,Asia,East Asia,China,,,,47.09,6.91,889.78
Regions,Asia,East Asia,China,Lyxor MSCI Pacific UCITS ETF,0.39,,0.24,0.02,2.17
Regions,Asia,East Asia,China,iShares MSCI EM UCITS ETF (Dist),39.33,,99.76,6.89,887.61
Regions,Asia,East Asia,Hong Kong,,,,2.39,0.35,45.17
Regions,Asia,East Asia,Hong Kong,Lyxor MSCI Pacific UCITS ETF,8.13,,100.00,0.35,45.17
Regions,Asia,East Asia,Japan,,,,20.06,2.94,378.97
Regions,Asia,East Asia,Japan,Lyxor MSCI Pacific UCITS ETF,68.21,,100.00,2.94,378.97
Regions,Asia,East Asia,Macau,,,,0.00,0.00,0.00
Regions,Asia,East Asia,Mongolia,,,,0.00,0.00,0.00
Regions,Asia,East Asia,North Korea,,,,0.00,0.00,0.00
Regions,Asia,East Asia,South Korea,,,,15.44,2.27,291.81
Regions,Asia,East Asia,South Korea,iShares MSCI EM UCITS ETF (Dist),12.93,,100.00,2.27,291.81
Regions,Asia,East Asia,Taiwan,,,,15.01,2.20,283.68
Regions,Asia,East Asia,Taiwan,iShares MSCI EM UCITS ETF (Dist),12.57,,100.00,2.20,283.68
Regions,Asia,South Asia,,,,,9.41,1.61,206.73
Regions,Asia,South Asia,Afghanistan,,,,0.00,0.00,0.00
Regions,Asia,South Asia,Bangladesh,,,,0.00,0.00,0.00
Regions,Asia,South Asia,Bhutan,,,,0.00,0.00,0.00
Regions,Asia,South Asia,India,,,,100.00,1.61,206.73
Regions,Asia,South Asia,India,iShares MSCI EM UCITS ETF (Dist),9.16,,100.00,1.61,206.73
Regions,Asia,South Asia,Iran,,,,0.00,0.00,0.00
Regions,Asia,South Asia,Maldives,,,,0.00,0.00,0.00
Regions,Asia,South Asia,Nepal,,,,0.00,0.00,0.00
Regions,Asia,South Asia,Pakistan,,,,0.00,0.00,0.00
Regions,Asia,South Asia,Sri Lanka,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,,,,,2.58,0.44,56.74
Regions,Asia,Southeast Asia,Brunei Darussalam,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Cambodia,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Indonesia,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Laos,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Malaysia,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Myanmar,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Philippines,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Singapore,,,,28.00,0.12,15.89
Regions,Asia,Southeast Asia,Singapore,Lyxor MSCI Pacific UCITS ETF,2.86,,100.00,0.12,15.89
Regions,Asia,Southeast Asia,Thailand,,,,72.00,0.32,40.85
Regions,Asia,Southeast Asia,Thailand,iShares MSCI EM UCITS ETF (Dist),1.81,,100.00,0.32,40.85
Regions,Asia,Southeast Asia,Timor Leste,,,,0.00,0.00,0.00
Regions,Asia,Southeast Asia,Vietnam,,,,0.00,0.00,0.00
Regions,Africa,,,,,,0.85,0.62,80.34
Regions,Africa,North Africa,,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Algeria,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Egypt,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Libya,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Morocco,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Sudan,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Tunisia,,,,0.00,0.00,0.00
Regions,Africa,North Africa,Western Sahara,,,,0.00,0.00,0.00
Regions,Africa,West Africa,,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Benin,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Burkina Faso,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Cape Verde,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Gambia,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Ghana,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Guinea,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Guinea-Bissau,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Liberia,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Mali,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Mauritania,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Niger,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Nigeria,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Senegal,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Sierra Leone,,,,0.00,0.00,0.00
Regions,Africa,West Africa,St. Helena,,,,0.00,0.00,0.00
Regions,Africa,West Africa,Togo,,,,0.00,0.00,0.00
Regions,Africa,East Africa,,,,,0.00,0.00,0.00
Regions,Africa,East Africa,British Indian Ocean Territory,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Burundi,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Comoros,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Djibouti,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Eritrea,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Ethiopia,,,,0.00,0.00,0.00
Regions,Africa,East Africa,French Southern and Antarctic Lands,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Kenya,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Madagascar,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Malawi,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Mauritius,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Mayotte,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Mozambique,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Reunion,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Rwanda,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Seychelles,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Somalia,,,,0.00,0.00,0.00
Regions,Africa,East Africa,South Sudan,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Tanzania,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Uganda,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Zambia,,,,0.00,0.00,0.00
Regions,Africa,East Africa,Zimbabwe,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Angola,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Cameroon,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Central African Republic,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Chad,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Democratic Republic of Congo,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Gabon,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Republic of the Congo,,,,0.00,0.00,0.00
Regions,Africa,Central Africa,Sao Tome and Principe,,,,0.00,0.00,0.00
Regions,Africa,South Africa,,,,,100.00,0.62,80.34
Regions,Africa,South Africa,Lesotho,,,,0.00,0.00,0.00
Regions,Africa,South Africa,Namibia,,,,0.00,0.00,0.00
Regions,Africa,South Africa,South Africa,,,,100.00,0.62,80.34
Regions,Africa,South Africa,South Africa,iShares MSCI EM UCITS ETF (Dist),3.56,,100.00,0.62,80.34
Regions,Oceania,,,,,,1.18,0.87,111.90
Regions,Oceania,Australia and New Zealand,,,,,100.00,0.87,111.90
Regions,Oceania,Australia and New Zealand,Australia,,,,94.74,0.82,106.01
Regions,Oceania,Australia and New Zealand,Australia,Lyxor MSCI Pacific UCITS ETF,19.08,,100.00,0.82,106.01
Regions,Oceania,Australia and New Zealand,New Zealand,,,,5.26,0.05,5.89
Regions,Oceania,Australia and New Zealand,New Zealand,Lyxor MSCI Pacific UCITS ETF,1.06,,100.00,0.05,5.89
Regions,Oceania,Australia and New Zealand,Norfolk Island,,,,0.00,0.00,0.00
Regions,Oceania,Melanesia,,,,,0.00,0.00,0.00
Regions,Oceania,Melanesia,Fiji,,,,0.00,0.00,0.00
Regions,Oceania,Melanesia,New Caledonia,,,,0.00,0.00,0.00
Regions,Oceania,Melanesia,Papua New Guinea,,,,0.00,0.00,0.00
Regions,Oceania,Melanesia,Vanuatu,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Guam,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Kiribati,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Marshall Islands,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Micronesia,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Nauru,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Northern Mariana Islands,,,,0.00,0.00,0.00
Regions,Oceania,Micronesia,Palau,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,American Samoa,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Cook Islands,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,French Polynesia,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Niue,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Pitcairn Islands,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Samoa,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Tokelau,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Tonga,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Tuvalu,,,,0.00,0.00,0.00
Regions,Oceania,Polynesia,Wallis and Futuna,,,,0.00,0.00,0.00
Without Classification,,,,,,,26.17,26.17,"3,369.34"
Without Classification,Call Money Account,,,,100.00,,14.84,3.88,500.00
Without Classification,Dax,,,,100.00,,0.00,0.00,0.00
Without Classification,Deposit Account,,,,100.00,,7.74,2.03,260.92
Without Classification,Dow Jones,,,,100.00,,0.00,0.00,0.00
Without Classification,Germany (Harmonized Consumer Priced Index),,,,100.00,,0.00,0.00,0.00
Without Classification,iShares Core Euro Government Bond UCITS ETF (Dist),,,,1.71,,1.36,0.36,45.80
Without Classification,iShares Core MSCI Europe UCITS ETF EUR (Dist),,,,4.63,,2.28,0.60,76.74
Without Classification,iShares Diversified Commodity Swap UCITS ETF,,,,100.00,,66.80,17.48,"2,250.80"
Without Classification,iShares MSCI EM UCITS ETF (Dist),,,,10.07,,6.74,1.77,227.26
Without Classification,iShares MSCI North America UCITS ETF,,,,0.28,,0.23,0.06,7.60
Without Classification,Lyxor MSCI Pacific UCITS ETF,,,,0.04,,0.01,0.00,0.22
Without Classification,MSCI World,,,,100.00,,0.00,0.00,0.00
Without Classification,NASDAQ Composite,,,,100.00,,0.00,0.00,0.00
Regions_(MSCI)
Levels 1,Levels 2,Levels 3,Levels 4,Levels 5,Weight,Color,ACTUAL %,ACTUAL % of Total,ACTUAL Value
Regions (MSCI),,,,,,,73.83,73.83,"9,506.42"
Regions (MSCI),World,,,,,,78.63,58.05,"7,474.68"
Regions (MSCI),World,Americas,,,,,36.23,21.03,"2,708.36"
Regions (MSCI),World,Americas,Canada,,,,4.56,0.96,123.58
Regions (MSCI),World,Americas,Canada,iShares MSCI North America UCITS ETF,4.55,,100.00,0.96,123.58
Regions (MSCI),World,Americas,United States,,,,95.44,20.07,"2,584.78"
Regions (MSCI),World,Americas,United States,iShares MSCI North America UCITS ETF,95.17,,100.00,20.07,"2,584.78"
Regions (MSCI),World,Europe & Middle East,,,,,56.38,32.73,"4,214.39"
Regions (MSCI),World,Europe & Middle East,Austria,,,,2.24,0.73,94.28
Regions (MSCI),World,Europe & Middle East,Austria,iShares Core Euro Government Bond UCITS ETF (Dist),3.52,,100.00,0.73,94.28
Regions (MSCI),World,Europe & Middle East,Belgium,,,,3.70,1.21,156.14
Regions (MSCI),World,Europe & Middle East,Belgium,iShares Core Euro Government Bond UCITS ETF (Dist),5.83,,100.00,1.21,156.14
Regions (MSCI),World,Europe & Middle East,Denmark,,,,1.58,0.52,66.46
Regions (MSCI),World,Europe & Middle East,Denmark,iShares Core MSCI Europe UCITS ETF EUR (Dist),4.01,,100.00,0.52,66.46
Regions (MSCI),World,Europe & Middle East,Finland,,,,1.55,0.51,65.27
Regions (MSCI),World,Europe & Middle East,Finland,iShares Core MSCI Europe UCITS ETF EUR (Dist),1.66,,42.15,0.21,27.51
Regions (MSCI),World,Europe & Middle East,Finland,iShares Core Euro Government Bond UCITS ETF (Dist),1.41,,57.85,0.29,37.76
Regions (MSCI),World,Europe & Middle East,France,,,,22.71,7.43,957.29
Regions (MSCI),World,Europe & Middle East,France,iShares Core MSCI Europe UCITS ETF EUR (Dist),17.78,,30.78,2.29,294.68
Regions (MSCI),World,Europe & Middle East,France,iShares Core Euro Government Bond UCITS ETF (Dist),24.74,,69.22,5.15,662.61
Regions (MSCI),World,Europe & Middle East,Germany,,,,17.21,5.63,725.17
Regions (MSCI),World,Europe & Middle East,Germany,iShares Core MSCI Europe UCITS ETF EUR (Dist),14.99,,34.26,1.93,248.44
Regions (MSCI),World,Europe & Middle East,Germany,iShares Core Euro Government Bond UCITS ETF (Dist),17.80,,65.74,3.70,476.73
Regions (MSCI),World,Europe & Middle East,Ireland,,,,1.25,0.41,52.70
Regions (MSCI),World,Europe & Middle East,Ireland,Lyxor MSCI Pacific UCITS ETF,0.23,,2.43,0.01,1.28
Regions (MSCI),World,Europe & Middle East,Ireland,iShares Core Euro Government Bond UCITS ETF (Dist),1.92,,97.57,0.40,51.42
Regions (MSCI),World,Europe & Middle East,Israel,,,,0.00,0.00,0.00
Regions (MSCI),World,Europe & Middle East,Italy,,,,15.69,5.14,661.37
Regions (MSCI),World,Europe & Middle East,Italy,iShares Core MSCI Europe UCITS ETF EUR (Dist),3.82,,9.57,0.49,63.31
Regions (MSCI),World,Europe & Middle East,Italy,iShares Core Euro Government Bond UCITS ETF (Dist),22.33,,90.43,4.64,598.06
Regions (MSCI),World,Europe & Middle East,Netherlands,,,,5.30,1.74,223.49
Regions (MSCI),World,Europe & Middle East,Netherlands,iShares Core MSCI Europe UCITS ETF EUR (Dist),6.18,,45.83,0.80,102.43
Regions (MSCI),World,Europe & Middle East,Netherlands,iShares Core Euro Government Bond UCITS ETF (Dist),4.52,,54.17,0.94,121.06
Regions (MSCI),World,Europe & Middle East,Norway,,,,0.00,0.00,0.00
Regions (MSCI),World,Europe & Middle East,Portugal,,,,1.44,0.47,60.53
Regions (MSCI),World,Europe & Middle East,Portugal,iShares Core Euro Government Bond UCITS ETF (Dist),2.26,,100.00,0.47,60.53
Regions (MSCI),World,Europe & Middle East,Spain,,,,10.42,3.41,439.02
Regions (MSCI),World,Europe & Middle East,Spain,iShares Core MSCI Europe UCITS ETF EUR (Dist),3.93,,14.84,0.51,65.13
Regions (MSCI),World,Europe & Middle East,Spain,iShares Core Euro Government Bond UCITS ETF (Dist),13.96,,85.16,2.90,373.89
Regions (MSCI),World,Europe & Middle East,Sweden,,,,2.10,0.69,88.34
Regions (MSCI),World,Europe & Middle East,Sweden,iShares Core MSCI Europe UCITS ETF EUR (Dist),5.33,,100.00,0.69,88.34
Regions (MSCI),World,Europe & Middle East,Switzerland,,,,5.94,1.94,250.26
Regions (MSCI),World,Europe & Middle East,Switzerland,iShares Core MSCI Europe UCITS ETF EUR (Dist),15.10,,100.00,1.94,250.26
Regions (MSCI),World,Europe & Middle East,United Kingdom,,,,8.88,2.91,374.07
Regions (MSCI),World,Europe & Middle East,United Kingdom,iShares Core MSCI Europe UCITS ETF EUR (Dist),22.57,,100.00,2.91,374.07
Regions (MSCI),World,Pacific,,,,,7.38,4.29,551.93
Regions (MSCI),World,Pacific,Australia,,,,19.21,0.82,106.01
Regions (MSCI),World,Pacific,Australia,Lyxor MSCI Pacific UCITS ETF,19.08,,100.00,0.82,106.01
Regions (MSCI),World,Pacific,Hong Kong,,,,8.18,0.35,45.17
Regions (MSCI),World,Pacific,Hong Kong,Lyxor MSCI Pacific UCITS ETF,8.13,,100.00,0.35,45.17
Regions (MSCI),World,Pacific,Japan,,,,68.66,2.94,378.97
Regions (MSCI),World,Pacific,Japan,Lyxor MSCI Pacific UCITS ETF,68.21,,100.00,2.94,378.97
Regions (MSCI),World,Pacific,New Zealand,,,,1.07,0.05,5.89
Regions (MSCI),World,Pacific,New Zealand,Lyxor MSCI Pacific UCITS ETF,1.06,,100.00,0.05,5.89
Regions (MSCI),World,Pacific,Singapore,,,,2.88,0.12,15.89
Regions (MSCI),World,Pacific,Singapore,Lyxor MSCI Pacific UCITS ETF,2.86,,100.00,0.12,15.89
Regions (MSCI),Emerging Markets Index,,,,,,21.37,15.78,"2,031.74"
Regions (MSCI),Emerging Markets Index,Americas,,,,,6.29,0.99,127.74
Regions (MSCI),Emerging Markets Index,Americas,Argentina,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Americas,Brazil,,,,69.26,0.69,88.47
Regions (MSCI),Emerging Markets Index,Americas,Brazil,iShares MSCI EM UCITS ETF (Dist),3.92,,100.00,0.69,88.47
Regions (MSCI),Emerging Markets Index,Americas,Chile,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Americas,Colombia,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Americas,Mexico,,,,30.74,0.30,39.27
Regions (MSCI),Emerging Markets Index,Americas,Mexico,iShares MSCI EM UCITS ETF (Dist),1.74,,100.00,0.30,39.27
Regions (MSCI),Emerging Markets Index,Americas,Peru,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",,,,,9.41,1.48,191.15
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Czech Republic,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Egypt,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Greece,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Hungary,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Kuwait,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Poland,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Qatar,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Russia,,,,35.07,0.52,67.03
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Russia,iShares MSCI EM UCITS ETF (Dist),2.97,,100.00,0.52,67.03
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Saudi Arabia,,,,22.90,0.34,43.78
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Saudi Arabia,iShares MSCI EM UCITS ETF (Dist),1.94,,100.00,0.34,43.78
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",South Africa,,,,42.03,0.62,80.34
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",South Africa,iShares MSCI EM UCITS ETF (Dist),3.56,,100.00,0.62,80.34
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",Turkey,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,"Europe, Middle East & Africa",United Arab Emirates,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Asia,,,,,84.30,13.30,"1,712.85"
Regions (MSCI),Emerging Markets Index,Asia,China,,,,51.95,6.91,889.78
Regions (MSCI),Emerging Markets Index,Asia,China,Lyxor MSCI Pacific UCITS ETF,0.39,,0.24,0.02,2.17
Regions (MSCI),Emerging Markets Index,Asia,China,iShares MSCI EM UCITS ETF (Dist),39.33,,99.76,6.89,887.61
Regions (MSCI),Emerging Markets Index,Asia,India,,,,12.07,1.61,206.73
Regions (MSCI),Emerging Markets Index,Asia,India,iShares MSCI EM UCITS ETF (Dist),9.16,,100.00,1.61,206.73
Regions (MSCI),Emerging Markets Index,Asia,Indonesia,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Asia,North Korea,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Asia,South Korea,,,,17.04,2.27,291.81
Regions (MSCI),Emerging Markets Index,Asia,South Korea,iShares MSCI EM UCITS ETF (Dist),12.93,,100.00,2.27,291.81
Regions (MSCI),Emerging Markets Index,Asia,Malaysia,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Asia,Pakistan,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Asia,Philippines,,,,0.00,0.00,0.00
Regions (MSCI),Emerging Markets Index,Asia,Taiwan,,,,16.56,2.20,283.68
Regions (MSCI),Emerging Markets Index,Asia,Taiwan,iShares MSCI EM UCITS ETF (Dist),12.57,,100.00,2.20,283.68
Regions (MSCI),Emerging Markets Index,Asia,Thailand,,,,2.38,0.32,40.85
Regions (MSCI),Emerging Markets Index,Asia,Thailand,iShares MSCI EM UCITS ETF (Dist),1.81,,100.00,0.32,40.85
Regions (MSCI),Frontier Markets Index,,,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Croatia,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Estonia,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Lithuania,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Kazakhstan,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Romania,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Serbia,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Europe & CIS,Slovenia,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,Kenya,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,Mauritius,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,Morocco,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,Nigeria,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,Tunisia,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Africa,WAEMU,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Middle East,,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Middle East,Bahrain,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Middle East,Jordan,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Middle East,Lebanon,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Middle East,Oman,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Asia,,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Asia,Bangladesh,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Asia,Sri Lanka,,,,0.00,0.00,0.00
Regions (MSCI),Frontier Markets Index,Asia,Vietnam,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,,,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Americas,,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Americas,Jamaica,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Americas,Panama,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Americas,Trinidad & Tobago,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Europe & CIS,,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Europe & CIS,Bosnia Herzegovina,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Europe & CIS,Bulgaria,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Europe & CIS,Malta,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Europe & CIS,Iceland,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Europe & CIS,Ukraine,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Africa,,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Africa,Botswana,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Africa,Zimbabwe,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Middle East,,,,,0.00,0.00,0.00
Regions (MSCI),Standalone Markets Index,Middle East,Palestine,,,,0.00,0.00,0.00
Without Classification,,,,,,,26.17,26.17,"3,369.34"
Without Classification,Call Money Account,,,,100.00,,14.84,3.88,500.00
Without Classification,Dax,,,,100.00,,0.00,0.00,0.00
Without Classification,Deposit Account,,,,100.00,,7.74,2.03,260.92
Without Classification,Dow Jones,,,,100.00,,0.00,0.00,0.00
Without Classification,Germany (Harmonized Consumer Priced Index),,,,100.00,,0.00,0.00,0.00
Without Classification,iShares Core Euro Government Bond UCITS ETF (Dist),,,,1.71,,1.36,0.36,45.80
Without Classification,iShares Core MSCI Europe UCITS ETF EUR (Dist),,,,4.63,,2.28,0.60,76.74
Without Classification,iShares Diversified Commodity Swap UCITS ETF,,,,100.00,,66.80,17.48,"2,250.80"
Without Classification,iShares MSCI EM UCITS ETF (Dist),,,,10.07,,6.74,1.77,227.26
Without Classification,iShares MSCI North America UCITS ETF,,,,0.28,,0.23,0.06,7.60
Without Classification,Lyxor MSCI Pacific UCITS ETF,,,,0.04,,0.01,0.00,0.22
Without Classification,MSCI World,,,,100.00,,0.00,0.00,0.00
Without Classification,NASDAQ Composite,,,,100.00,,0.00,0.00,0.00
Indeed, today, there is no importing functionality for taxonomies (other than you editing the XML). I’d be willing to work on this if I better understand what you want to achieve.
Each category has unique identifier (although they are not displayed in the UI). That includes a UUID and (sometimes) external identifiers such as the country code, the GICS code, etc.
What we could do with reasonable effort:
- allow viewing/editing of those external identifier codes
- have a CSV import where one picks the taxonomy and then the securities are assigned to categories based on some identifier
Technically, that would not import the taxonomy but the assignment of investment vehicle to the categories.
Hi Andreas
What I’m trying to achieve is to import taxonomies for all my funds and avoid having to go through this UI by hand one by one for every fund
The source of the import will be a file that I will build in whatever format you tell me is supported. I will write a java application or python script to get the actual taxonomies from an API or from user input, it doesn’t really matter really. The idea is to have a standard format that makes sense to you to be able to import taxonomies and I will adapt to that format
You will know better what format makes sense to import all taxonomies for all securities in an account based on your current data models in the code but looking at the UI, conceptually i see they are basically key-value pairs with a category:
Asset classes:
cash: 50%
equity: 50%
Regions:
Ireland: 30%
Sweden: 25%
Japan: 45%
This would be very easy to model in JSON or YAML but to keep consistent with all the other imports I imagine it makes sense to use XML? The most consistent would be CSV but i’m not sure how to represented nested data in CSV
In XML this could be modelled like so
<taxonomies>
<security ticker="ABC">
<category name="Asset Classes">
<equity>0.5</equity>
<cash>0.5</cash>
</category>
<category name="Regions">
<Ireland>0.3</Ireland>
<Sweden>0.25</Sweden>
<Japan>0.45</Japan>
</category>
</security>
<security ticker="XYZ">
...
</security>
</taxonomies>
Unfortunately, I can’t do this all myself since I don’t have an environment to develop RCPs and am now only using IntelliJ, but if there is any non-UI code that’s needed I can contribute
@Hilikus Thanks for the output screenshot.
The taxonomy data is already formatted and structured as csv in the files I posted above. It is not a traditional csv file as repeating data is only listed once.
Two changes are needed:
- The First fields are
Levels 1..NwhereNis the number of levels for Taxonomy.Level Nneeds to be moved toLevel 0as the first field (Security). Level 1contains the Taxonomy or Without Classification. It needs to contain the Taxonomy and move Without Classification to Levels 2.- I’d suggest a third, Rename
Levels Nfields toLevelNto make the grammar more correct and remove the space in the field name label.
I have concatenated the taxonomy data files, reformatted it with the first change but not the other changes, and attached it to the bottom of this post. Feel free to open it in a spreadsheet and filter by the first row.
Taxonomy_kommer.csv (38.4 KB)
Now again, Which website(s) have the data? Can you provide a sample data download, preferably with a couple of taxonomies for at least one security? (Even better to do all kommer securities and taxonomies.)
Once we have a data source we can design the transformation process. Also, fix the flaw with the import process that does not allow importing updates to existing records.
This is the wrong handling in PP, because we’ve in PP the parent/child approach instead of a fixed hierarchy level.
Are you commenting on the standard PP data export files? It doesn’t really matter what the Security field name is or the order as long as a unique field from Taxonomies.
@Rafa Importing parent/child data has a similar solution in View document | GnuCash - search for Multi-split: which has a sample Multi-split.csv file. Beneath each parent is the children (like json), the same as the standard PP Taxonomy csv export files shown above.
Edit: Fixed broken link.