# Excel & R For Trading

## 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....

#### 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....

#### 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”....

#### 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....

### 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....

#### 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....

#### R Weekly Bulletin Vol – XIII

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

#### R Weekly Bulletin Vol – XII

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

#### 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....

#### R Weekly Bulletin Vol – X

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

#### 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....

#### 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....