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:

Sunday, 22 October 2017

The Power of Affirmations

Scott Adams is the famous creator of comic strip Dilbert, and he is also a great fan of self affirmations. In this following video segment, it is told that Scott has used affirmations to achieve great things in his life, including winning in the stock market, getting into a great university, becoming a successful cartoonist, and writing more than one New York Times bestsellers.

Basically, what he did was to wake up every morning and wrote down his goal dozens of times, and in present tense. For example, at one point he wanted to make money in the stock market, so he wrote, “I, Scott, have made money in the stock market.” And sure enough, one night the name of a big winner came to him, and all he had to do was to buy it.

Saturday, 7 October 2017

Graphic Issues of Red Alert 2 in Window 10

A lot of people have downloaded the Red Alert 2 & Yuri’s Revenge bundle from Origin. They often find that the Yuri’s Revenge part has some problem with the graphics in Window 10.

If you choose a resolution bigger than 800 times 600, then the screens pressed against the left with black on the right. In addition to the “halved” screens, the screen with the game playing (at normal speed and without lag) is mis-coloured: everything is purple, red, green, and blue pixels like the game cannot decide what colored pixels go where.

Here are the steps to fix it:

Thursday, 14 September 2017

Bill Meridian on Eclipses

Bill Meridian is a famous financial astrologer. Robert W. Colby, America’s foremost expert on technical analysis, wrote that Bill is “an internationally renowned financial researcher, fund manager, and designer of analytical software, including the first program developed for researching the correlation between time series data and cycles.”

In the following series of videos, he explains the predictive power of solar and lunar eclipses in mundane affairs. He used the natal charts of many different famous people in history to demonstrate his point. This is highly recommended if you are interested in mundane astrology.

Sunday, 25 June 2017

The Pyramid Code

The Pyramid Code is a documentary series of 5 episodes that explores the pyramid fields and ancient temples in Egypt as well as ancient megalithic sites around the world looking for clues to matriarchal consciousness, ancient knowledge and sophisticated technology in a Golden Age.

The Pyramid Code features interviews with prominent scholars and authors in multidisciplinary fields: geology, physics, astrophysics, archeology, biological engineering, magnetic field theory, hieroglyphics, and Egyptology.