Page 3 of 3 FirstFirst 123
Results 25 to 36 of 36

Thread: Blueroadster's Account Talk

  1. #25

    Join Date
    Oct 2010
    Location
    Aiea, Hawaii
    Posts
    1,122

    Default Re: Blueroadster's Account Talk

    I just noticed the time lag from 10/2012 to today. Have you been away, or just don't post much to your own account talk (like me!)? Anyway, when you answer me , it will be your 100th post. So...premature congratulation!!
    There are 10 types of people in the world. Those who know binary, and those that don't!!
    Retired on December 31, 2018!!

  2.  
  3. #26

    Default Re: Blueroadster's Account Talk

    Wow...100th post...Thanks! I just don't post much even to my own account thread.

  4.  
  5. #27

    Default Re: Blueroadster's Account Talk

    Thanks for 100!
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.


  6.  
  7. #28

    Default Re: Blueroadster's Account Talk

    Here are links to many indicators generated from my Excel file incorporating today's closing values:

    AGG (F Fund equivalent)
    EFA (I Fund equivalent)
    ^GSPC (C Fund equivalent)

  8.  
  9. #29

    Default Re: Blueroadster's Account Talk

    Here are today's charts:

    ^GSPC
    AGG
    EFA

    Does anyone know of a site where one could view/download historical quotes for an S fund equivalent ticker symbol? Yahoo does not provide historical quotes for ^DWCPF or ^W4500? I need open, high, low, close, and volume data on a daily basis going back preferably to 02 June 2003.

  10.  
  11. #30

    Default Re: Blueroadster's Account Talk

    Here's one for those tracking NUGT

  12.  
  13. #31

    Default Re: Blueroadster's Account Talk

    Still holding a position in the I Fund. Here the updated file including various technical indicators for EFA. Many of these indicators are now positive which should be a relief for those holding for the last few months.

  14.  
  15. #32

    Default Re: Blueroadster's Account Talk

    Updated charts incorporating today's I Fund action. Also added a trigger line to the QStick indicator.

  16.  
  17. #33

    Default Re: Blueroadster's Account Talk

    Quote Originally Posted by blueroadster View Post
    As an update to my account thread, my Excel file has evolved quite a bit. It now includes a rolling stock price chart on the top that displays price changes from 02 June 2003 to date. A one year sliding window is also incorporated on the chart where I can rewind into the past or fast forward to the present. It is also used to prime/range bound all of the other technical overlay and indicator charts displayed. Current overlays include:

    1. Ichimoku Clouds
    2. Bollinger Bands
    3. EMA
    4. ENV
    5. SMA

    Current indicators include:

    1. ADL
    2. ADX
    3. Aroon
    4. Aroon Oscillator
    5. ATR
    6. %B
    7. BB Width
    8. CCI
    9. ChiOsc
    10. CMF
    11. COPP
    12. KST
    13. MACD
    14. MFI
    15. OBV
    16. PMO
    17. PPO
    18. PVO
    19. RoC
    20. RSI
    21. Special K
    22. STO (Fast)
    23. STO (Full)
    24. STO(Slow)
    25. StochRSI
    26. TRIX
    27. TSI
    28. ULT
    29. VTX
    30. Williams %R

    Any ticker symbol can be graphed so long as historical quote data is available to import. Once imported, technical overlay and indicator parameters can then be individually modified (input validation also enforced) and displayed on the fly. No macros were used in the Excel file and without imported historical quote data, the file size sitting at a paltry 1.23MB in size.
    Added the following technical indicators:

    1. NVI
    2. PVI
    3. QStick
    4. UI

    Here is the updated file incorporating today's closing values using EFA as the input ticker symbol. With 34 technical indicators, interpretation of the results and usefulness of what each offers can seem overwhelming due to too many gauges presently sitting on the dashboard. On the to-do-list is to better organize, rack and stack them.

  18.  
  19. #34

    Default Re: Blueroadster's Account Talk

    It's been a while since I updated my own account thread...

    I finally got off my lazy duff, removed my personal transactions and added some dummy transaction data so I could share my workbook with others. I spent a long time putting together all of the worksheets, formulas, etc. and made sure that everything is calculated properly without using named ranges, macros, etc. It's saved as an Excel binary file, does web queries for ticker price data, has almost 40 technical indicators where variables for each can be manipulated while graphics are updated on the fly, has a one year sliding window range for technical indicators and does not have a lot of fluff/overhead. The file itself is ~3MB so it is not that large however, if the share price data was extracted and referenced from a database, then the file size would be much smaller.

    Here is a link to a PDF showing the technical indicators worksheet that displays the action of EFA up to today's closing prices.

    Here is a link to download the TSP Tracker Excel binary file itself. For the worksheets, green tabs never need updating, yellow tabs require updating yearly and red tabs require updating whenever there is a change/update needed (e.g., new closing prices or transactions made). Let me know if you have any questions/suggestions.

  20.  
  21. #35

    Default Re: Blueroadster's Account Talk

    This is great! Thank you for the data file and worksheet!
    Don't take my comments as trading advice /IFT: 2-13-24=100G/https://www.theepochtimes.com/ & http://www.ewg.org/PermaCharts@p430#5159/strategy#4918p.410

  22.  
  23. #36

    Default Re: Blueroadster's Account Talk

    Not a problem...Happy to share. Let me know if you have any questions about the worksheets or formulas. I'd also be interested in suggestions. One thing I have not figured out is how to adjust the scaling on some of the charts to adjust automatically without the use of macros. When the align is set to auto, it seems to zoom too far out on the charts.


  24.  
Page 3 of 3 FirstFirst 123

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
  •  
S&P500 (C Fund) (delayed)
Blueroadster's Account Talk
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Blueroadster's Account Talk
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Blueroadster's Account Talk
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Blueroadster's Account Talk
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes