This line chart doesn’t use logarithmic scaling of the value axis. A line chart that plots two competitors’ sales but without logarithmic scaling. Now, take a look at the line chart shown in the following figure. This is the same information in the same chart type and subtype, but the scaling of the value axis is changed to use logarithmic. The logarithmic chart is only available in the Streaming Charts. Click on the 'Chart' link in the instrument page. The logarithmic button is at the bottom-right of the chart ('log&qu. Advantages of Log Scales. A log scale is highly useful if the price of the stock you wish to chart has moved by a large percentage over the period your chart will cover.
- Logarithmic Charts In Numbers For Mac Os
- Logarithmic Charts In Numbers For Macbook Air
- Why Use A Logarithmic Chart
- Reading A Logarithmic Chart
- Excel Chart Logarithmic Scale
- Logarithmic Chart Scale
Interested in Trading Risk-Free?
Highcharts Demo: Logarithmic axis. This chart shows the use of a logarithmic y-axis. Logarithmic axes can be useful when dealing with data with spikes or large value gaps, as they allow variance in the smaller values to remain visible. This guide helps you get started using Numbers 10.3 on your Mac. To see the version of Numbers on your Mac, choose Numbers About Numbers (from the Numbers menu at the top of your screen). To browse this guide, click Table of Contents near the top of this page, or enter a.
Build your trading muscle with no added pressure of the market. Explore TradingSim For Free »
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.
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.
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.
Logarithmic Charts In Numbers For Mac Os
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.
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.
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.
Co-Founder Tradingsim
Al Hill is one of the co-founders of Tradingsim. He has over 18 years of day trading experience in both the U.S. and Nikkei markets. On a daily basis Al applies his deep skills in systems integration and design strategy to develop features to help retail traders become profitable. When Al is not working on Tradingsim, he can be found spending time with family and friends.
web
email
POPULAR LESSONS IN THE COURSE:Intro to Stock Charts
Lesson 1
Daily Charts – Should Day Traders Use Them?
Lesson 2
5 Key Differences between Logarithmic Scale and Linear Scale
Just as with exponential functions, there are many real-world applications for logarithmic functions: intensity of sound, pH levels of solutions, yields of chemical reactions, production of goods, and growth of infants. As with exponential models, data modeled by logarithmic functions are either always increasing or always decreasing as time moves forward. Again, it is the way they increase or decrease that helps us determine whether a logarithmic model is best.
Recall that logarithmic functions increase or decrease rapidly at first, but then steadily slow as time moves on. By reflecting on the characteristics we’ve already learned about this function, we can better analyze real world situations that reflect this type of growth or decay. When performing logarithmic regression analysis, we use the form of the logarithmic function most commonly used on graphing utilities, [latex]y=a+bmathrm{ln}left(xright)[/latex]. For this function
Logarithmic Charts In Numbers For Macbook Air
- All input values, x, must be greater than zero.
- The point (1, a) is on the graph of the model.
- If b > 0, the model is increasing. Growth increases rapidly at first and then steadily slows over time.
- If b < 0, the model is decreasing. Decay occurs rapidly at first and then steadily slows over time.
A General Note: Logarithmic Regression
Logarithmic regression is used to model situations where growth or decay accelerates rapidly at first and then slows over time. We use the command “LnReg” on a graphing utility to fit a logarithmic function to a set of data points. This returns an equation of the form,
Note that
- all input values, x, must be non-negative.
- when b > 0, the model is increasing.
- when b < 0, the model is decreasing.
How To: Given a set of data, perform logarithmic regression using a graphing utility.
- Use the STAT then EDIT menu to enter given data.
- Clear any existing data from the lists.
- List the input values in the L1 column.
- List the output values in the L2 column.
- Graph and observe a scatter plot of the data using the STATPLOT feature.
- Use ZOOM [9] to adjust axes to fit the data.
- Verify the data follow a logarithmic pattern.
- Find the equation that models the data.
- Select “LnReg” from the STAT then CALC menu.
- Use the values returned for a and b to record the model, [latex]y=a+bmathrm{ln}left(xright)[/latex].
- Graph the model in the same window as the scatterplot to verify it is a good fit for the data.
Example 2: Using Logarithmic Regression to Fit a Model to Data
Due to advances in medicine and higher standards of living, life expectancy has been increasing in most developed countries since the beginning of the 20th century.
The table below shows the average life expectancies, in years, of Americans from 1900–2010.[1]
Year | 1900 | 1910 | 1920 | 1930 | 1940 | 1950 |
Life Expectancy(Years) | 47.3 | 50.0 | 54.1 | 59.7 | 62.9 | 68.2 |
Year | 1960 | 1970 | 1980 | 1990 | 2000 | 2010 |
Life Expectancy(Years) | 69.7 | 70.8 | 73.7 | 75.4 | 76.8 | 78.7 |
- Let x represent time in decades starting with x = 1 for the year 1900, x = 2 for the year 1910, and so on. Let y represent the corresponding life expectancy. Use logarithmic regression to fit a model to these data.
- Use the model to predict the average American life expectancy for the year 2030.
Why Use A Logarithmic Chart
Solution
Reading A Logarithmic Chart
- Using the STAT then EDIT menu on a graphing utility, list the years using values 1–12 in L1 and the corresponding life expectancy in L2. Then use the STATPLOT feature to verify that the scatterplot follows a logarithmic pattern.Use the “LnReg” command from the STAT then CALC menu to obtain the logarithmic model,[latex]y=42.52722583+13.85752327mathrm{ln}left(xright)[/latex]Next, graph the model in the same window as the scatterplot to verify it is a good fit.
- To predict the life expectancy of an American in the year 2030, substitute x = 14 for the in the model and solve for y:[latex]begin{cases}yhfill & =42.52722583+13.85752327mathrm{ln}left(xright)hfill & text{Use the regression model found in part (a)}text{.}hfill hfill & =42.52722583+13.85752327mathrm{ln}left(14right)hfill & text{Substitute 14 for }xtext{.}hfill hfill & approx text{79}text{.1}hfill & text{Round to the nearest tenth.}hfill end{cases}[/latex]If life expectancy continues to increase at this pace, the average life expectancy of an American will be 79.1 by the year 2030.
Excel Chart Logarithmic Scale
Try It 2
Sales of a video game released in the year 2000 took off at first, but then steadily slowed as time moved on. The table below shows the number of games sold, in thousands, from the years 2000–2010.
Year | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 |
Number Sold (thousands) | 142 | 149 | 154 | 155 | 159 | 161 |
Year | 2006 | 2007 | 2008 | 2009 | 2010 | -- |
Number Sold (thousands) | 163 | 164 | 164 | 166 | 167 | -- |
a. Let x represent time in years starting with x = 1 for the year 2000. Let y represent the number of games sold in thousands. Use logarithmic regression to fit a model to these data.
b. If games continue to sell at this rate, how many games will sell in 2015? Round to the nearest thousand.
b. If games continue to sell at this rate, how many games will sell in 2015? Round to the nearest thousand.
Logarithmic Chart Scale
- Source: Center for Disease Control and Prevention, 2013↵