Saturday, 30 December 2017

AAStocks Chart Codes

AAStocks is a popular stock market charting platform in Hong Kong. The market that it covers include HK shares, US shares, and currencies. Its charts are one of the most frequently embedded gadgets among different websites.

Since the charts could be custom-made with different indicators, periods, and so on, it helps to know the meaning of each table values which is retrieved from the hyperlink, and the available values it has.

Saturday, 23 December 2017

CSV format for Google Calendar

CSV format for Google Calendar contains the following elements:

-- Subject: title of your event or activity.
-- Start Date: the starting date of the event or activity.
-- Start Time: the starting time of the event or activity.
-- End Date: the ending date of the event or activity.
-- End Time: the ending time of the event or activity.
-- All Day Event: TRUE if an all-day event, else FALSE.
-- Description: the description of the event or activity.
-- Location: the location of the event or activity.
-- Private: TRUE if it is not seen in shared calendars, else FALSE.

Saturday, 16 December 2017

Excel Lookup to the Nearest, Above or Below

This article is about how use lookup function to find the nearest item above or below in Excel or Calc. Currently, the default function in VLOOKUP or HLOOKUP only rounds to the smaller value, so it takes a few tricks to round the value to the closest one above or below.

Let us consider the following practical example. Suppose there is a marathon race, and in case if you have no idea, it has a running distance of 42 km. The organiser has made the following rule regarding first aid. At each interval of 7 km, including the start and the finish, there shall be an first-aid station which helps the injured runners.In other words, there are altogether 7 stations in total. It is expressed in the table below: