Page 3 of 91 FirstFirst 123451353 ... LastLast
Results 25 to 36 of 1092

Thread: userque & NUGT/DUST

  1. #25

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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]

  2.  
  3. #26

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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]

  4.  
  5. #27

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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 05:23 PM.
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]


  6.  
  7. #28

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    Quote Originally Posted by userque View Post
    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.
    NOTE FURTHER: That if this project lasts longer than I expect it to, I'll probably get around to fixing the above so that it behaves exactly like a real brokerage account.
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  8.  
  9. #29

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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 09:36 AM.
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  10.  
  11. #30

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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]

  12.  
  13. #31

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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]

  14.  
  15. #32

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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]

  16.  
  17. #33

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    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]

  18.  
  19. #34

    Join Date
    Sep 2006
    Location
    Rocky Mountain High
    Posts
    6,811

    Default Re: userque & NUGT/DUST

    Quote Originally Posted by userque View Post
    06-18-15 NUGT AT CLOSE

    SPREADSHEET UPDATE:

    06181508.png

    May begin posting a chart later.
    How does a 2.75% increase in DUST result in a decrease in balance?
    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. Expected retirement date: November 2023

  20.  
  21. #35

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: userque & NUGT/DUST

    Quote Originally Posted by weatherweenie View Post
    How does a 2.75% increase in DUST result in a decrease in balance?
    You lost me.
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  22.  
  23. #36

    Default Re: userque & NUGT/DUST

    Quote Originally Posted by weatherweenie View Post
    How does a 2.75% increase in DUST result in a decrease in balance?
    Are you reading the chart wrong ? Earliest trade is at bottom ; latest is at top ! That messed me up the first time I looked at it, too !


    Stoplight...
    "Too old to rock and roll...too young to die"... - I. Anderson


  24.  
Page 3 of 91 FirstFirst 123451353 ... LastLast

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
SPY (C Fund) (delayed)
userque & NUGT/DUST
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
userque & NUGT/DUST
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
userque & NUGT/DUST
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
userque & NUGT/DUST
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes