# abc <- onsR2::download('CHAW')$m_data
# abc <- 'USDM'
# cde <- beamaTrends::tg$new( onsR2::download('CHAW')$m_data )
# cde$plot()
# cde$plot(T)
# cde$get_data_freq()
# cde$get_data_start()
# cde$get_data_format()
# cde$get_data_ts()
# cde$set_agg('qtr')$get_agg()
# cde$set_agg('qtr','avg')$get_agg()
# cde$set_agg('yr')$get_agg()
# cde$set_agg('yr','avg')$get_agg()
# cde$set_agg('ytd')$get_agg()
# cde$set_agg('ytd','avg')$get_agg()
# cde$set_agg('mat')$get_agg()
# cde$set_agg('mat','avg')$get_agg()
# cde$set_agg('mqt')$data_agg
# cde$set_agg_default('qtr')$get_mat4()
# cde <- td$new('CHAW')
# cde <- beamaTrends::td$new('chaw')
# cde <- beamaTrends::tg$new('ABMI')
# cde <- beamaTrends::tg$new('K646',db_limit = list(yr=2016,mth=5))
# cde <- beamaTrends::td$new('K646',db_limit = list(yr=2016,mth=5))
# beamaTrends::tg$new('sitc-MENA-EXPORT-77')$plot(ops ='sum',select = 'MAT,YR,YTD', skale = 1e6, skale_title = 'Value (GBP million)',title = 'Exports - Middle East & Africa')
# beamaTrends::tg$new('sitc-MENA-EXPORT-77')$plot(ops ='sum',select = 'MTH,QTR', skale = 1e6, skale_title = 'Value (GBP million)',title = 'Exports - Middle East & Africa')
# beamaTrends::tg$new('sitc-EUEU-EXPORT-77')$plot(ops ='sum',select = 'YR', select_yr=c(2000,2015), skale = 1e6, skale_title = 'Value (GBP million)',title = 'Electrical Machinery Exports - EU28')
# beamaTrends::tg$new('sitc-EUEU-EXPORT-77')$plot(T,select = 'MM12,YTD12,MAT12', select_yr=c(2000,2016), title = 'Electrical Machinery Exports - EU28')
# beamaTrends::tg$new('sitc-NANA-EXPORT-77')$plot(T, select_yr=c(2000,2016), title = 'Electrical Machinery Exports - North America')
# beamaTrends::tg$new('sitc-FR-EXPORT-77')$plot(T, select_yr=c(2000,2016), title = 'Electrical Machinery Exports - France')
# cde$plot( )
# cde$plot( T )
# cde$plot( T ,select = 'MAT12,MM12,YTD12')
# cde$plot( T ,select = 'MM1,MAT1,QQ1')
# cde$plot( T ,select = 'MM12,qq4')
# ts.plot(beamaTrends::tg$new( onsR2::download('CHAW')$m_data )$set_agg('ytd', 'avg')$get_agg(), ylab='Index(2010=100)')
# ts.plot(beamaTrends::tg$new( onsR2::download('ABMI')$q_data )$set_agg('ytd', 'avg')$get_agg(), ylab='GBP millions')
# ts.plot(beamaTrends::tg$new( onsR2::download('ABMI')$q_data )$get_growth_data('ytd', 'avg'), ylab='ytd % growth')
# ts.plot(beamaTrends::tg$new('ABMI')$get_growth_data('qq4'),ylab='Growth %')
# ts.plot(beamaTrends::tg$new('ABMI')$get_growth_data('mat4'),ylab='Growth %')
# cde$get_mm1()
# cde$get_mm3()
# cde$get_mm12()
# cde$get_qq1()
# cde$get_qq4()
# cde$get_yy1()
# cde$get_yy1(ops = 'avg')
# cde$get_mat1()
# cde$get_mat12()
# cde$get_mat4()
# cde$get_ytd4()
# cde$get_ytd12()
# cde <- tg$new(rnorm(100),c(2010,1),12)
# cde$get_data_freq()
# cde$get_data_start()
# cde$get_data_format()
# cde$get_data_ts()
# cde$get_data_df()
# cde$to_df(cde$get_ytd12(),'ytd4', T, T )
#cde <- beamaTrends::tg$new(data.frame( yr=rep(2010:2015,each=12), mth=rep(1:12,each=6),value=rnorm(72,mean=10,sd=1)) )
#cde$get_mat1()
#cde <- beamaTrends::tg$new(data.frame( yr=rep(2010:2015,each=12), mth=rep(1:12,each=6),value=rnorm(72,mean=10,sd=1)) )
#cde$get_mat1()
#cde <- beamaTrends::tg$new(data.frame( yr=rep(2010:2015,each=4), mth=rep(1:4,each=6),value=rnorm(24,mean=10,sd=1)) )
#cde$get_mat1()
# cde$get_data_freq()
# cde$get_data_start()
# cde$get_data_format()
# cde$get_data_ts()
#
# cde <- beamaTrends::tg$new(
# data.frame(
# yr=2000:2015,
# value=rnorm(16)
# )
# )
#
# cde$get_data_freq()
# cde$get_data_start()
# cde$get_data_format()
# cde$get_data_ts()
#
# aaa<- cde$set_growth_fx(1)
# aaa$get_growth_data()
# abc <- onsR2::download('CHAW')$m_data
# cde <- beamaTrends::td$new(onsR2::download('CHAW')$m_data)
# cde$data_period
# cde$data_end
# cde$data_end_date
# cde$data_end_date_prv
# ccc <- function(){
# cde <- td$new('CHAW')
# cde$plot(
# is_theme = T
# )
# }
#
# cct <- function(){
# cde <- td$new('CHAW')
# cde$plot(
# is_growth = T,
# is_theme = T,
# select =c("MAT12,MM12,YTD12"),
# select_yr =c(2010,2017)
# )
# }
# abc <- onsR2::download('K646')$m_data
# cde <- beamaTrends::td$new(abc,x_name='input cost')
# cde$get_successive()
# cde$get_successive( is_yoy = FALSE)
# cde$get_mtm()$desc
# cde$get_yoy()$desc
# beamaTrends::td$new('K646',x_name='input cost')$get_growth_desc()
# beamaTrends::td$new('ABMI',x_name='gdp')$get_growth_desc()
# beamaTrends::td$new('PLUSGROUP',x_name='Plusgroup')$get_growth_desc()
# beamaTrends::td$new('CHAW',x_name='RPI')$get_growth_desc()
# beamaTrends::td$new()
# aa <- beamaTrends::td$new('PLUSGROUP',x_name='Plusgroup', x_start=c(2013,11), x_frq=12)$get_growth_desc()
# bt <- beamaTrends::td$new('ABMI',x_name='gdp')
# aa$get_mtm()
# aa$get_yoy()
#smart_lbl <- list(mm1="1-month growth", mm3="3-month growth", mm12="12-month growth")
#"mm1" %in% names(smart_lbl)
#aaa <- tg.get_growth_data('m_')
#tg.get_unit('CHAW')
#tg.plot_trends('CHAW,D7BT', select = "QQ1,QQ4", x_delta=c(0,0), y_delta=c(0,1), is_themed = T )
#tg.plot_trends('CHAW,D7BT', select = "MM12,MAT12", x_delta=c(0,0), y_delta=c(0,1), is_themed = T )
#tg.plot_trends('CHAW,D7BT', x_delta=c(0,0), y_delta=c(0,5), is_themed = T )
#tg.plot_trends('CHAW,D7BT', fx='q', x_delta=c(0,0), y_delta=c(0,5), is_themed = T )
#tg.plot_trends('m_elec,m_mech', x_delta=c(0,3), y_delta=c(0,0), is_themed = T )
# tg.plot_trends('m_elec,k646', x_delta=c(0,3), y_delta=c(0,0), is_themed = T )
# aaa<- tg.plot_trends('k646', select ='YY1', y1=1990, x_delta=c(0,3), y_delta=c(0,2), is_themed = T )
# tp.view_code()
# tp.view_code(is_growth = T)
#tg.plot_trends('k646', select ='MM12,MAT12,YTD12', y1=2010, x_delta=c(0,3), y_delta=c(0,2), is_themed = T )
#tp.view_code('m_elec')
#tp.view_data('m_elec', dp=1)
#beamaTrends::tg$new('sitc-MENA-EXPORT-77')$plot(ops ='sum',select = 'MTH,QTR,MAT',select_yr = c(2014,2020), skale = 1e6, skale_title = 'Value (GBP million)',title = 'Exports - Middle East & Africa (SITC 77)', is_themed = T)
#beamaTrends::tg$new('sitc-EUEU-EXPORT-77')$plot(ops ='sum',select = 'MTH,QTR,MAT',select_yr = c(2014,2020), skale = 1e6, skale_title = 'Value (GBP million)',title = 'Exports - EU28 (SITC 77)', is_themed = T)
#tg$new('sitc-NANA-EXPORT-77')$plot(ops ='sum',select = 'MTH,QTR,MAT',select_yr = c(2014,2020), skale = 1e6, skale_title = 'Value (GBP million)',title = 'Exports - North America (SITC 77)', is_themed = T, x_delta=c(3,4),y_delta=c(0,100), dp = 0 )
#tg$new('sitc-NANA-EXPORT-77')$plot(is_growth = T,ops ='sum',select = 'MM12,YTD12,MAT12',select_yr = c(2014,2020), skale = 1e6, skale_title = 'Value (GBP million)',title = 'Exports - North America (SITC 77)', is_themed = T, x_delta=c(3,3),y_delta=c(0,2), dp = 1 )
#abc <- tg$new('USDM')$plot(is_growth = T,ops ='sum',select = 'MM12,YTD12,MAT12',select_yr = c(2014,2020), skale = 1e6, skale_title = 'Value (1 GBP)',title = 'US Dollar - Sterling Exchange Rate', is_themed = T, x_delta=c(3,3),y_delta=c(0,0.5), dp = 1, return_plot = T )
#tg$new('USDM')$plot(ops ='avg',select = 'MTH',select_yr = c(2015,2020), skale = 1, skale_title = 'Exchange Rate (per 1 GBP)',title = 'US Dollar - Sterling Exchange Rate', is_themed = T, x_delta=c(3,5),y_delta=c(0,0), dp = 4, brexit_mode=T )
#tg$new('EURM')$plot(ops ='avg',select = 'MTH,QTR,YR',select_yr = c(2015,2020), skale = 1, skale_title = 'Exchange Rate (per 1 GBP)',title = 'EURO - Sterling Exchange Rate', is_themed = T, x_delta=c(3,5),y_delta=c(0,0), dp = 4, brexit_mode=T )
# steel_codes_fred <- c(
# "WPU1012","WPU1017","PCU331210331210","PCU331222331222P",
# "PCU3312223312225","WPU101704","PCU3315123315120", "PCU3311103311107",
# "PCU3312213312211","IR141","WPU101706","WPU107601","PCU33211133211112",
# "PCU331222331222","WPU101211","PCU331110331110","PCU331221331221","WPU10121193",
# "COOTHERZ3311","PCU331210331210P","PCU42993042993011","PCU429930429930113","PCU3312213312213",
# "PCU3311103311103", "PCU3315133315131","PCU3315133315133", "PCU3321113321111","PCU3311103311105",
#
#)
###### orgalime vienna
#GRAPHIC_PATH <- 'M:/2017-03-09-vienna-orgalime/graphics/'
#1. TURNOVER
#1.1 Turnover - GBP-yr
# tp$new(
# tp_data$new('topsi_orgalime')$get_group(T)
# )$set_y1( 2014 )$set_y2( 2016 )$set_avg(F)$set_fx('m')$set_scale(1000)$set_delta_x(4)$set_pc('0')$set_dp(1)$plot_pc(ytitle="Annual Turnover (GBP billion)")
# beamaTrends::tp_utils$new()$plot_save('turnover_gbp_yr',path = GRAPHIC_PATH)
#
# #1.2 Turnover - PC-yr
# beamaTrends::tp$new(
# beamaTrends::tp_data$new('topsi_orgalime')$get_group(T)
# )$set_y1( 2011 )$set_y2( 2016 )$set_avg(F)$set_fx('y')$set_scale(1)$set_delta_x(4)$set_delta_y(0,3)$set_pc('1')$set_dp(1)$plot_pc(ytitle="Annual Growth (%)")
# beamaTrends::tp_utils$new()$plot_save('turnover_pc_yr',path = GRAPHIC_PATH)
# #1.3 Turnover - GBP-mth
# beamaTrends::tp$new(
# beamaTrends::tp_data$new('topsi_orgalime')$get_group(T)
# )$set_y1( 2014 )$set_y2( 2016 )$set_avg(F)$set_fx('m')$set_scale(1000)$set_delta_x(4)$set_delta_y(0,0)$set_pc('0')$set_dp(1)$plot_pc(ytitle="Monthly Turnover (GBP billion)")
# beamaTrends::tp_utils$new()$plot_save('turnover_gbp_mth',path = GRAPHIC_PATH)
#1.4 Turnover - GBP-mth
# abc <- tp$new(
# beamaTrends::tp_data$new('topsi_orgalime')$get_group(T)
# )$set_y1( 2014 )$set_y2( 2016 )$set_breaks( "1 year"
# )$set_breaks_fmt("%Y")$set_avg(F)$set_fx('m')$set_scale( 1
# )$set_delta_x(2)$set_delta_y(0,0)$set_pc('12')$set_dp( 1
# )$set_brexit_label(T)$set_brexit_mode(T)$set_brexit_label(T
# )$set_brexit_text(y=-20,x="2016-04-15")$plot_pc(ytitle="Monthly Growth(%)")
# beamaTrends::tp_utils$new()$plot_save('turnover_pc_mth',path = GRAPHIC_PATH)
# smart_labels = list(
#
# USDM="Exchange - US Dollar",
# `ABMI-PN2`="Gross Domestic Product",
# K646="PPI - Input Prices",
# D7BT = "Consumer Price Index",
# IKBH = "Exports - Value",
# BQKU = 'Exports - Volume Index',
# BQKR = 'Exports - Price Index',
# K222 = 'Index of Production',
# NPEL = 'Business Investment',
# `CT2AM-AW` = 'Construction Output',
# S2KU = 'Index of Services',
# JVZ7 = 'PPI - Output Prices',
# K22A = 'Index of Manufacturing',
# CHAW = 'Retail Price Index',
# `OECD/MEI_CLI_LOLITOAA_GBR_M`='OECD CLI - UK'
#
# )
#
# tp$new(
# 'USDM,K646,D7BT,IKBH,K222,BQKU,CT2AM-AW,BQKR,S2KU,JVZ7,K22A,OECD/MEI_CLI_LOLITOAA_GBR_M'
# )$set_y1( 2014 )$set_facet_cols(3)$set_y2( 2017 )$set_breaks("1 years")$set_breaks_fmt("%Y")$set_avg(F)$set_fx('m')$set_scale(1)$set_brexit_mode(T)$set_delta_x(3)$set_delta_y(0,2)$set_pc('4')$set_dp(1)$plot_pc(
# ytitle="12-month % change", is_smart =T, smart_labels = smart_labels
# )
#
# my_labels = list(
# K23Q = 'Index of Production',
# JQG2 = 'Turnover',
# JQF8 = 'Exports',
# MC9A = 'Input Prices'
# )
#
# tp$new(
# 'K23Q,JQG2,JQF8,MC9A'
# )$set_y1( 2013 )$set_facet_cols(2)$set_y2( 2017 )$set_breaks("1 years")$set_breaks_fmt("%Y")$set_avg(T)$set_fx('m')$set_scale(1)$set_brexit_mode(T)$set_delta_x(3)$set_delta_y(0,2)$set_pc('12')$set_dp(1)$plot_pc(
# ytitle="12-month % change", is_smart=T, smart_labels = my_labels , min_max_days= 90
# )
# abc <- tp$new(
# 'USDM,K646,D7BT,IKBH,K222,BQKU,CT2AM-AW,BQKR,S2KU,JVZ7,K22A,OECD/MEI_CLI_LOLITOAA_GBR_M'
# )$set_y1( 2014 )$set_facet_cols(3)$set_y2( 2017 )$set_breaks("1 years")$set_breaks_fmt("%Y")$set_avg(F)$set_fx('m')$set_scale(1)$set_brexit_mode(T)$set_delta_x(3)$set_delta_y(0,2)$set_pc('12')$set_dp(1)$plot_pc(
# ytitle="12-month % change", is_smart =T, min_max_days= 70, return_data = T,
# smart_labels = list(
#
# USDM="Exchange - US Dollar",
# `ABMI-PN2`="Gross Domestic Product",
# K646="PPI - Input Prices",
# D7BT = "Consumer Price Index",
# IKBH = "Exports - Value",
# BQKU = 'Exports - Volume Index',
# BQKR = 'Exports - Price Index',
# K222 = 'Index of Production',
# NPEL = 'Business Investment',
# `CT2AM-AW` = 'Construction Output',
# S2KU = 'Index of Services',
# JVZ7 = 'PPI - Output Prices',
# K22A = 'Index of Manufacturing',
# CHAW = 'Retail Price Index',
# `OECD/MEI_CLI_LOLITOAA_GBR_M`='OECD CLI - UK'
#
# )
# )
# get_indicator_pos <- function( code = 'IKBH' ){
# sq <- storedQry::SQ$new('R:/shiny/beama/bmonitor/bss.sqlite')
# abc<- sq$set_name('tdi_get_indicator_position_pc')$set_params(
# list(`@s_code`= code)
# )$qry_exec()
# return( abc)
# }
#
# beamaUtils::get_fxn('tdi_indicator_pc')('K646_MM12')
#
# get_indicator_pos('IKBH_MM12')
#tp.plot_regression_code()
#tp.plot_regression_code( k = '12')
#tp.plot_regression_code( fx='qtr', sig_fig = 2)
#tp.plot_regression_code( fx='yr', sig_fig = 2)
#tp.plot_regression_code( fx='mat', sig_fig = 2)
#tp.plot_regression_code( fx='ytd', sig_fig = 2)
#tp.plot_regression_code( fx='mat',k='12', sig_fig = 2)
#tp.plot_regression_code( 'm_elec', 'l_elec', fx='mth',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'usdm', 'm_elec', fx='mth',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'usdm', 'm_elec', fx='mat',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'm_elec', 'usdm', fx='qtr',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'm_elec', 'm_elec', fx='qtr',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'l_elec', 'l_mech', fx='qtr',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'm_elec', 'k646', fx='mth',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'l_elec', 'k646', fx='mat',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'l_elec', 'k646', fx='mat',select_yr=c(2010,2016), sig_fig = 2,k='12')
#tp.plot_regression_code( 'l_elec', 'd7bt', fx='mat',select_yr=c(2010,2016), sig_fig = 2,k='12')
#tp.plot_regression_code( 'm_mech', 'k646', fx='mth',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'm_elec', 'k646', fx='mth', k='12',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'usdm', 'm_elec', fx='mth',k='12',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'usdm', 'm_elec', fx='mat',k='12',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'usdm', 'abmi', fx='qtr',k='4',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'd7bt', 'abmi', fx='qtr',k='4',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'd7bt', 'm_elec', fx='mth',k='12',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'chaw', 'm_composite', fx='mth',k='12',select_yr=c(2010,2016), sig_fig = 2)
#tp.plot_regression_code( 'usdm', 'eurm', fx='qtr',k='4',select_yr=c(2010,2017), sig_fig = 2)
#tp.plot_regression_code( 'eurm', 'usdm', fx='qtr',k='4',select_yr=c(2010,2017), sig_fig = 2)
#beamaTrends::tp.view_spider('D7BT')
#beamaTrends::tp.view_spider('D7BT', fx = 'qtr')
#tp.view_spider('D7BT', fx = 'qtr', k=2)
#tp.view_spider('D7BT', fx = 'qtr', y1=2007)
#tp.view_spider('D7BT', fx = 'mat', y1=2012,is_brexit=T)
#tp.view_spider('D7BT', fx = 'mat', y1=2014, k=3)
#tp.view_spider('D7BT', fx = 'mat', y1=2013, k=6,is_brexit=T)
#abc <- tp.view_spider('D7BT', fx = 'mat', y1=2014, k=12)
#tp.view_spider('D7BT', fx = 'mat', y1=2014, k=12,is_brexit=T)
#beamaTrends::tp.view_spider('D7BT')
#beamaTrends::tp.view_spider('D7BT', fx = 'qtr')
#tp.view_spider('D7BT', fx = 'qtr', k=2)
#tp.view_spider('D7BT', fx = 'qtr', y1=2007)
#tp.view_spider('D7BT', fx = 'mat', y1=2012,is_brexit=T)
#tp.view_spider('D7BT', fx = 'mat', y1=2014, k=3)
#tp.view_spider('D7BT', fx = 'mat', y1=2013, k=6,is_brexit=T)
#abc <- tp.view_spider('D7BT', fx = 'mat', y1=2014, k=12)
#tp.view_spider('D7BT', fx = 'mat', y1=2014, k=12,is_brexit=T)
#tp.view_spider('k646', fx = 'mat', y1=2014, k=3)
#tp.view_spider('k646', fx = 'mat', y1=2014, k=6)
#tp.view_spider('k646', fx = 'mat', y1=2010, k=12 ,is_brexit=T)
#tp.view_spider('EURM', fx = 'mat', y1=2014, k=3)
#tp.view_spider('EURM', fx = 'mat', y1=2014, k=6)
#tp.view_spider('EURM', fx = 'mat', y1=2014, k=9)
#tp.view_spider('EURM', fx = 'mat', y1=2007, k=12, is_brexit = T)
#tp.view_spider('USDM', fx = 'mat', y1=2007, k=12, is_brexit = T)
#tp.view_spider('eurm', fx = 'mat', y1=2014, k=12)
#tp.view_spider('CT2AM-AW', fx = 'mat', y1=2015, k=12)
#tp.view_spider('CT2AM-AW', fx = 'ytd', y1=2014, k=12)
#tp.view_spider('JT27', fx = 'mat', y1=2014, k=12,is_brexit=T)
#tp.view_spider('usdm', fx = 'ytd', y1=2014, k=3)
#tp.view_spider('usdm', fx = 'ytd', y1=2014, k=6)
#tp.view_spider('usdm', fx = 'ytd', y1=2014, k=12)
#tp.view_spider('usdm', fx = 'ytd', y1=2015, k=12)
# abc <- tg_ons$new('DYDC')$add_trends_data(x = window(dt,start=c(1990,1)) )
#tp.view_spider('dydc', fx = 'mat', y1=2012, k=4, is_brexit = T)
#tp.view_spider('mgsc', fx = 'mat', y1=2012, k=12, is_brexit = T)
#tp.view_spider('dydc', fx = 'qtr', y1=2014, k=4, is_brexit = T)
#tp.view_spider('abmi-ukea', fx = 'ytd', y1=2012, k=4, is_brexit = T)
# require(ggplot2)
# x <- c(1)
# y <- c(0)
# xmin <- c(1)
# xmax <- c(2)
# ymin<- c(0)
# ymax<- c(5)
# tx <- c( ( xmin+xmax)/2 )
# ty<- c( (ymin+ymax)/2 )
# tt <- c('my text')
# ta <- c(90)
#
#
# abc <- data.frame(
# x = x, y= y,xmin = xmin,xmax=xmax, ymin=ymin,ymax=ymax,
# tx= tx, ty=ty , ta=ta,tt=tt)
#
# ggplot2::ggplot(data=abc, aes(x=x, y=y,xmin=xmin,xmax=xmax,ymin=ymin,ymax=ymax))+ggplot2::geom_rect()
# +ggplot2::annotate(data=abc, aes(x=tx,y=ty,label=tt,angle = ta),colour=beamaColours::get_darkyellow())
#
# smart_fx <- list(
# USD = 'US Dollar ($)',
# EUR = 'Euro (€)'
# )
# tp$new(
# "EUR,USD"
# )$set_y1( 2015 )$set_title("Sterling Exchange Rate")$set_y2( 2017 )$set_avg(T)$set_fx('d')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(F)$set_scale(1)$set_brexit_mode(
# T)$set_colour(beamaColours::get_euris_blue_light())$set_delta_x(2)$set_delta_y(0,0)$set_pc('0')$set_dp(4)$plot_pc(
# strip_col= beamaColours::get_euris_blue(), min_max_days = 100,
# smart_labels = smart_fx, is_smart =T, ytitle = "Daily Rate (per 1 GBP)"
# )
# smart_fx <- list(
# USDM = 'US Dollar ($)',
# EURM = 'Euro (€)'
# )
# tp$new(
# "EURM,USDM"
# )$set_y1( 2015 )$set_title("Sterling Exchange Rate")$set_y2( 2017 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1)$set_brexit_mode(
# T)$set_colour(beamaColours::get_euris_blue_light())$set_delta_x(2)$set_delta_y(0,0)$set_pc('1')$set_dp(1)$plot_pc(
# strip_col= beamaColours::get_euris_blue(), min_max_days = 100,
# smart_labels = smart_fx, is_smart =T, ytitle = "1-month % change"
# )
#cde <- beamaTrends::td$new('K646')
#beamaTrends::td$new('K646')$get_growth_since(by='m',dt1='2003-01-01', is_brexit = F)
#beamaTrends::td$new('K646')$get_growth_since(by='m',dt1='2003-01-01',dt2='2015-01-01', is_brexit = F)
#beamaTrends::td$new('ABMI')$get_growth_since(by='q',dt1='2016-03-01', is_brexit = F)
#beamaTrends::td$new('ABMI-UKEA')$get_growth_since(by='q',dt1='2015-06-01', dt2='2016-06-01', is_brexit = F)
#beamaTrends::td$new('ABMI-UKEA')$get_growth_since(by='q',dt1='2016-06-01', dt2='2017-10-01', is_brexit = F)
#beamaTrends::td$new('K646')$get_hilow(k=12,is_low = T)
#beamaTrends::td$new('K646')$get_hilow(k=1,is_low = T)
#beamaTrends::td$new('K646')$get_hilow(k=1,is_low =F)
#beamaTrends::td$new('K646')$get_hilow(k=12,is_low =F)
#td.delt( onsR2::download('k646')$m_data, k = 1, percent = T, dp = 1)
#beamaTrends::td$new('abmi')$get_hilow(k=4,is_low =T)
#td$new('abmi')$get_hilows()
#abc <- td$new(x = 'SPPG-DWD', db_name = 'R:/packages/bistats/inst/extdata/bistats.sqlite')$get_hilows()
# smart_fx <- list(
# `SPPG-DWD` = 'Domestic Wiring Devices',
# `SPPG-DCP` = 'Domestic Circuit Protection'
# )
#
# tp$new(
# "SPPG-DWD,SPPG-DCP", db_name = 'R:/packages/bistats/inst/extdata/bistats.sqlite'
# )$set_y1( 2015 )$set_title("Single Phase Products")$set_y2( 2017 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1e6)$set_brexit_mode(
# T)$set_colour(beamaColours::get_grayblue())$set_delta_x(2)$set_delta_y(5,0)$set_pc('0')$set_dp(1)$plot_pc(
# strip_col= beamaColours::get_grayblue(), min_max_days = 100,
# smart_labels = smart_fx, is_smart =T, ytitle = "Monthly Sales (Million GBP)"
# )
#
# smart_fx <- list(
# `SPPG-DWD` = 'Domestic Wiring Devices',
# `SPPG-DCP` = 'Domestic Circuit Protection'
# )
#
# tp$new(
# "SPPG-DWD,SPPG-DCP", db_name = 'R:/packages/bistats/inst/extdata/bistats.sqlite'
# )$set_y1( 2015 )$set_title("Single Phase Products")$set_y2( 2017 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1e6)$set_brexit_mode(
# T)$set_colour(beamaColours::get_grayblue())$set_delta_x(2)$set_delta_y(5,0)$set_pc('0')$set_dp(1)$plot_pc(
# strip_col= beamaColours::get_grayblue(), min_max_days = 100,
# smart_labels = smart_fx, is_smart =T, ytitle = "Monthly Sales (Million GBP)"
# )
#
# smart_fx <- list(
# `SPPG-DWD` = 'Domestic Wiring Devices',
# `SPPG-DCP` = 'Domestic Circuit Protection'
# )
#
# tp$new(
# "SPPG-DWD,SPPG-DCP", db_name = 'R:/packages/bistats/inst/extdata/bistats.sqlite'
# )$set_y1( 2015 )$set_title("Single Phase Products")$set_y2( 2017 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1e6)$set_brexit_mode(
# T)$set_colour(beamaColours::get_grayblue())$set_delta_x(2)$set_delta_y(5,0)$set_pc('0')$set_dp(1)$plot_pc(
# strip_col= beamaColours::get_grayblue(), min_max_days = 100,
# smart_labels = smart_fx, is_smart =T, ytitle = "Monthly Sales (Million GBP)"
# )
# smart_fx <- list(
# `SPPG-DWD` = 'Domestic Wiring Devices',
# `SPPG-DCP` = 'Domestic Circuit Protection'
# )
#
# tp$new(
# "SPPG-DWD,SPPG-DCP", db_name = 'R:/packages/bistats/inst/extdata/bistats.sqlite'
# )$set_y1( 2015 )$set_title("Single Phase Products")$set_y2( 2017 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1e6)$set_group(
# T)$set_colour(beamaColours::get_grayblue())$set_delta_x(2)$set_delta_y(5,0)$set_pc('0')$set_dp(1)$plot_pc(
# strip_col= beamaColours::get_grayblue(), min_max_days = 100,
# smart_labels = smart_fx, is_smart =T, ytitle = "Monthly Sales (Million GBP)"
# )
# abc <- tf$new('k646')
# gg <- tf$new('k646')$set_ahead(1)$get_fcs(avg_only = T)
# tf$new('k646')$set_ahead(1)$plot_fcs(avg_excl = 'meanf,holt,holtw')
# y <- rpois(20,lambda=.3)
# fcast <- croston(y)
# plot(fcast)
# x <- bistats::pg.get_indx_ts('TOTAL')
# a <- window(x,c(2003,1),c(2015,12))
# b <- window(x,c(2016,1),c(2017,8))
# tfo <- tf$new(a)$set_ahead(2)$set_method_packed('arima,thetaf,mapa,bsts')
# fco <- tfo$get_fcs(avg_excl = 'x12', avg_join = b, is_spread = FALSE)
# tf$new(a)$plot_fcs( plot_excl = NULL, fcs_object = fco, avg_join = 1)
# head(tfo$recalc_forecast_avg(fco = fco, avg_only = T, is_spread = T), 20)
# head( tfo$recalc_forecast_avg(fco = fco,is_spread = T, avg_excl = 'rwf,bsts,meanf,holtw,holt', avg_only = T),20)
# x <- beamaTrends::tp.view_data('ABMI-UKEA')
# a <- window(x, c(2009,1), c(2015,4))
# b <- window(x, c(2016,1), c(2017,4))
#
# tf <- beamaTrends::tf$new( a )$set_ahead(2)
#
# fco <- tf$get_fcs( avg_excl = NULL, avg_join = b, is_spread = FALSE)
# tf$plot_fcs( plot_excl = 'rwf,meanf,thetaf', fcs_object = fco, avg_join = 1, excl_limits = T)
# (
# total_fc <- tf$new(
#
# bistats::pg.get_indx_ts('BEAMA')
#
# )$set_ahead( 2 )$set_method_packed( 'x12,arima,mapa' )$set_x12_exe_path(
#
# 'C:/apps/WinX13/x13as/x13as.exe'
#
# )$set_x12_output_path(
#
# 'C:/apps/WinX13/output/'
#
# )$get_fcs( avg_only = T)
#
# )
# beamaTrends::tp.plot_brexit_indicators(
#
# indicators = 'USDM,EURM,K646,D7BT'
# ,out_gap = 15
# ,dt1 = c(2016,6)
# ,dt2 = c(2017,10)
# ,title = 'UK Economic Indicators'
# ,is_brexit = F
# ,is_smart = T
# ,smart = ESMART_LABELS
# ,ytitle ='Growth since June 2016'
# )
#
# abc = beamaTrends::tg$new(
# beamaTrends::tp_data$new('topsi_orgalime')$get_group(T)
# )$plot(
# select = 'YR',select_yr =c(2000,2017), x_delta = c(1,1), y_delta =c(0,0), skale =1000,
# skale_title = "Monthly Turnover (GBP billion)", is_themed = T, x_breaks = '2 years', smart_labels = list(YR = 'Orgalime Turnover - NACE 25,26,27,28,33')
# )
#
# beamaTrends::tg$new(
# beamaTrends::tp_data$new('topsi_orgalime')$get_group(T)
# )$plot(
# T,select = 'YY1', select_yr =c(2013,2016), x_delta = c(1,1), y_delta =c(1,1), skale =1, ops = 'avg',
# skale_title = "Annual Growth (%)", is_themed = T, x_breaks = '1 years', smart_labels = list(YY1 = 'Orgalime Turnover - NACE 25,26,27,28,33')
# #,brexit_mode = T
# )
# beamaTrends::tg$new(
# beamaTrends::tp_data$new('emp_orgalime_core')$get_group(T)
# )$plot(
# is_growth = T,
# select = 'YY1',select_yr =c(2013,2017), x_delta = c(1,1), y_delta =c(0,0.5), skale =1, ops = 'avg',
# skale_title = "Growth - Employed Persons (yoy%)", is_themed = T, x_breaks = '1 years', smart_labels = list(YY1 = 'Orgalime Employment - NACE 25,26,27,28,33')
# #,brexit_mode = T
# )
# beamaTrends::tp_utils$new()$plot_save('employment_yr_combined_pc',path = GRAPHIC_PATH, skale = 3)
# my_smart = list(
# USD='US Dollar ($)'
# ,EUR = 'Euro (€)'
# ,JPY = 'Japanese (¥)'
# ,CNY = 'Chinese Yuan Renminbi (¥)'
# ,INR = 'Indian Rupee'
# ,BRL = ' Brazillian Real (R$)'
# )
#
#
# tp$new(
# 'USD,EUR,JPY,CNY,BRL,INR'
# )$set_y1( 2014 )$set_y2( 2017 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(F)$set_scale(1)$set_colour(
# beamaColours::get_grayblue())$set_delta_x(2)$set_delta_y(0,0)$set_pc('12')$set_dp(1)$plot_pc(
# strip_col= beamaColours::get_grayblue(), min_max_days = 100,
# smart_labels = my_smart, is_smart =T, ytitle = "12-month % change"
# )
# smart_caps_emp <- list(
# `PROD-SIC-26` = '26 - Electronics',
# `PROD-SIC-27` = '27 - Electrical',
# `PROD-SIC-28` = '28 - Mechanical',
# `PROD-SIC-25` = '25 - Fabricated Metals',
# `PROD-SIC-33` = '33 - Repairs & Installation',
# `PROD-SIC-29` = '29 - Motor Vehicles',
# `PROD-SIC-30` = '30 - Other Transport',
# `PROD-SIC-C` = 'C - Total Manufacturing'
#
# )
# beamaTrends::tp$new(
# "PROD-SIC-25,PROD-SIC-26,PROD-SIC-27,PROD-SIC-28,PROD-SIC-33,PROD-SIC-29,PROD-SIC-30,PROD-SIC-C" #beamaTrends::tp_data$new('emp_orgalime_core')$get_group(T)
# )$set_y1( 2000 )$set_y2( 2020 )$set_avg(F)$set_fx('q')$set_breaks(
# "5 years")$set_breaks_fmt("%Y")$set_min_max(F)$set_scale(1)$set_brexit_mode(
# T)$set_colour(beamaColours::get_euris_blue_light())$set_delta_x(2)$set_delta_y(0,0)$set_pc('4')$set_dp(1)$plot_pc(
# ytitle="Output / Head (GBP)",strip_col= beamaColours::get_euris_blue(),
# smart_labels = smart_caps_emp, is_smart =T
#)
# wh_all <- paste(whlist, sep="",collapse = ",")
# wh_top_list <- c('EDMUNDSON','FEGIME','ANEW','OTHERS','ELECTRICCENTRE','NEWEY')
# wh_top <- paste(wh_top_list,sep="",collapse = ",")
# wh_bot_list <- c('AWEBB','CEF','DENMANS','WFSENATE','WILTS','YESSS','SCREWFIX','RETAIL')
# wh_bot <- paste(wh_bot_list, sep = "", collapse = ",")
# retail_list <- c('SCREWFIX','RETAIL')
# retail_all <- paste( retail_list, sep = '', collapse = ',')
#
# wh_smart <- list(
# OTHERS = 'OTHER WHOLESALERS',
# ELECTRICCENTRE = 'ELECTRIC CENTRE',
# WFSENATE = 'WF SENATE',
# RETAIL = 'OTHER RETAILERS'
# )
# beamaTrends::tp$new(
# paste('PG', wh_top_list,sep='-',collapse = ','), db = bistats::bistats_utils$new()$get_db()
# )$set_yintercept(100)$set_y1( 2015 )$set_y2( 2020 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1)$set_brexit_mode(
# F)$set_delta_x(2)$set_delta_y(0,0)$set_pc('0')$set_dp(0)$plot_pc(
# min_max_days = 100,
# smart_labels = wh_smart, is_smart =T, ytitle = "Index (Jan 2013 = 100)"
# )
# df_share <- bistats::pg.get_data(y1 = 2014)
# df_share <- sqldf::sqldf("select yr,mth,wholesaler,sum(total) as total from df_share group by yr,mth,wholesaler ")
# df_share <- dplyr::mutate(
# dplyr::group_by( df_share, yr, mth),
# pc = 100*( total / sum(total) ),
# dy = 1,
# data_desc = wholesaler
# )
#
# names(df_share) <- c('yr','mth','data_code','value','pc','dy','data_desc')
#
# beamaTrends::tp$new(
# df_share
# )$set_y1( 2014 )$set_y2( 2020 )$set_avg(T)$set_fx('m')$set_breaks(
# "1 year")$set_breaks_fmt("%Y")$set_min_max(T)$set_scale(1)$set_delta_x(
# 2)$set_delta_y(0,0)$set_pc('0')$set_dp(0)$plot_pc(
# min_max_days = 100, is_smart =T, ytitle = "Market Share (%)"
# )
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.