CORRECTED AND UPDATED SPREADSHEET:
06161515.png
Found another SNAFU with the spreadsheet.
Where the trades were SHORT, the spreadsheet reversed the % return. (...Since I actually don't go SHORT but instead LONG an inverse ETF...)
I will post a corrected and updated spreadsheet shortly.
EDIT: To be clearer, going forward, I'm using NUGT/DUST instead of LONG/SHORT
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
CORRECTED AND UPDATED SPREADSHEET:
06161515.png
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
Tomorrow, I may add a "Balance" column to the spreadsheet to simulate the trades against a $10,000? initial balance account at $10/trade.
NOTE: The simulation will always be fully invested. In real life, you can't buy half of a share of NUGT, for example. You would be stuck with an uninvested $4.50 in your account. This simulation, in order to Keep It Simple, will behave as though it invested that extra $4.50. So instead of buying 1000 or so shares, it would simulate buying 1000.5 shares.
I also may add metrics like an Annualized Return, etc. later:
How to Annualize a Rate of Return
EDIT:
I enter prices based upon Yahoo or Google soon after the close. Closing prices can change slightly after the closing bell. To me, the variance is no big deal and may actually simulate real world trade fill variations. Even so, I may make corrections if you post here that a closing/opening spreadsheet entry doesn't match the settled closing/opening price quote.
Last edited by userque; 06-16-2015 at 04:23 PM.
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
Upgraded Spreadsheet with Balance, Annualized Return, etc. Slapped it together rather quickly; let me know if you find a glitch, etc.:
06171508.png
Annualized ROR is calculated using calendar days and a 365 day year.
EDIT: I believe I have to add "+1" to the calendar-days formula. This will slightly decrease the annualized return. This change will be reflected in the next spreadsheet posting.
Last edited by userque; 06-17-2015 at 08:36 AM.
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
06-17-15 NO CHANGE AT CLOSE
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
Discovered minor glitch.
Now, the spreadsheet deducts $10 per trade; however, each transition from NUGT to DUST and vice versa requires two trades (one to exit, one to enter)...will correct for next spreadsheet posting.
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
06-18-15 DUST AT OPEN
(Exit NUGT at OPEN as well, of course.)
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
06-18-15 NUGT AT CLOSE
SPREADSHEET UPDATE:
06181508.png
May begin posting a chart later.
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
Weatherweenie's Account Talk
Teddy Roosevelt: Patriotism means to stand by the country. It does not mean to stand by the president or any other public official. Retired on November 30, 2023 with 30+ years of service.
S&P500 (C Fund) (delayed) (Stockcharts.com Real-time) |
DWCPF (S Fund) (delayed) (Stockcharts.com Real-time) |
EFA (I Fund) (delayed) (Stockcharts.com Real-time) |
BND (F Fund) (delayed) (Stockcharts.com Real-time) |
||
Yahoo Finance Realtime TSP Fund Tracking Index Quotes |
Bookmarks