Elementary measures
So far, we have defined number of different terms used in Pyramid Investing: some price-related terms such as Top, Bottom and Step or amount-related terms such as Base and Increment. Values of these terms represent elementary measures of a pyramid. These terms as a group, that is combination of their values, uniquely define any arbitrary pyramid. In other words, we can say that any pyramid is fully determined by values of the following terms:
- Top
- Bottom
- Step
- Base and
- Increment
If the value of any one of these terms is missing, the pyramid is undetermined. The only “redundant” term in this group may be the Bottom and only because we assume bottom is zero unless specified differently.
Many times, we will refer to a specific pyramid and list the values of its Top, Step, Base and Increment. No matter how big the pyramid is or how many discrete levels it has, these four elementary measures are all we need to uniquely describe the pyramid in question. Elementary measures determine position and shape of a pyramid.
Derived measures
Beside elementary measures, we make use of other measures that are derived from elementary ones. The process of deriving actually involves some simple calculations. For example, the price at each Depth is derived from Top and Step. The formula to calculate Price (n) that corresponds to Depth n is:
Price (n) = Top − n × Step
Similarly, the amount of shares bought at certain Depth n is derived from Base and Increment:
Size (n) = Base + (n−1) × Increment
I would like to note that the last formula does not hold in general case since Size (n) is not uniquely defined for arbitrary Depth n due to dynamics of trading. However, for the sake of this article, we will assume that price descends in a straight line from top to the bottom. In such a case, the formula above holds true and we can freely make use of it.
We can further derive dollar value of Trade that occurs at Depth n, which is calculated from corresponding price and the amount of shares traded at that level:
Trade (n) = Price (n) × Size (n)
Trade (n) = [Top − n × Step] × [Base + (n−1) × Increment]
Even though these formulas involve some basic mathematics, their calculation is rather tedious if we attempt to do it on a piece of paper. However, with a help of any spreadsheet software, results for multiple levels can be obtained instantaneously.
Cost of a pyramid
Most frequently used derived term or measure is cost of a pyramid. Cost of a pyramid is sum of all trades across all pyramid levels. In simple terms, cost of a pyramid represents the amount of money we would need to buy the whole pyramid or the amount of dollars we would employ if the price of underlying stock went to zero. We sincerely hope that our underlying stock will never go to zero, but nevertheless the cost of a pyramid represents ultimate amount of money to be used for a given pyramid in the most extreme scenario.
In terms of risk, cost of a pyramid is the maximum amount of money we can possibly lose applying a given pyramid. It is always good that the risk is limited and easy to calculate. It may not be so easy to accept this risk but we certainly have a way to deal with it. Besides, who said that investing is risk-free endeavor anyway?
Cost of a pyramid is very important measure and we heavily rely on it in the process of Pyramid Investing planning. As I mentioned elsewhere, Pyramid Investing consists of meticulous planning and robotical (virtually emotion-free) execution of the plan. Cost of a pyramid is also unavoidably exploited in calculation of Pyramid Investing returns. We will address each of these issues separately. For now, it is important to understand how to calculate the cost for a given pyramid.
Example of pyramid cost calculation
So let’s assume that the pyramid we want to calculate the cost of is given by the following elementary measures:
- Top = $11
- Step = $2
- Base = 10sh
- Increment = 5sh
First, we need to calculate price for each pyramid Depth:
Price (n) = Top − n × Step
Price (1) = $11 − 1 × $2 = $9
Price (2) = $11 − 2 × $2 = $7
Price (3) = $11 − 3 × $2 = $5
Price (4) = $11 − 4 × $2 = $3
Price (5) = $11 − 5 × $2 = $1
Price (6) = $11 − 6 × $2 = −$1
In this process, we increase the Depth and calculate corresponding price. Although we say Bottom is zero, practically only non-zero and positive prices make sense. Therefore we repeat the process until we hit either zero or some negative price. We stop there and we do not include that last calculation. In our example, pyramid has five depths and actual Bottom is $1.
For the sake of accuracy, I would like to point out that, strictly looking, the unit for Top, Step and Price is $/sh (dollar per share). We use $ sign only for the reasons of simplicity.
Now, we calculate the amount of shares bought at each Depth n:
Size (n) = Base + (n−1) × Increment
Size (1) = 10 + (1−1) × 5 = 10sh
Size (2) = 10 + (2−1) × 5 = 15sh
Size (3) = 10 + (3−1) × 5 = 20sh
Size (4) = 10 + (4−1) × 5 = 25sh
Size (5) = 10 + (5−1) × 5 = 30sh
Then, we multiply price and amount of shares for each Depth n to obtain corresponding Trade dollar amount:
Trade (n) = Price (n) × Size (n)
Trade (1) = $9 × 10sh = $90
Trade (2) = $7 × 15sh = $105
Trade (3) = $5 × 20sh = $100
Trade (4) = $3 × 25sh = $75
Trade (5) = $1 × 30sh = $30
Finally, we sum up all trades to obtain the Cost of our pyramid:
Cost = ∑ Trade (n), where n = 1,…,N
Cost = Trade (1) + Trade (2) + Trade (3) + Trade (4) + Trade (5)
Cost = $90 + $105 + $100 + $75 + $30
Cost = $400
Therefore, the Cost of our pyramid is $400. If we change any of initial elementary measures, subsequent pyramid gets to be different and that may result in corresponding Cost to change. This is not to say that two different pyramids cannot have the same cost.
Cost is usually given
In practice, instead of calculating cost for a given pyramid, we usually have a cost that is given. Therefore, our task is to design a pyramid that fits the given cost. This is normally an iterative process. Besides trying to satisfy the given cost, we also strive to take care of other aspects of a pyramid at the same time. This process of designing a pyramid is also called shaping the pyramid. In future articles, we will dedicate considerable attention to the process of pyramid shaping. We will also address various criteria we want to satisfy (or at least make the trade off) during this process.
Talking about the cost of a pyramid, we can also say that some pyramids are “costlier” than others. Of course, pyramids that have larger cost are “more expensive”. This means that we need more investing capital to properly cover more expensive pyramids.
Pyramid in a spreadsheet form
Graphical representation of pyramids is good for initial understanding of terms and their relationships. However, practical use of pyramids involves more abstract representation that is also more suitable for our investing purposes. We normally turn to spreadsheets that also help us in number crunching activities. I extensively use Excel spreadsheets to help me in daily Pyramid Investing efforts.
The following figure shows the above-mentioned pyramid in a spreadsheet form:
This is only a snapshot (screen capture) of a spreadsheet pyramid and therefore it is not interactive. Actual spreadsheet contains above-mentioned formulas in corresponding cells and is capable of calculating values based on given elementary measures of a pyramid. Cost of a pyramid is highlighted in yellow.











