終了

Backtest a stock market trading strategy using Google Spreadsheets

このプロジェクトは、フリーランサーの方々から17件の入札を受けています。平均入札額は$313 USDです。

このようなプロジェクトの無料見積もりを取得
作業中の採用者
プロジェクト予算
$10 - $30 USD
入札合計
17
プロジェクト情報

I need someone to backtest the following trading strategy in google drive spreadsheets (which is free to use, basically cloud excel with a few less functions.) This will take some stock market knowledge, and sorting/inputting a lot of data (though I'm sure a decent amount can be copy/pasted.)

Strategy: Short Term Reversal

Core strategy:

If a stock has relatively low (high) returns over the past month or week, it can earn positive (negative) abnormal returns in the following month or week

Approach 1:

Standard reversal strategy using the 500 and 100 largest cap U.S. stocks. More specifically, a reversal investment strategy that is long in the 20 percent stocks with the lowest one-week returns and short in the 20 percent with the highest returns

Approach 2:

A slightly more sophisticated approach (in addition to approach 1) that waits to sell (buy back) stocks until they are ranked among the 50 percent of winner (loser) stocks ranked on past return. These stocks are then replaced by the stocks with the lowest (highest) past-week return at that time and not yet included in the portfolio.

Your job: For EACH approach determine the basis points profit or loss per week overall and for each individual stock that would be traded in each approach. Show the entry and exit points for each qualifying stock based on the stock's open or closing prices.

Also backtest approach 1 and 2's weekly profits for the last year. Add/change any tweaks to the strategy. This will require the freelancer to find a site with data for the weekly returns of the stocks. Yahoo finance has opening/closing data, but if you find something better that's fine as well.

お金を稼ぎたいと思っていますか?

  • 予算と期限を設定してください
  • 提案のアウトラインを作成してください
  • 仕事の報酬を受け取りましょう

このプロジェクトにも入札したフリーランサーを採用する

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online