Excel & R For Trading

Use R and/or Spreadsheets to create algorithms for trading. Ready to use templates and codes are available for downloads. Various quantitative strategies are shared as examples.

Top Picks

Value at Risk (VaR) Calculation in Excel and Python

Value at Risk or VaR is an essential term for a trader as a part of risk management. There are several uses of VaR and different approaches of calculating VaR which you will find with this interesting blog....
6 min read

How to Check Data Quality Using R

Learn backtesting trading strategies in excel and learn to backtest the Long-Short Moving Average Crossover Strategy (MACD) in simple steps....
3 min read

Backtesting Long Short Moving Average Crossover Strategy in Excel

Learn how to build the “Hello World” of trading strategies: the “Long Short Moving Average Crossover Strategy”....
7 min read

Quantitative Trading Strategy Using Quantstrat Package In R: A Step By Step Guide

In this post we will discuss about building a trading strategy using R. There are more than 4000 add on packages,18000 plus members of LinkedIn’s group and close to 80 R Meetup groups currently in existence....
5 min read

Excel & R For Trading

Value at Risk (VaR) Calculation in Excel and Python

Value at Risk or VaR is an essential term for a trader as a part of risk management. There are several uses of VaR and different approaches of calculating VaR which you will find with this interesting blog....
6 min read

R Weekly Bulletin Vol – XIV

This R weekly bulletin by QuantInsti® covers interesting ways in R and functions like path.package, fill.na, and the rank function....
4 min read

R Weekly Bulletin Vol – XIII

This R weekly bulletin by QuantInsti covers interesting plotting ideas and functions like sapply, vapply rollMean, and group_by....
6 min read

R Weekly Bulletin Vol – XII

This R weekly bulletin by QuantInsti covers interesting problem-solving ideas and functions like do.call, rename, and lapply....
4 min read

R Weekly Bulletin Vol – XI

This R weekly bulletin by QuantInsti® covers interesting problem-solving ideas and functions like rank, mutate, transmute, and set.seed....
4 min read

R Weekly Bulletin Vol – X

This R weekly bulletin by QuantInsti® covers interesting problem-solving ideas and functions like choose, sample, runif and rnorm....
4 min read

R Weekly Bulletin Vol – IX

This R weekly bulletin by QuantInsti® covers interesting problem-solving ideas and functions like filter function, select function, and arrange function....
5 min read

R Weekly Bulletin Vol – VIII

This R weekly bulletin by QuantInsti® covers interesting problem-solving ideas and functions like download.file, file.copy, file.rename, and file.remove....
5 min read

R Weekly Bulletin Vol – VII

This R weekly bulletin by QuantInsti® covers interesting problem-solving ideas & functions like the identical function, all.equal, any and all functions....
4 min read

R Weekly Bulletin Vol – VI

This R weekly bulletin by QuantInsti® covers interesting problem-solving ideas & functions like %within%, %m+%, to.period, period.max, period.min functions....
5 min read