Page 2 of 6 FirstFirst 1234 ... LastLast
Results 13 to 24 of 66

Thread: ETF for dummies

  1. #13

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default re: ETF for dummies

    Quote Originally Posted by Maricar19 View Post
    Userque, can you help me with a simple excel formula? How do I put an "if formula on my worksheet (column G) without putting 1 on either Buy and Sell columns?
    See, if I multiply Buy (D) column with shareprice (F) , I get a zero because sell (E) column is blank. So I end up putting a (1).
    The same goes with sell (E) column *shareprice (F), because Buy (D) column is blank.
    I drag down the formula on G column.

    Gain/Loss
    Buy Sell $240.22
    6-Jun SPXU 18 1 26.45 $ 476.10
    7-Jun SPXU 1 18 26.12 $ 470.16 ($5.94)









    You can try, if (sell=""), multiply using the buy column, multiply using the sell column

    The second phrase after the comma is executed if the IF condition is false.

    You can email the file also if you prefer; or I can try a more detail explanation.

    You'll probably need to adjust the other columns as well, but I'd probably need to see the whole sheet to be sure.

  2.  
  3. #14

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default re: ETF for dummies

    Maricar19, You've got mail.

  4.  
  5. #15

    Default re: ETF for dummies

    Quote Originally Posted by userque View Post
    You can try, if (sell=""), multiply using the buy column, multiply using the sell column

    The second phrase after the comma is executed if the IF condition is false.

    You can email the file also if you prefer; or I can try a more detail explanation.

    You'll probably need to adjust the other columns as well, but I'd probably need to see the whole sheet to be sure.
    Thank you so much UserQ for the assist.
    Emotions should never play a role in one's investing strategy!
    No to Greed...No to Fear!
    http://share.robinhood.com/mariloc1

  6.  
  7. #16

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default re: ETF for dummies

    Quote Originally Posted by Maricar19 View Post
    Thank you so much UserQ for the assist.
    Glad to help.

  8.  
  9. #17

    Default Re: ETF for dummies

    Hi TSPers: Is there a group in TSPTalk who trades ETFs more than 2x a month? I am interested in how you recognize the indicators? Is there a subscription fee?
    Or anybody doing it outside of TSPTALK? and what is your success rate and how much does it cost you?
    Emotions should never play a role in one's investing strategy!
    No to Greed...No to Fear!
    http://share.robinhood.com/mariloc1

  10.  
  11. #18

    Default Re: ETF for dummies

    I am trying to have a grasp of the stock market, the ETFs, the charts, etc.
    I have retired, so other than understanding estate planning, tax efficiency, etc. I might as well add these topics to my list of to do.


    I know I said I would love to travel, but travel begets money.
    I went to Cancun in May, then to Florida with my grandson in June, then to Canada and multiple day trips to NJ, NYC and VA.
    It has only been 2 months since I retired and my travel budget is already negative. I had to dip into entertainment budget.
    Any way this blah blah is for another thread.

    So internet find for a start is:Candlestick Flashcard
    http://www.tradesmartu.com/external/...c1cb4e58c2361c
    Emotions should never play a role in one's investing strategy!
    No to Greed...No to Fear!
    http://share.robinhood.com/mariloc1


  12.  
  13. #19

    Default Re: ETF for dummies

    You budget is like most persons this first half of calendar year. It is bad for most savings. So far am looking at 5.5% gain. Many have had much higher losses if they left there funds in any account continuous. Maybe the rest of the year you will be lucky. Look at the PREMIUM services to see if they will fit into your investment toolkit.


    Sent from my iPhone using Tapatalk

  14.  
  15. #20

    Join Date
    Oct 2015
    Location
    Warm and sunny AZ
    Posts
    103

    Default Re: ETF for dummies

    Quote Originally Posted by Maricar19 View Post
    Hi TSPers: Is there a group in TSPTalk who trades ETFs more than 2x a month? I am interested in how you recognize the indicators? Is there a subscription fee?
    Or anybody doing it outside of TSPTALK? and what is your success rate and how much does it cost you?
    You can go here https://collective2.com/, pick a strategy, pay the fee and start trading immediately. You can also set up auto-trade which means anytime the developer makes a trade your brokerage account mirrors it. Very useful for FOREX, OPTIONS, FUTURES and VIX which may be traded multiple times a day

  16.  
  17. #21

    Default Re: ETF for dummies

    Quote Originally Posted by blackoutcl View Post
    You can go here https://collective2.com/, pick a strategy, pay the fee and start trading immediately. You can also set up auto-trade which means anytime the developer makes a trade your brokerage account mirrors it. Very useful for FOREX, OPTIONS, FUTURES and VIX which may be traded multiple times a day

    FYI...Both Userque and I-T have subscription services available there...perhaps others that also frequent this Board ?


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

  18.  
  19. #22

    Default Re: ETF for dummies

    Can somebody kindly explain how a "stop loss"works?
    i bought share at $30.95 each. I put a stopl loss sale order for $33. in a matter of seconds after putting the order, my shares git sold at $30.86. What happened?
    Emotions should never play a role in one's investing strategy!
    No to Greed...No to Fear!
    http://share.robinhood.com/mariloc1

  20.  
  21. #23

    Default Re: ETF for dummies

    You wanted to put in a limit order.

    A stop is for losses. If you bought at 30.95 and wanted to sell if it fell below $30 you'd put a stop loss order of $29.95 or something close.

    It you want to take profits if it hits $33, you put in a limit order to sell.

    You told it to sell if it goes below $33 so it was hit right away.
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor. Do your own due diligence.

  22.  
  23. #24

    Join Date
    Dec 2009
    Location
    On a Florida beach
    Posts
    1,305

    Default Re: ETF for dummies

    You set your price on the wrong side of the current price. A stop loss means just that, when the price falls to a certain point you'd want to sell in order to prevent losing more money as it continues to fall. So you would want to set your stop loss price below $30.95, and not too close to that price since small daily fluctuations could trigger the sale.

  24.  
Page 2 of 6 FirstFirst 1234 ... LastLast

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)
ETF for dummies
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
ETF for dummies
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
ETF for dummies
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
ETF for dummies
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes