Introduction

Alvin Tan created interesting Noteboook, which is partly used in this presentation. The Investopedia information source is also used. In addition, a Bookdown of Technical Analysis with R (second edition) from Ko Chiu Yu and ChatGPT were helpful with the coding in R.

Technical analysis is a method to predict price movement in the financial markets. Unlike the usual balance sheet analysis (fundamental investing), technical analysis estimates the value of a given stock using underlying trends of the price movement. The core assumption behind this method is that the fundamentals (information from financial statements) were factored into the price fluctuation, hence, detecting the patterns and signals from the fluctuation should provide sufficient indicator for future performance.

For this project, we are going to explore some of the common technical indicators using the TQQQ Exchange trade fund (ETF) stock. Among leveraged ETFs, ProShares UltraPro QQQ (TQQQ) is one of the largest with assets under management of \(\$18.56\) billion as of July 2022. TQQQ is also one of the more heavily traded leveraged ETFs in the U.S. with an average daily volume of \(\$5.29\) billion (compared with QQQ’s \(\$21\) billion).

TQQQ carries an expense ratio of 0.95%.

#install.packages("quantmod")
#install.packages("data.table")
#install.packages("ggplot2")
#install.packages("tidyquant")
library(quantmod)
library(data.table)
library(ggplot2)

Data Extraction & Manipulation, Data structure

TQQQ data is extracted using the getSymbols function from Yahoo Finance. Alternatively, the source can be replaced with FRED, MySQL, Google, or others. The data extracted should be in an ‘xts’ object - a format commonly used in time series analysis where observations are recorded in a matrix structure with an index of corresponding time.

Technically, analysis can be done in xts format alone, but for the sake of simplicity, data is converted into a standard dataframe and index column is renamed as “Date’. The end result is shown as below:

getSymbols('NSANY',src = 'yahoo')       ## change TQQQ ticker to Your ticker symbol
[1] "NSANY"

structure of the stock data

stock <<- as.data.table(NSANY)        ###### change TQQQ ticker to Your ticker symbol  #########
names(stock)[1] <- c('Date')

tail(stock)
# feel free to change "HLCO" to "candlestick" or to some other types ("lines", "auto"). 
chartSeries(stock, subset='2020-01-01::2020-09-23', type = "candlesticks", bar.type = "ohlc",theme=chartTheme('white'))

chartSeries(stock,
            subset='2020-01-01::2020-09-23', type = "candlestick",
            theme=chartTheme('white'))

addSMA(n = 12, on = 1, with.col = Cl, overlay = TRUE, col = "brown")

addSMA(n = 24, on = 1, with.col = Cl, overlay = TRUE, col = "blue")

NA
NA

The moving average provide us with various buy and sell signals. We can see that there is a sell signal from January 1st until April 15th where we can see a significant sell signal. From April 15th the short term average intersects the long term in the up direction so we can see a significant buy signal until June 20th.From June 20th the short term average intersects the long term in the down direction so we can see a sell signal until July 13th. After that we can see a short buy signal from July 13th until July 20th. From July 20th we can see a short sell signal until August 7th. From August 7th based on the long and short term average we can see a buy signal until August 27th. After that we can only see that the prices are below average so that shows us a sell signal.

chartSeries(stock,
            subset='2020-01-01::2020-09-23', type = "bars",
            theme=chartTheme('white'))

addMACD(fast=12,slow=26,signal=9,type="EMA")

The moving average convergence divergence provide us with various buy and sell signals and shows us the momentum and trend directions. From the beginning we can see that the signal line is above the MACD line March 25th which means that it is a bearish signal that show us that this is a sell signal. From March 25th the MACD line intersects with the signal line in the up direction until June 13th so that show us a buy signal and it is considered a bullish signal.From June 13th the MACD line intersects with the signal line in the down direction until August 8th which means this is a sell signal. From August 8th until September 1st the MACD line is above the signal line so that is a buy signal.From Septerber 1st until the end the MACD line is below the signal line which means that is a sell signal.

chartSeries(stock,
            subset='2020-01-01::2020-09-23', type = "bars",
            theme=chartTheme('white'))

addBBands(n = 20, sd = 2, maType = "SMA", draw = 'bands', on = -1)

chartSeries(stock,
            subset='2020-01-01::2020-09-23', type = "bars",
            theme=chartTheme('white'))

addRSI(n = 14, maType = "EMA", wilder = TRUE)

chartSeries(stock,
            subset='2020-01-01::2020-09-23', type = "bars",
            theme=chartTheme('white'))

addSAR(accel = c(0.02, 0.2), col = "blue")

NA
NA
chartSeries(stock,
            subset='2020-01-01::2020-09-23', type = "bars",
            theme=chartTheme('white'))

addBBands(n=20,sd=2)

addRSI(n=14,maType="EMA")

addMACD(fast=12,slow=26,signal=9,type="EMA")

LS0tCnRpdGxlOiAiVGVjaG5pY2FsIGFuYWx5c2lzIGluIFIiCm91dHB1dDogaHRtbF9ub3RlYm9vawotLS0KCiMjIEludHJvZHVjdGlvbgoKQWx2aW4gVGFuIGNyZWF0ZWQgaW50ZXJlc3RpbmcgW05vdGVib29va10oaHR0cDovL3JwdWJzLmNvbS96aGVzaHVlbi82NjU2MTYpLCB3aGljaCBpcyBwYXJ0bHkgdXNlZCBpbiB0aGlzIHByZXNlbnRhdGlvbi4gVGhlIFtJbnZlc3RvcGVkaWFdKGh0dHBzOi8vd3d3LmludmVzdG9wZWRpYS5jb20vKSBpbmZvcm1hdGlvbiBzb3VyY2UgaXMgYWxzbyB1c2VkLiBJbiBhZGRpdGlvbiwgYSBCb29rZG93biBvZiBbVGVjaG5pY2FsIEFuYWx5c2lzIHdpdGggUiAoc2Vjb25kIGVkaXRpb24pIGZyb20gS28gQ2hpdSBZdV0oaHR0cHM6Ly9ib29rZG93bi5vcmcva29jaGl1eXUvdGVjaG5pY2FsLWFuYWx5c2lzLXdpdGgtci1zZWNvbmQtZWRpdGlvbjIvKSAgYW5kIENoYXRHUFQgd2VyZSBoZWxwZnVsIHdpdGggdGhlIGNvZGluZyBpbiBSLgoKVGVjaG5pY2FsIGFuYWx5c2lzIGlzIGEgbWV0aG9kIHRvIHByZWRpY3QgcHJpY2UgbW92ZW1lbnQgaW4gdGhlIGZpbmFuY2lhbCBtYXJrZXRzLiBVbmxpa2UgdGhlIHVzdWFsIGJhbGFuY2Ugc2hlZXQgYW5hbHlzaXMgKGZ1bmRhbWVudGFsIGludmVzdGluZyksIHRlY2huaWNhbCBhbmFseXNpcyBlc3RpbWF0ZXMgdGhlIHZhbHVlIG9mIGEgZ2l2ZW4gc3RvY2sgdXNpbmcgdW5kZXJseWluZyB0cmVuZHMgb2YgdGhlIHByaWNlIG1vdmVtZW50LiBUaGUgY29yZSBhc3N1bXB0aW9uIGJlaGluZCB0aGlzIG1ldGhvZCBpcyB0aGF0IHRoZSBmdW5kYW1lbnRhbHMgKGluZm9ybWF0aW9uIGZyb20gZmluYW5jaWFsIHN0YXRlbWVudHMpIHdlcmUgZmFjdG9yZWQgaW50byB0aGUgcHJpY2UgZmx1Y3R1YXRpb24sIGhlbmNlLCBkZXRlY3RpbmcgdGhlIHBhdHRlcm5zIGFuZCBzaWduYWxzIGZyb20gdGhlIGZsdWN0dWF0aW9uIHNob3VsZCBwcm92aWRlIHN1ZmZpY2llbnQgaW5kaWNhdG9yIGZvciBmdXR1cmUgcGVyZm9ybWFuY2UuCgpGb3IgdGhpcyBwcm9qZWN0LCB3ZSBhcmUgZ29pbmcgdG8gZXhwbG9yZSBzb21lIG9mIHRoZSBjb21tb24gdGVjaG5pY2FsIGluZGljYXRvcnMgdXNpbmcgdGhlIFRRUVEgRXhjaGFuZ2UgdHJhZGUgZnVuZCAoRVRGKSBzdG9jay4gQW1vbmcgbGV2ZXJhZ2VkIEVURnMsIFByb1NoYXJlcyBVbHRyYVBybyBRUVEgKFRRUVEpIGlzIG9uZSBvZiB0aGUgbGFyZ2VzdCB3aXRoIGFzc2V0cyB1bmRlciBtYW5hZ2VtZW50IG9mICRcJDE4LjU2JCBiaWxsaW9uIGFzIG9mIEp1bHkgMjAyMi4gVFFRUSBpcyBhbHNvIG9uZSBvZiB0aGUgbW9yZSBoZWF2aWx5IHRyYWRlZCBsZXZlcmFnZWQgRVRGcyBpbiB0aGUgVS5TLiB3aXRoIGFuIGF2ZXJhZ2UgZGFpbHkgdm9sdW1lIG9mICRcJDUuMjkkIGJpbGxpb24gKGNvbXBhcmVkIHdpdGggUVFRJ3MgJFwkMjEkIGJpbGxpb24pLgoKVFFRUSBjYXJyaWVzIGFuIFtleHBlbnNlIHJhdGlvXShodHRwczovL3d3dy5pbnZlc3RvcGVkaWEuY29tL3Rlcm1zL2UvZXhwZW5zZXJhdGlvLmFzcCkgb2YgMC45NSUuCgpgYGB7cn0KI2luc3RhbGwucGFja2FnZXMoInF1YW50bW9kIikKI2luc3RhbGwucGFja2FnZXMoImRhdGEudGFibGUiKQojaW5zdGFsbC5wYWNrYWdlcygiZ2dwbG90MiIpCiNpbnN0YWxsLnBhY2thZ2VzKCJ0aWR5cXVhbnQiKQpsaWJyYXJ5KHF1YW50bW9kKQpsaWJyYXJ5KGRhdGEudGFibGUpCmxpYnJhcnkoZ2dwbG90MikKYGBgCgojIyBEYXRhIEV4dHJhY3Rpb24gJiBNYW5pcHVsYXRpb24sIERhdGEgc3RydWN0dXJlCgpUUVFRIGRhdGEgaXMgZXh0cmFjdGVkIHVzaW5nIHRoZSBnZXRTeW1ib2xzIGZ1bmN0aW9uIGZyb20gWWFob28gRmluYW5jZS4gQWx0ZXJuYXRpdmVseSwgdGhlIHNvdXJjZSBjYW4gYmUgcmVwbGFjZWQgd2l0aCBGUkVELCBNeVNRTCwgR29vZ2xlLCBvciBvdGhlcnMuIFRoZSBkYXRhIGV4dHJhY3RlZCBzaG91bGQgYmUgaW4gYW4g4oCYeHRz4oCZIG9iamVjdCAtIGEgZm9ybWF0IGNvbW1vbmx5IHVzZWQgaW4gdGltZSBzZXJpZXMgYW5hbHlzaXMgd2hlcmUgb2JzZXJ2YXRpb25zIGFyZSByZWNvcmRlZCBpbiBhIG1hdHJpeCBzdHJ1Y3R1cmUgd2l0aCBhbiBpbmRleCBvZiBjb3JyZXNwb25kaW5nIHRpbWUuCgpUZWNobmljYWxseSwgYW5hbHlzaXMgY2FuIGJlIGRvbmUgaW4geHRzIGZvcm1hdCBhbG9uZSwgYnV0IGZvciB0aGUgc2FrZSBvZiBzaW1wbGljaXR5LCBkYXRhIGlzIGNvbnZlcnRlZCBpbnRvIGEgc3RhbmRhcmQgZGF0YWZyYW1lIGFuZCBpbmRleCBjb2x1bW4gaXMgcmVuYW1lZCBhcyAiRGF0ZeKAmS4gVGhlIGVuZCByZXN1bHQgaXMgc2hvd24gYXMgYmVsb3c6CgpgYGB7ciBkb3dubG9hZF9zdG9ja19oaXN0b3J5fQpnZXRTeW1ib2xzKCdOU0FOWScsc3JjID0gJ3lhaG9vJykgICAgICAgIyMgY2hhbmdlIFRRUVEgdGlja2VyIHRvIFlvdXIgdGlja2VyIHN5bWJvbApgYGAKCiMjIHN0cnVjdHVyZSBvZiB0aGUgKnN0b2NrKiBkYXRhCgpgYGB7cn0Kc3RvY2sgPDwtIGFzLmRhdGEudGFibGUoTlNBTlkpICAgICAgICAjIyMjIyMgY2hhbmdlIFRRUVEgdGlja2VyIHRvIFlvdXIgdGlja2VyIHN5bWJvbCAgIyMjIyMjIyMjCm5hbWVzKHN0b2NrKVsxXSA8LSBjKCdEYXRlJykKCnRhaWwoc3RvY2spCmBgYAoKCmBgYHtyfQojIGZlZWwgZnJlZSB0byBjaGFuZ2UgIkhMQ08iIHRvICJjYW5kbGVzdGljayIgb3IgdG8gc29tZSBvdGhlciB0eXBlcyAoImxpbmVzIiwgImF1dG8iKS4gCmNoYXJ0U2VyaWVzKHN0b2NrLCBzdWJzZXQ9JzIwMjAtMDEtMDE6OjIwMjAtMDktMjMnLCB0eXBlID0gImNhbmRsZXN0aWNrcyIsIGJhci50eXBlID0gIm9obGMiLHRoZW1lPWNoYXJ0VGhlbWUoJ3doaXRlJykpCmBgYAoKCmBgYHtyfQpjaGFydFNlcmllcyhzdG9jaywKICAgICAgICAgICAgc3Vic2V0PScyMDIwLTAxLTAxOjoyMDIwLTA5LTIzJywgdHlwZSA9ICJjYW5kbGVzdGljayIsCiAgICAgICAgICAgIHRoZW1lPWNoYXJ0VGhlbWUoJ3doaXRlJykpCmFkZFNNQShuID0gMTIsIG9uID0gMSwgd2l0aC5jb2wgPSBDbCwgb3ZlcmxheSA9IFRSVUUsIGNvbCA9ICJicm93biIpCmFkZFNNQShuID0gMjQsIG9uID0gMSwgd2l0aC5jb2wgPSBDbCwgb3ZlcmxheSA9IFRSVUUsIGNvbCA9ICJibHVlIikKCgpgYGAKVGhlIG1vdmluZyBhdmVyYWdlIHByb3ZpZGUgdXMgd2l0aCB2YXJpb3VzIGJ1eSBhbmQgc2VsbCBzaWduYWxzLiBXZSBjYW4gc2VlIHRoYXQgdGhlcmUgaXMgYSBzZWxsIHNpZ25hbCBmcm9tIEphbnVhcnkgMXN0IHVudGlsIEFwcmlsIDE1dGggd2hlcmUgd2UgY2FuIHNlZSBhIHNpZ25pZmljYW50IHNlbGwgc2lnbmFsLiBGcm9tIEFwcmlsIDE1dGggdGhlIHNob3J0IHRlcm0gYXZlcmFnZSBpbnRlcnNlY3RzIHRoZSBsb25nIHRlcm0gaW4gdGhlIHVwIGRpcmVjdGlvbiBzbyB3ZSBjYW4gc2VlIGEgc2lnbmlmaWNhbnQgYnV5IHNpZ25hbCB1bnRpbCBKdW5lIDIwdGguRnJvbSBKdW5lIDIwdGggdGhlIHNob3J0IHRlcm0gYXZlcmFnZSBpbnRlcnNlY3RzIHRoZSBsb25nIHRlcm0gaW4gdGhlIGRvd24gZGlyZWN0aW9uIHNvIHdlIGNhbiBzZWUgYSBzZWxsIHNpZ25hbCB1bnRpbCBKdWx5IDEzdGguIEFmdGVyIHRoYXQgd2UgY2FuIHNlZSBhIHNob3J0IGJ1eSBzaWduYWwgZnJvbSBKdWx5IDEzdGggdW50aWwgSnVseSAyMHRoLiBGcm9tIEp1bHkgMjB0aCB3ZSBjYW4gc2VlIGEgc2hvcnQgc2VsbCBzaWduYWwgdW50aWwgQXVndXN0IDd0aC4gRnJvbSBBdWd1c3QgN3RoIGJhc2VkIG9uIHRoZSBsb25nIGFuZCBzaG9ydCB0ZXJtIGF2ZXJhZ2Ugd2UgY2FuIHNlZSBhIGJ1eSBzaWduYWwgdW50aWwgQXVndXN0IDI3dGguIEFmdGVyIHRoYXQgd2UgY2FuIG9ubHkgc2VlIHRoYXQgdGhlIHByaWNlcyBhcmUgYmVsb3cgYXZlcmFnZSBzbyB0aGF0IHNob3dzIHVzIGEgc2VsbCBzaWduYWwuCgoKYGBge3J9CmNoYXJ0U2VyaWVzKHN0b2NrLAogICAgICAgICAgICBzdWJzZXQ9JzIwMjAtMDEtMDE6OjIwMjAtMDktMjMnLCB0eXBlID0gImJhcnMiLAogICAgICAgICAgICB0aGVtZT1jaGFydFRoZW1lKCd3aGl0ZScpKQphZGRNQUNEKGZhc3Q9MTIsc2xvdz0yNixzaWduYWw9OSx0eXBlPSJFTUEiKQoKYGBgClRoZSBtb3ZpbmcgYXZlcmFnZSBjb252ZXJnZW5jZSBkaXZlcmdlbmNlIHByb3ZpZGUgdXMgd2l0aCB2YXJpb3VzIGJ1eSBhbmQgc2VsbCBzaWduYWxzIGFuZCBzaG93cyB1cyB0aGUgbW9tZW50dW0gYW5kIHRyZW5kIGRpcmVjdGlvbnMuIEZyb20gdGhlIGJlZ2lubmluZyB3ZSBjYW4gc2VlIHRoYXQgdGhlIHNpZ25hbCBsaW5lIGlzIGFib3ZlIHRoZSBNQUNEIGxpbmUgTWFyY2ggMjV0aCB3aGljaCBtZWFucyB0aGF0IGl0IGlzIGEgYmVhcmlzaCBzaWduYWwgdGhhdCBzaG93IHVzIHRoYXQgdGhpcyBpcyBhIHNlbGwgc2lnbmFsLiBGcm9tIE1hcmNoIDI1dGggdGhlIE1BQ0QgbGluZSBpbnRlcnNlY3RzIHdpdGggdGhlIHNpZ25hbCBsaW5lIGluIHRoZSB1cCBkaXJlY3Rpb24gdW50aWwgSnVuZSAxM3RoIHNvIHRoYXQgc2hvdyB1cyBhIGJ1eSBzaWduYWwgYW5kIGl0IGlzIGNvbnNpZGVyZWQgYSBidWxsaXNoIHNpZ25hbC5Gcm9tIEp1bmUgMTN0aCB0aGUgTUFDRCBsaW5lIGludGVyc2VjdHMgd2l0aCB0aGUgc2lnbmFsIGxpbmUgaW4gdGhlIGRvd24gZGlyZWN0aW9uIHVudGlsIEF1Z3VzdCA4dGggd2hpY2ggbWVhbnMgdGhpcyBpcyBhIHNlbGwgc2lnbmFsLiBGcm9tIEF1Z3VzdCA4dGggdW50aWwgU2VwdGVtYmVyIDFzdCB0aGUgTUFDRCBsaW5lIGlzIGFib3ZlIHRoZSBzaWduYWwgbGluZSBzbyB0aGF0IGlzIGEgYnV5IHNpZ25hbC5Gcm9tIFNlcHRlcmJlciAxc3QgdW50aWwgdGhlIGVuZCB0aGUgTUFDRCBsaW5lIGlzIGJlbG93IHRoZSBzaWduYWwgbGluZSB3aGljaCBtZWFucyB0aGF0IGlzIGEgc2VsbCBzaWduYWwuCgpgYGB7cn0KY2hhcnRTZXJpZXMoc3RvY2ssCiAgICAgICAgICAgIHN1YnNldD0nMjAyMC0wMS0wMTo6MjAyMC0wOS0yMycsIHR5cGUgPSAiYmFycyIsCiAgICAgICAgICAgIHRoZW1lPWNoYXJ0VGhlbWUoJ3doaXRlJykpCmFkZEJCYW5kcyhuID0gMjAsIHNkID0gMiwgbWFUeXBlID0gIlNNQSIsIGRyYXcgPSAnYmFuZHMnLCBvbiA9IC0xKQpgYGAKCmBgYHtyfQpjaGFydFNlcmllcyhzdG9jaywKICAgICAgICAgICAgc3Vic2V0PScyMDIwLTAxLTAxOjoyMDIwLTA5LTIzJywgdHlwZSA9ICJiYXJzIiwKICAgICAgICAgICAgdGhlbWU9Y2hhcnRUaGVtZSgnd2hpdGUnKSkKYWRkUlNJKG4gPSAxNCwgbWFUeXBlID0gIkVNQSIsIHdpbGRlciA9IFRSVUUpCgpgYGAKCmBgYHtyfQpjaGFydFNlcmllcyhzdG9jaywKICAgICAgICAgICAgc3Vic2V0PScyMDIwLTAxLTAxOjoyMDIwLTA5LTIzJywgdHlwZSA9ICJiYXJzIiwKICAgICAgICAgICAgdGhlbWU9Y2hhcnRUaGVtZSgnd2hpdGUnKSkKYWRkU0FSKGFjY2VsID0gYygwLjAyLCAwLjIpLCBjb2wgPSAiYmx1ZSIpCgoKYGBgCgpgYGB7cn0KY2hhcnRTZXJpZXMoc3RvY2ssCiAgICAgICAgICAgIHN1YnNldD0nMjAyMC0wMS0wMTo6MjAyMC0wOS0yMycsIHR5cGUgPSAiYmFycyIsCiAgICAgICAgICAgIHRoZW1lPWNoYXJ0VGhlbWUoJ3doaXRlJykpCmFkZEJCYW5kcyhuPTIwLHNkPTIpCmFkZFJTSShuPTE0LG1hVHlwZT0iRU1BIikKYWRkTUFDRChmYXN0PTEyLHNsb3c9MjYsc2lnbmFsPTksdHlwZT0iRU1BIikKCmBgYAoKCg==