PACTA_analysis icon indicating copy to clipboard operation
PACTA_analysis copied to clipboard

bonds and equity with valid_input==FALSE

Open cjyetman opened this issue 4 years ago • 5 comments

I found a few cases where bond and/or equity holdings have valid_input==FALSE. My expectation, after the change in #17, is that this should not be possible? (based on data created on 2020-04-09 16:00:26 CEST)

library(fs)
library(dplyr)
this_project_dir <- path_expand('~/Dropbox (2° Investing)/PortCheck_v2/10_Projects/PACTA_2020_TESTS_CJ')


file_info(path(this_project_dir, '30_Processed_Inputs', 
               'PACTA_2020_TESTS_CJ_audit_file.rda'))$modification_time
# [1] "2020-04-09 16:00:26 CEST"


path(this_project_dir,
     '30_Processed_Inputs', 'PACTA_2020_TESTS_CJ_audit_file.rda') %>%
  readRDS() %>%
  as_tibble() %>%
  filter(asset_type %in% c('Bonds', 'Equity')) %>% 
  filter(valid_input == FALSE) %>% 
  select(investor_name, portfolio_name, holding_id, isin, value_usd, 
         asset_type, valid_input)

# # A tibble: 9 x 7
#   investor_name    portfolio_name   holding_id isin   value_usd asset_type valid_input
#   <chr>            <chr>            <chr>      <chr>      <dbl> <chr>      <lgl>      
# 1 Platform Sample… Asian Portfolio  305        TW000…       NA  Equity     FALSE      
# 2 Platform Sample… Asian Portfolio  357        XS202…       NA  Bonds      FALSE      
# 3 Platform Sample… Mixed Portfolio  14293      INE00…   498171. Equity     FALSE      
# 4 Platform Sample… Platform Sample… 19304      TW000…       NA  Equity     FALSE      
# 5 Platform Sample… Platform Sample… 19356      XS202…       NA  Bonds      FALSE      
# 6 Platform Sample… Platform Sample… 33292      INE00…   498171. Equity     FALSE      
# 7 Meta Investor    Meta Portfolio   38303      TW000…       NA  Equity     FALSE      
# 8 Meta Investor    Meta Portfolio   38355      XS202…       NA  Bonds      FALSE      
# 9 Meta Investor    Meta Portfolio   52291      INE00…   498171. Equity     FALSE      

cjyetman avatar Apr 11 '20 11:04 cjyetman