HSI daily return with kdb+q

select Date, Open2CloseReturn: (Close-Open)%Open, OvernightGap: (Open-prev AdjClose)%prev AdjClose from t

select Date, LnOpen2CloseReturn:log Close%Open, LnOvernightGap:log Close%prev AdjClose from t