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.

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.

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:

De-DRM with Calibre

Intrusive DRM often means ebooks you've purchased can only be read on one type of device, especially when it comes to the Amazon products like the Kindle Voyage.

Here's how to remove ebook DRM, so you can read your purchases on any of your multiple devices, including competing e-readers.

Fixing Window 10 Wifi

It could be stated, without exaggeration, that Window 10 is one of the most disturbing operation systems in computer history. Almost every update that comes with it brings problem to the user. One of the most recent update is reported to have messed up the WiFi drivers in thousands of computers. Even though the company has responded to the situation, and urged the affected users to update their drivers as soon as possible, they do not elaborate on how the users are supposed to download the driver when they cannot use their WiFi in the first place.

Pseudo Profiles

This post is a collection of online resources which allows you to create fake personal info and network location on the Internet. The purpose of this post is to help system and website developers to perfect their websites or databases. Using such tools for illegal purposes is not encouraged by this article, and the readers are responsible for the consequences of their actions.