This post offers reasons for using logarithmic scales, also called log scales, on charts and graphs. It explains when logarithmic graphs with base 2 are preferred to logarithmic graphs with base 10. Some of your data is numbers, some is not. All those 'numbers' that end with 'g' or 'mg' are considered to be text. Those data points will not be included in any charts. Numbers is getting confused by these two things together. If you fix the data so it is all numbers (remove the g's and mg's), you should be able to plot the data correctly.
- Logarithmic Chart Excel
- Logarithmic Stock Chart
- Reading A Logarithmic Chart
- Logarithmic Charts In Numbers For Macbook Air
Interested in Trading Risk-Free?
Build your trading muscle with no added pressure of the market. Explore TradingSim For Free »
- Apple numbers can only be run in MAC systems, whereas, Excel comes in different versions for both Windows and Mac compatible. Excel is suitable for big business and a vast inventory calculation. Apple numbers, on the other hand, are best for crunching huge figures, and other causal purposes too.
- Returns the least common multiple of the specified numbers. Returns the natural logarithm of a number, the power to which e must be raised to result in the number. Returns the logarithm of a number using a specified base. Returns the base‑10 logarithm of a number. Returns the remainder from a division.
Every stock chart contains two axes – x-axis to plot time and y-axis to plot price.
There are basically two ways to plot price – linear and logarithmic.
While most traders are unaware of how the price scale is set, there are some key points every trader should consider.
In this article, we will discuss the five key differences between semi-log and linear scale on price charts.
1. Measuring Price – Linear vs. Log-scale
Linear Scale<.h3>
There are some traders who expect to see an equal distribution of price values on the y-axis – linear scale.
Logarithmic Chart Excel
For example, a linear price chart could have an equal distance of 5 units on the y-axis (i.e. 0, 5, 10, 15).
The chart below shows an example of the linear scale chart for Apple (AAPL). You can see that the price chart has a y-axis with a .20 unit of measure.
Example of linear scale chart with distance of $0.20
Logarithmic Scale
Conversely, the logarithmic chart displays the values using price scaling rather than a unique unit of measure.
With a logarithmic chart, the y-axis is structured such that the distances between the units represent a percentage change of the security. For example, this percentage difference can be 5%, 10% or 15%.
The next chart shows the same Apple stock chart but with logarithmic scale enabled.
Example of log scale chart with distance of 0.30% approximately
While prices look rather congested at the bottom, such as 140.40, 140.70 and so on, the distribution becomes spread out further apart as price values progresses.
This is because as the values increase in size, the preceding units of measure are smaller and thus visually look smaller on the chart.
Now imagine a stock that first traded at $50 dollars and over time trades north of $300 dollars (i.e. Netflix). The early years of trading at the lower price levels will look like rooftops when you are looking out of the window of an airplane before you land.
2. More Volatility = Logarithmic Scale
If a security has small price moves and choppy trading action, a linear chart would probably be the best method for charting the stock.
However, we know price movement for penny stocks and biotechs is anything but boring.
For these types of securities, the logarithmic price chart makes more sense as it can visually capture the significance of the larger price moves.
Sea rayder jet boat manual. The next chart shows a comparison of a linear and logarithmic chart for Intel (INTC).
Comparison of the linear and logarithmic scales for INTC price chart
Although both the linear and the log-scale might look very similar, the differences stand out when you closely review the distribution of the price on the y-axis.
It is evident that the linear price chart shows a more curved line. You can also see the linear chart somewhat depicts the idea that price moved rather slowly in the initial periods before price started to move more rapidly in the latter parts.
This distortion occurs because the price is in absolute dollar terms. On the other hand, the logarithmic chart shows a steady 1% approximate percentage change in the values and shows a more uniform scale of price change over the period of time.
Therefore, a logarithmic chart is more suited in the above example as it depicts the growth of the stock price on a steady note with a fairly straight trajectory. When the pace of growth starts to change, the logarithmic chart also adjusts accordingly and depicts the change accordingly, which isn't the case with a linear chart because the values remain the same, regardless of whether price moved just $0.50 or 5%.
3. Logarithmic Scales are Useful for Long-Term Perspective
1. Measuring Price – Linear vs. Log-scale
Linear Scale<.h3>
There are some traders who expect to see an equal distribution of price values on the y-axis – linear scale.
Logarithmic Chart Excel
For example, a linear price chart could have an equal distance of 5 units on the y-axis (i.e. 0, 5, 10, 15).
The chart below shows an example of the linear scale chart for Apple (AAPL). You can see that the price chart has a y-axis with a .20 unit of measure.
Example of linear scale chart with distance of $0.20
Logarithmic Scale
Conversely, the logarithmic chart displays the values using price scaling rather than a unique unit of measure.
With a logarithmic chart, the y-axis is structured such that the distances between the units represent a percentage change of the security. For example, this percentage difference can be 5%, 10% or 15%.
The next chart shows the same Apple stock chart but with logarithmic scale enabled.
Example of log scale chart with distance of 0.30% approximately
While prices look rather congested at the bottom, such as 140.40, 140.70 and so on, the distribution becomes spread out further apart as price values progresses.
This is because as the values increase in size, the preceding units of measure are smaller and thus visually look smaller on the chart.
Now imagine a stock that first traded at $50 dollars and over time trades north of $300 dollars (i.e. Netflix). The early years of trading at the lower price levels will look like rooftops when you are looking out of the window of an airplane before you land.
2. More Volatility = Logarithmic Scale
If a security has small price moves and choppy trading action, a linear chart would probably be the best method for charting the stock.
However, we know price movement for penny stocks and biotechs is anything but boring.
For these types of securities, the logarithmic price chart makes more sense as it can visually capture the significance of the larger price moves.
Sea rayder jet boat manual. The next chart shows a comparison of a linear and logarithmic chart for Intel (INTC).
Comparison of the linear and logarithmic scales for INTC price chart
Although both the linear and the log-scale might look very similar, the differences stand out when you closely review the distribution of the price on the y-axis.
It is evident that the linear price chart shows a more curved line. You can also see the linear chart somewhat depicts the idea that price moved rather slowly in the initial periods before price started to move more rapidly in the latter parts.
This distortion occurs because the price is in absolute dollar terms. On the other hand, the logarithmic chart shows a steady 1% approximate percentage change in the values and shows a more uniform scale of price change over the period of time.
Therefore, a logarithmic chart is more suited in the above example as it depicts the growth of the stock price on a steady note with a fairly straight trajectory. When the pace of growth starts to change, the logarithmic chart also adjusts accordingly and depicts the change accordingly, which isn't the case with a linear chart because the values remain the same, regardless of whether price moved just $0.50 or 5%.
3. Logarithmic Scales are Useful for Long-Term Perspective
To quickly recap, the price scale is equal with linear charts. This means that a move from $100 to $150, which represents a 40% move is the same as a move from $200 to $250.
You can see that the distribution here is $50 per unit, but in percentage terms, you have a 40% move initially (from $100 to $150) and a 22% approximate move from $200 to $250.
In such cases, large price movements are better with logarithmic charts which focus on the percentage of the move.
4. Linear Scale for Day Traders
On the other hand, a linear price scale is more applicable to analyze a security that is moving in a tight range or within a short time frame such as intraday trading sessions.
Linear scale is ideal for intraday charts or short term charts
The above chart example shows a 10-minute price chart for AAPL using a linear price scale. Again, the units are an equal distance of $0.20 cents. You can also see an example of a simple breakout method relatively easy to spot and trade.
Because of the equal distribution in absolute dollar terms, the $0.20 price range that was established in the sideways market gives the upside and the downside target at a distance of $0.20 making it relatively easy to trade the short term price charts.
Even if you would use a logarithmic scale on the intraday charts, because the price movements are typically confined, you will get the same results as using the linear scale chart.
5. Which Price Scale to Use?
When it comes to analyzing stocks, the price of the security is usually analyzed in relative terms. Metrics such as price earnings ratio, price book values are popular financial ratios. Thus, when depicting the price of the security in question, it makes more sense to represent or analyze the security's stock movement in percentage terms rather than in absolute values.
Therefore, chances are that traders are automatically shown the appropriate price scale without even knowing the difference between the two types of price scales.
At the end of the day, the security dictates whether you should choose a linear price scale or a semi-log chart or a logarithmic scale chart.
Even within stocks, not all securities behave similarly. While on one hand there are stocks that have explosive price movements, there are also stocks that are typically confined to a range over years.
Bonus – 6. Trends are Better with a Log-scale Chart
I decided to update this article with a sixth section covering trend lines on two chart types.
Let's start with a simple example of drawing trend lines for the same security and compare how the trend lines evolve between a linear and logarithmic chart.
Trend lines plotted on a linear and a logarithmic chart
The above chart shows Intel Corp (INTC). On the left we have a linear price chart and on the right is the logarithmic chart.
Keep talking and nobody explodes for mac. The trend lines plotted on both charts are exactly the same.
This brings us to the question of which of the two charts depicts the trend accurately? It is the logarithmic price scale chart on the right side which shows the trend lines much better as compared to the trend lines from the left.
The answer to this question I'm going to leave up to you.
In Summary – Which Scale is Better?
The answer to this question depends on a number of factors such as the security in question and how price behaves and of course the time frame as well. However, the log scale or the semi-logarithmic price scale is more popular than the linear scale.
Nearly all charting platforms default to the logarithmic scale as the units are equally spaced in percentage terms, making it easier to use the log scale as a base chart across any security that a trader wants to analyze.
Logarithmic Stock Chart
As illustrated above in some of the examples, there are clearly certain scenarios where using one type of price scale is definitely better. At the end of the day the type of and its price behavior will determine the right price scale.
Reading A Logarithmic Chart
Daily Charts – Should Day Traders Use Them?
Logarithmic Charts In Numbers For Macbook Air
5 Key Differences between Logarithmic Scale and Linear Scale
