Im- and export of all security meta data as JSON

tquellenberg commented 2 years ago

Is your feature request related to a problem? Please describe. The existing CSV im- and export of securities do not include all internal meta data. Especially attributes and taxonomy assignments are not included.

Describe the solution you'd like New JSON format like this. Most of the data is optional. Existing securities are updated (referenced by ISIN) when JSOn is imported.

{
  "version": "1.0",
  "type": "SecurityMetaData",
  "securities": [
    {
      "isin": "US0378331005",
      "name": "Apple Inc",
      "currencyCode": "EUR",
      "note": "Meine Anmerkungen...",
      "tickerSymbol": "APC.DE",
      "wkn": "",
      "properties": {},
      "attributes": {},
      "taxonomies": [
        {
          "name": "Regionen (MSCI)",
          "assignments": [
            {
              "key": "RW1",
              "path": [
                "Regionen (MSCI)",
                "Welt",
                "Amerikas"
              ],
              "weight": 9000
            },
            {
              "key": "RW2",
              "path": [
                "Regionen (MSCI)",
                "Welt",
                "Europa"
              ],
              "weight": 1000
            }
          ]
        }
      ]
    }
  ]
}

Maybe the structure for the taxonomies is too complex and a more simples approach is better (flat list of assignments)
Is the header with version and type needed?

Some of the related discussions can be found here: https://forum.portfolio-performance.info/t/automatische-erstellung-von-klassifizierungen/2969/51

flywire commented 2 years ago

portfolio-performance / portfolio

Im- and export of all security meta data as JSON #2781