[ { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value.replace(\"KÖPT\",\"Buy\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Transaktionstyp using expression value.replace(\"KÖPT\",\"Buy\")" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "INSÄTTNING" ], "fromBlank": false, "fromError": false, "to": "Deposit" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "SÅLT" ], "fromBlank": false, "fromError": false, "to": "Sell" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "REALTIDSINSÄTTNING" ], "fromBlank": false, "fromError": false, "to": "Deposit" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "UTDELNING" ], "fromBlank": false, "fromError": false, "to": "Dividend" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "MAK UTDELNING" ], "fromBlank": false, "fromError": false, "to": "Removal" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "UTL KUPSKATT" ], "fromBlank": false, "fromError": false, "to": "Taxes" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "UTTAG" ], "fromBlank": false, "fromError": false, "to": "Transfer (Outbound)" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Transaktionstyp", "expression": "value", "edits": [ { "from": [ "KAP. DEB RÄNTA" ], "fromBlank": false, "fromError": false, "to": "Interest Charge" } ], "description": "Mass edit cells in column Transaktionstyp" }, { "op": "core/column-rename", "oldColumnName": "Antal", "newColumnName": "Count", "description": "Rename column Antal to Count" }, { "op": "core/column-addition", "engineConfig": { "facets": [], "mode": "row-based" }, "baseColumnName": "Värdepapper", "expression": "grel:if(isNonBlank(value),\nif(length(value)==4,join([value,\"XE\"],\".\"),value),value)", "onError": "set-to-blank", "newColumnName": "Ticker", "columnInsertIndex": 6, "description": "Create column Ticker at index 6 based on column Värdepapper using expression grel:if(isNonBlank(value),\nif(length(value)==4,join([value,\"XE\"],\".\"),value),value)" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker", "expression": "value", "edits": [ { "from": [ "BAM.A" ], "fromBlank": false, "fromError": false, "to": "BAM-A.TO" } ], "description": "Mass edit cells in column Ticker" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker", "expression": "value", "edits": [ { "from": [ "4I1" ], "fromBlank": false, "fromError": false, "to": "4I1.DE" } ], "description": "Mass edit cells in column Ticker" }, { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Belopp", "expression": "value.replace(\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Belopp using expression value.replace(\" \",\"\")" }, { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Inköpsvärde", "expression": "value.replace(\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Inköpsvärde using expression value.replace(\" \",\"\")" }, { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Saldo", "expression": "value.replace(\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Saldo using expression value.replace(\" \",\"\")" }, { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Växlingskurs", "expression": "value.replace(\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Växlingskurs using expression value.replace(\" \",\"\")" }, { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Resultat", "expression": "value.replace(\" \",\"\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Resultat using expression value.replace(\" \",\"\")" }, { "op": "core/text-transform", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker", "expression": "value.replace(\".XE\",\".DE\")", "onError": "keep-original", "repeat": false, "repeatCount": 10, "description": "Text transform on cells in column Ticker using expression value.replace(\".XE\",\".DE\")" }, { "op": "core/column-rename", "oldColumnName": "Affärsdag", "newColumnName": "Date", "description": "Rename column Affärsdag to Date" }, { "op": "core/column-rename", "oldColumnName": "Transaktionstyp", "newColumnName": "Type", "description": "Rename column Transaktionstyp to Type" }, { "op": "core/column-rename", "oldColumnName": "Ticker", "newColumnName": "Ticker Symbol", "description": "Rename column Ticker to Ticker Symbol" }, { "op": "core/column-rename", "oldColumnName": "Count", "newColumnName": "Shares", "description": "Rename column Count to Shares" }, { "op": "core/column-rename", "oldColumnName": "Valuta", "newColumnName": "Transaction Currency", "description": "Rename column Valuta to Transaction Currency" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "XACTHDIV" ], "fromBlank": false, "fromError": false, "to": "XACTHDIV.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "XACT Obligation" ], "fromBlank": false, "fromError": false, "to": "XACT-OBLIGATION.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/column-rename", "oldColumnName": "Avgifter", "newColumnName": "Fees", "description": "Rename column Avgifter to Fees" }, { "op": "core/column-addition", "engineConfig": { "facets": [], "mode": "row-based" }, "baseColumnName": "Kurs", "expression": "grel:if(value == \"0\",cells[\"Belopp\"].value,value)", "onError": "set-to-blank", "newColumnName": "Value", "columnInsertIndex": 11, "description": "Create column Value at index 11 based on column Kurs using expression grel:if(value == \"0\",cells[\"Belopp\"].value,value)" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "NHCBHFFS" ], "fromBlank": false, "fromError": false, "to": "NHCBHFFS.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "CYAN.DE" ], "fromBlank": false, "fromError": false, "to": "CYAN" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "ADVT.DE" ], "fromBlank": false, "fromError": false, "to": "ADVT.STO" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "SALT B" ], "fromBlank": false, "fromError": false, "to": "SALT-B.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "GRMN.DE" ], "fromBlank": false, "fromError": false, "to": "GRMN" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "TEAM.DE" ], "fromBlank": false, "fromError": false, "to": "TEAM" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "FSLY.DE" ], "fromBlank": false, "fromError": false, "to": "FSLY" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "S92" ], "fromBlank": false, "fromError": false, "to": "S92.DE" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "KINV A" ], "fromBlank": false, "fromError": false, "to": "KINV-A.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "PCELL" ], "fromBlank": false, "fromError": false, "to": "PCELL.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "NAS" ], "fromBlank": false, "fromError": false, "to": "NAS.OL" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "BAKKA" ], "fromBlank": false, "fromError": false, "to": "BAKKA.OL" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/mass-edit", "engineConfig": { "facets": [], "mode": "row-based" }, "columnName": "Ticker Symbol", "expression": "value", "edits": [ { "from": [ "XACT BEAR 2" ], "fromBlank": false, "fromError": false, "to": "XACT-BEAR-2.ST" } ], "description": "Mass edit cells in column Ticker Symbol" }, { "op": "core/column-rename", "oldColumnName": "Transaktionstext", "newColumnName": "Note", "description": "Rename column Transaktionstext to Note" } ]