Modified thumbnail.png

["UPDATE_VIZ","NAAIM","Chart 1"]

["UPDATE_VIZ","NAAIM","Chart 1"]

["CREATE_VIZ","NAAIM","Chart 1"]

["DELETE_VIZ","NAAIM","Chart 1"]

["UPDATE_VIZ","NAAIM","Chart 1"]

["CREATE_VIZ","NAAIM","Chart 1"]

["DELETE_VIZ","NAAIM","Chart 1"]

["UPDATE_VIZ","NAAIM","Chart 1"]

["UPDATE_VIZ","NAAIM","Chart 1"]

["CREATE_VIZ","NAAIM","Chart 1"]

["DELETE_VIZ","NAAIM","Chart 1"]

["UPDATE_VIZ","NAAIM","Chart 1"]

["CREATE_VIZ","NAAIM","Chart 1"]

["DELETE_VIZ","NAAIM","Chart 1"]

["UPDATE_VIZ","NAAIM","Chart 1"]

Removed project data files

["DELETEDATAFRAME","SPZ"]

["DELETE_TRANSFORM","NAAIM","結合 (列を追加する / Join)","結合先: SPZ, タイプ: 内部結合 (Inner Join), キー列: Date == date "]

["CREATE_TRANSFORM","NAAIM","列名を変更","Date -> ym"]

["UPDATE_TRANSFORM","NAAIM","フィルタ","Date '範囲内' 2007-01-01 : 2023-12-31"]

["UPDATE_TRANSFORM","NAAIM","結合 (列を追加する / Join)","結合先: SPZ, タイプ: 内部結合 (Inner Join), キー列: Date == date "]

["CREATE_TRANSFORM","NAAIM","結合 (列を追加する / Join)","結合先: SPX, タイプ: 内部結合 (Inner Join), キー列: Date == date "]

["CREATE_TRANSFORM","SPZ","列を選択","-'SPY/JPY'"]

["CREATE_TRANSFORM","SPZ","計算を作成","Return = Return + 1"]

["CREATE_TRANSFORM","SPZ","表計算","Group(), Value('SPY/JPY' (Diff from Period Ago (Ratio)))"]

["DELETE_TRANSFORM","SPZ","表計算","Group(date (月)), Value('SPY/JPY' (前の期間からの差の割合))"]

["CREATE_TRANSFORM","SPZ","表計算","Group(date (月)), Value('SPY/JPY' (前の期間からの差の割合))"]

["ENABLE_TRANSFORM","SPZ","集計","Group(date (月)), Value('SPY/JPY' (最後の値))"]

["DISABLE_TRANSFORM","SPZ","集計","Group(date (月)), Value('SPY/JPY' (最後の値))"]

["UPDATE_TRANSFORM","SPZ","集計","Group(date (月)), Value('SPY/JPY' (最後の値))"]

["COPY_BRANCH","SPX","SPZ"]

["UPDATE_TRANSFORM","NAAIM","フィルタ","Date '範囲内' 2006-12-01 : 2023-12-31"]

["UPDATE_TRANSFORM","NAAIM","結合 (列を追加する / Join)","結合先: SPX, タイプ: 内部結合 (Inner Join), キー列: Date == date "]

["RENAMEDATAFRAME","SPY","SPX"]

["UPDATE_TRANSFORM","SPY","欠損値を前後の行の値で埋める","列: 'USDJPY=X', タイプ: 前の行の値"]

["CREATE_TRANSFORM","SPY","フィルタ","SPY '欠損値 (NA) を除く' "]

["CREATE_TRANSFORM","SPY","ロング型からワイド型へ","キー列: symbol, 値の列: adjusted"]

["DELETE_TRANSFORM","SPY","ロング型からワイド型へ","キー列: symbol, 値の列: adjusted"]

["CREATE_TRANSFORM","NAAIM","フィルタ","Date '範囲内' 2007-01-01 : 2023-12-31"]

["UPDATE_TRANSFORM","SPY","集計","Group(date (月)), Value('SPY/JPY' (Nth))"]

["CREATE_TRANSFORM","SPY","計算を作成","'SPY/JPY' = SPY * 'USDJPY=X', .after = ifelse(\"USDJPY=X\" %in% names(.), \"USDJPY=…)"]

["CREATE_TRANSFORM","SPY","欠損値を前後の行の値で埋める","列: SPY, 'USDJPY=X', タイプ: 前の行の値"]

["DELETE_TRANSFORM","SPY","フィルタ","SPY '欠損値 (NA) のみを残す' "]

["CREATE_TRANSFORM","SPY","フィルタ","SPY '欠損値 (NA) のみを残す' "]

["CREATE_TRANSFORM","SPY","ロング型からワイド型へ","キー列: symbol, 値の列: adjusted"]

Modified pwJ2ivM9.metadata.json

Modified pwJ2ivM9.sample_data.json

["REIMPORTDATAFRAME","SPY","株価データ"]

Modified pwJ2ivM9.metadata.json

Modified pwJ2ivM9.sample_data.json

["REIMPORTDATAFRAME","SPY","株価データ"]

["DELETE_TRANSFORM","NAAIM","フィルタ","Date '範囲内' 2007-01-01 : 2023-12-31"]

["CREATE_TRANSFORM","NAAIM","フィルタ","Date '範囲内' 2007-01-01 : 2023-12-31"]

["UPDATE_TRANSFORM","NAAIM","結合 (列を追加する / Join)","結合先: SPY, タイプ: 内部結合 (Inner Join), キー列: Date == date "]

["CREATE_TRANSFORM","NAAIM","列を選択","-'NAAIM Number'"]

["UPDATE_TRANSFORM","NAAIM","集計","Group(Date (月)), Value('NAAIM Number' (最後の値))"]

["DELETETRANSFORM","NAAIM","計算を作成","Datemonth = format(Date, \"%Y-%m\"), .after = ifelse(\"Date\" %in% names(.), \"Date\"…)"]

["UPDATE_TRANSFORM","SPY","集計","Group(date (月)), Value(adjusted (Nth))"]

["DELETETRANSFORM","SPY","計算を作成","ym = floordate(date, unit = \"month\"), .after = ifelse(\"date\" %in% names(.), \"da…)"]

["DELETETRANSFORM","SPY","計算を作成","datemonth = format(date, \"%Y-%m\"), .after = ifelse(\"date\" %in% names(.), \"date\"…)"]

["CREATETRANSFORM","SPY","計算を作成","ym = floordate(date, unit = \"month\"), .after = ifelse(\"date\" %in% names(.), \"da…)"]

["DELETETRANSFORM","SPY","計算を作成","calculation2 = floor_date(date, unit = \"month\"), .after = ifelse(\"date\" %in% na…)"]

["CREATETRANSFORM","SPY","計算を作成","calculation2 = floor_date(date, unit = \"month\"), .after = ifelse(\"date\" %in% na…)"]

Modified RjK6Xse4.json

["UPDATE_TRANSFORM","NAAIM","条件を元に計算、または値を置き換える","列: NAAIM Number, 'NAAIM Number' < 30 -> \"a\", 'NAAIM Number' < 50 -> \"b\", 'NA…"]

["CREATE_TRANSFORM","NAAIM","条件を元に計算、または値を置き換える","列: NAAIM Number, 'NAAIM Number' < 30 -> \"a\", 'NAAIM Number' < 50 -> \"b\", 'NA…"]

["CREATETRANSFORM","NAAIM","結合 (列を追加する / Join)","結合先: SPY, タイプ: 内部結合 (Inner Join), キー列: Datemonth == date_month "]

["UPDATETRANSFORM","NAAIM","集計","Group(Datemonth), Value('NAAIM Number' (最後の値))"]

["UPDATETRANSFORM","SPY","集計","Group(datemonth), Value(adjusted (Nth))"]

["UPDATETRANSFORM","SPY","集計","Group(datemonth), Value(date (Nth),adjusted (Nth))"]

["UPDATE_VIZ","SPY","Chart 1"]

["CREATE_VIZ","SPY","Chart 1"]

["DELETE_VIZ","SPY","Chart 1"]

["UPDATE_VIZ","SPY","Chart 1"]

["CREATE_VIZ","SPY","Chart 1"]

["UPDATETRANSFORM","SPY","集計","Group(datemonth), Value(date (Nth),adjusted (Nth))"]

["UPDATETRANSFORM","SPY","集計","Group(datemonth), Value(date (Nth),adjusted (Nth))"]

["CREATETRANSFORM","SPY","集計","Group(datemonth), Value(date (Nth),adjusted (Nth))"]

["DELETETRANSFORM","SPY","集計","Group(datemonth), Value(adjusted (最初の値))"]

["CREATETRANSFORM","NAAIM","集計","Group(Datemonth), Value(Date (最後の値),'NAAIM Number' (最後の値))"]

["DELETETRANSFORM","NAAIM","集計","Group(Datemonth), Value('NAAIM Number' (最後の値),Date (最後の値))"]

["DELETE_TRANSFORM","NAAIM","並べ替え (ソート)","Date"]

["CREATE_TRANSFORM","NAAIM","並べ替え (ソート)","Date"]

["CREATETRANSFORM","NAAIM","集計","Group(Datemonth), Value('NAAIM Number' (最後の値),Date (最後の値))"]

["CREATETRANSFORM","NAAIM","計算を作成","Datemonth = format(Date, \"%Y-%m\"), .after = ifelse(\"Date\" %in% names(.), \"Date\"…)"]

["DELETE_BRANCH","monthly"]

["CREATETRANSFORM","SPY","集計","Group(datemonth), Value(adjusted (最初の値))"]

["CREATETRANSFORM","SPY","計算を作成","datemonth = format(date, \"%Y-%m\"), .after = ifelse(\"date\" %in% names(.), \"date\"…)"]

["DELETETRANSFORM","SPY","計算を作成","datemonth = format(date, \"%Y-%m\"), .after = ifelse(\"date\" %in% names(.), \"date\"…)"]

["CREATETRANSFORM","SPY","計算を作成","datemonth = format(date, \"%Y-%m\"), .after = ifelse(\"date\" %in% names(.), \"date\"…)"]

["DELETETRANSFORM","SPY","計算を作成","dateyear = year(date), .after = ifelse(\"date\" %in% names(.), \"date\", last_col())"]

["DELETETRANSFORM","SPY","計算を作成","dateweek = week(date), .after = ifelse(\"dateyear\" %in% names(.), \"dateyear\", …)"]

["DELETETRANSFORM","SPY","計算を作成","yearweek = strc(dateyear, \"\", dateweek), .after = ifelse(\"date_week\" %in% n…)"]

["DELETETRANSFORM","SPY","条件を元に計算、または値を置き換える","列: dateweek, dateweek = 1 -> 5000, dateweek > 1 -> 500, デフォルト: 欠損値"]

["DELETETRANSFORM","SPY","集計","Group(yearweek), Value(投資金額_b (中央値),adjusted (中央値))"]

["UPDATE_ANALYTICS","NAAIM","Analytics 1"]

["DELETETRANSFORM","NAAIM","計算を作成","NextWeek = Date + 7, .after = ifelse(\"Date\" %in% names(.), \"Date\", lastcol())"]

["DELETETRANSFORM","NAAIM","計算を作成","NextWeekyear = year(NextWeek), .after = ifelse(\"NextWeek\" %in% names(.), \"NextW…)"]

["DELETETRANSFORM","NAAIM","計算を作成","NextWeekmonth = month(NextWeek), .after = ifelse(\"NextWeek_year\" %in% names(.),…)"]