1.800.372.60781.800.372.6078
Menu

Adjusting for AAPL Split in TradeLog

Published: June 10, 2014
Tagged: Corporate Actions, TradeLog Tips

Apple (AAPL) stock underwent a 7 for 1 split effective June 9, 2014. Since so many TradeLog users trade AAPL, and options on it, we put together some instructions and tips to help you make the necessary adjustments in your trade history.

We strongly encourage users to make these adjustments now rather than later. If you wait till 2014 tax time it will likely be more challenging to do, and our support team will be much busier.

Prepare your TradeLog file for the adjustment:

Adjustments will need to be done in each individual account. If you have more than one account where you trade AAPL then select the first account tab and complete the steps below, then select the next account tab until finished with all accounts.

  1. For best results, import trade history up through Friday, June 6, 2014. This was the last day of trading before the split occurred. It is easiest to make the split adjustments before you continue importing trade history after this date.

    In TradeLog, click on the Open Trades button to view open positions.
  2. AAPL Split Step 1 screenshot
  3. The Open Trades view will display a summary list of all positions open as of the last transaction date in your file - see the image below. (Note: If you have already imported trade history past 6/6/2014, then change the Open as of field to 6/6/2014/)

    Notice any AAPL positions listed as these will need to be adjusted.

    Tip: You may want to Print the listing of open positions before proceeding with any adjustments - this will provide you with a starting-point reference.

    If you have any stock, double-click on the stock position, TradeLog will then display all of the trades related to that position. No stock positions? Click here to jump to the instructions for splitting options.
  4. AAPL Split Step 2 screenshot

Adjusting AAPL stock positions:

  1. Now that the TradeLog main grid displays the stock trades related to your open shares, scroll down and select the last trade in the series.
  2. AAPL Split Step 3 screenshot
  3. Now go to the Edit menu and choose the option Adjust for Stock Split.
  4. AAPL Split Step 4 screenshot
  5. The Adjust for Stock Split dialog box will prompt you to enter the details of the split:
      AAPL Split Step 5 screenshot
    • The selected ticker should be AAPL.
    • Make sure to enter 7 for 1 as the split ratio.
    • You may use the last trade date of 6/6/2014, or you can change the date to 6/8/2014 (the last calendar day before the split occurs).
    • Note: Do NOT use 6/9/2014 for the split date.

    Once you have confirmed the details, click OK.

    TradeLog will make the adjustment and prompt you to save your records.
  6. If you return to the Open Positions view (repeat step 1 above). You should now see that the number of shares open for AAPL stock has been adjusted and should be seven times the original amount.
  7. AAPL Split Step 6 screenshot

Adjusting AAPL option positions:

    If you have any option positions, double-click on the first position to adjust - TradeLog will then display all of the trades related to that position.

    AAPL Split Step 6 options screenshot
  1. Now that the TradeLog main grid displays the option trades related to your open shares, scroll down and select the last trade in the series.
  2. AAPL Split Step 7 screenshot
  3. Now go to the Edit menu and choose the option Adjust for Stock Split.
  4. AAPL Split Step 8 screenshot
  5. The Adjust for Stock Split dialog box will prompt you to enter the details of the split.
      AAPL Split Step 9 screenshot
    • The selected ticker should be the AAPL option you selected.
    • Make sure to enter 7 for 1 as the split ratio.
    • You may use the last trade date of 6/6/2014, or you can change the date to 6/8/2014 (the last calendar day before the split occurs).
    • Note: Do NOT use 6/9/2014 for the split date.

    Once you have confirmed the details, click OK.
  6. For options trades you will next be prompted if you want to “Change the pre-Split strike price?”, click Yes. This will divide the strike price by seven.
    AAPL Split Step 10 screenshot
    TradeLog will then prompt you to save the records.
  7. If you return to the Open Positions view (repeat step 1 above). You should now see that the number of contracts open for the AAPL option has been adjusted and should be seven times the original amount. You’ll also notice the strike price of the option has been adjusted.
    AAPL Split Step 11 screenshot
    If you have other options to adjust, double-click the next option and repeat steps 7 through 11 above.

A note about adjusted strike prices: brokers may vary in how they report the adjusted strike price of these options. Some may round to two decimals, some three. Therefore, it may be necessary for you to change the symbol later to match your particular broker. This can be done easily using the Change Ticker function, click here for instructions on this function.

Need help?

If you run into problems adjusting for this split, please submit a support request. In order to provide the best support we need to see your data file and the specific situation you have. The easiest way to send your file with your support request is directly from the software - click here for instructions on this method.

Apple (AAPL) stock underwent a 7 for 1 split effective June 9, 2014. Since so many TradeLog users trade AAPL, and options on it, we put together some instructions and tips to help you make the necessary adjustments in your trade history.

We strongly encourage users to make these adjustments now rather than later. If you wait till 2014 tax time it will likely be more challenging to do, and our support team will be much busier.

Prepare your TradeLog file for the adjustment:

Adjustments will need to be done in each individual account. If you have more than one account where you trade AAPL then select the first account tab and complete the steps below, then select the next account tab until finished with all accounts.

  1. For best results, import trade history up through Friday, June 6, 2014. This was the last day of trading before the split occurred. It is easiest to make the split adjustments before you continue importing trade history after this date.

    In TradeLog, click on the Open Trades button to view open positions.
  2. AAPL Split Step 1 screenshot
  3. The Open Trades view will display a summary list of all positions open as of the last transaction date in your file - see the image below. (Note: If you have already imported trade history past 6/6/2014, then change the Open as of field to 6/6/2014/)

    Notice any AAPL positions listed as these will need to be adjusted.

    Tip: You may want to Print the listing of open positions before proceeding with any adjustments - this will provide you with a starting-point reference.

    If you have any stock, double-click on the stock position, TradeLog will then display all of the trades related to that position. No stock positions? Click here to jump to the instructions for splitting options.
  4. AAPL Split Step 2 screenshot

Adjusting AAPL stock positions:

  1. Now that the TradeLog main grid displays the stock trades related to your open shares, scroll down and select the last trade in the series.
  2. AAPL Split Step 3 screenshot
  3. Now go to the Edit menu and choose the option Adjust for Stock Split.
  4. AAPL Split Step 4 screenshot
  5. The Adjust for Stock Split dialog box will prompt you to enter the details of the split:
      AAPL Split Step 5 screenshot
    • The selected ticker should be AAPL.
    • Make sure to enter 7 for 1 as the split ratio.
    • You may use the last trade date of 6/6/2014, or you can change the date to 6/8/2014 (the last calendar day before the split occurs).
    • Note: Do NOT use 6/9/2014 for the split date.

    Once you have confirmed the details, click OK.

    TradeLog will make the adjustment and prompt you to save your records.
  6. If you return to the Open Positions view (repeat step 1 above). You should now see that the number of shares open for AAPL stock has been adjusted and should be seven times the original amount.
  7. AAPL Split Step 6 screenshot

Adjusting AAPL option positions:

    If you have any option positions, double-click on the first position to adjust - TradeLog will then display all of the trades related to that position.

    AAPL Split Step 6 options screenshot
  1. Now that the TradeLog main grid displays the option trades related to your open shares, scroll down and select the last trade in the series.
  2. AAPL Split Step 7 screenshot
  3. Now go to the Edit menu and choose the option Adjust for Stock Split.
  4. AAPL Split Step 8 screenshot
  5. The Adjust for Stock Split dialog box will prompt you to enter the details of the split.
      AAPL Split Step 9 screenshot
    • The selected ticker should be the AAPL option you selected.
    • Make sure to enter 7 for 1 as the split ratio.
    • You may use the last trade date of 6/6/2014, or you can change the date to 6/8/2014 (the last calendar day before the split occurs).
    • Note: Do NOT use 6/9/2014 for the split date.

    Once you have confirmed the details, click OK.
  6. For options trades you will next be prompted if you want to “Change the pre-Split strike price?”, click Yes. This will divide the strike price by seven.
    AAPL Split Step 10 screenshot
    TradeLog will then prompt you to save the records.
  7. If you return to the Open Positions view (repeat step 1 above). You should now see that the number of contracts open for the AAPL option has been adjusted and should be seven times the original amount. You’ll also notice the strike price of the option has been adjusted.
    AAPL Split Step 11 screenshot
    If you have other options to adjust, double-click the next option and repeat steps 7 through 11 above.

A note about adjusted strike prices: brokers may vary in how they report the adjusted strike price of these options. Some may round to two decimals, some three. Therefore, it may be necessary for you to change the symbol later to match your particular broker. This can be done easily using the Change Ticker function, click here for instructions on this function.

Need help?

If you run into problems adjusting for this split, please submit a support request. In order to provide the best support we need to see your data file and the specific situation you have. The easiest way to send your file with your support request is directly from the software - click here for instructions on this method.

Please note: This information is provided only as a general guide and is not to be taken as official IRS instructions. Cogenta Computing, Inc. does not make investment recommendations nor provide financial, tax or legal advice. You are solely responsible for your investment and tax reporting decisions. Please consult your tax advisor or accountant to discuss your specific situation.