Input box and save it to A1 
/////////////////////////

Sub inputValue()
   Dim myValue As Variant
   myValue = InputBox("Give an input and save it to A1")
   Range("A1").Value = myValue
End Sub

/////////////////////////

Links 
///////////////////////////////
R examples
    http://www.rexamples.com/

R Programming Examples
   https://www.programiz.com/r-programming/examples
/////////////////////////////////

Macro 4 unhide the 1st column and 1st row
/////////////////////////

Sub unhideFirst_col_row()
    Application.Goto Reference:="R1C1"
    Selection.EntireColumn.Hidden = False
    Application.Goto Reference:="R1C1"
    Selection.EntireRow.Hidden = False
    Range("A1").Select
End Sub

/////////////////////////

Macro 4 add_rwo_column (Binomial Tree option model)
/////////////////////////
' note: B1 contains the starting cell, such as f10
'       B2 contains the number of steps such as 7

Sub Add_row_column()
    Dim a As String
    Dim i, n As Integer
    Dim Range1 As Range
    a = Range("B1").Value
    n = Range("B2").Value
    For i = 1 To n
        Range(a).Offset(-1 - n, i).Value = i
    Next i
    For i = 1 To n + 1
        Range(a).Offset(i - n - 1, -1).Value = n - i + 1
    Next i
    For i = 1 To n
        Range(a).Offset(i, -1).Value = -i
    Next i
End Sub

/////////////////////////

DateOffSet 
/////////////////////////
from pandas.tseries.offsets import DateOffset

training_begin = X.index.min()   # Select the start of the training period

print(training_begin)

# Select the ending period for the training data with an offset of 3 months
training_end = X.index.min() + DateOffset(months=3) 

/////////////////////////

AWS: IAM setup
/////////////////////////
IAM stands for 'Identity and Access Management'
  Step 1: login with your root account
  Step 2: search for 'IAM' -> IAM console
  Step 3: click 'Users' on the left-hand side 
          -> add user -> a name -> access type
  Step 4:Select AWS credential type
          -> password ->AWS Management console access
          -> Consol -> custom password
          -> uncheck [user must create a new password at next sign-in]
          -> next permission
  Step 5: create group -> grope name -> [policy ]
          -> administratorAccess -> create group
  Step 6: add tags [optinal] -> next review
  Step 7: create user
  Step 8: sign-in
           a) 12 digits
           b) user name
           c) password
/////////////////////////