ITA Wealth Management

  • Home
  • Blog
    • How To Use ITA Blog
    • Golden Rule of Investing
    • Basic Investing Principles
  • Guest Registration
  • Forum
  • Reset Password
  • About Me
    • Archive
    • Contact
You are here: Home / Forum

Forum

  • Forums
  • Members
  • Recent Posts
Forums
ITA Forums
Kipling Spreadsheet...
Kipling Spreadsheet
 
Notifications
Clear all

[Sticky] Kipling Spreadsheet

 
Kipling Spreadsheet Discussions
Last Post by Albert Mak 6 years ago
9 Posts
2 Users
0 Reactions
2,536 Views
Unsticky
RSS
Forum 1
 Lowell Herr
(@lowell)
Noble Member Admin Registered
Joined: 12 years ago
Posts: 652
Topic starter December 18, 2018 8:33 PM  

New Platinum members looking for the Kipling spreadsheet should check out this blog post.

https://itawealth.com/updating-ita-add-file-running-lrpc-kipling-v1-1-workbook/

Be sure to install the ITA Add-In for your Excel spreadsheet.

When the latest version of the Kipling is released, instillation instruction will be available.

Lowell

 


   
Quote
Topic Tags
Kipling Spreadsheet
Forum 2
 Albert Mak
(@a-mak)
Active Member
Joined: 12 years ago
Posts: 8
March 14, 2019 6:20 PM  

Question on Kipling 3.4 workbook regarding the Manual Risk Adjustments sheet.  Why is the position% column under "new holdings" so different from the suggested allocation from auto? Totally different ETFs are recommended. I am baffled.

Using today's date 3/14/2019:

Ticker Current Price Suggested Allocation Recommended Shares from Auto Shares to HOLD Ticker Shares Required Position Value Position %
                 
Cash 1   2391.641   Cash   22305.5 22%
SHY 83.75 0% 0 250 SHY 250 20937.5 20%
                 
VTI 144.46   0   VTI -100    
VEA 40.92   0   VEA 0    
VWO 42.22 25% 610.85977   VWO 0    
VNQ 85.9 25% 272.39649   VNQ -100    
RWX 38.87 25% 663.50658   RWX 0    
DBC 15.99   0   DBC 0    
GLD 123.84   0 250 GLD 150 30960 30%
PCY 27.67 25% 932.07445   PCY -100    
TLT 121.83   0 100 TLT 0 12183 12%
AGG 107.59   0   AGG 0    
SH 27.96   0 600 SH 500 16776 16%

Here is the spreadsheet  (looks like I cannot attach the file) https://www.dropbox.com/s/i8avyn6h07xmrdf/Kipling%203.4-Orig.xlsx?dl=0

Any help will be really appreciated!

-Albert

This post was modified 6 years ago by Albert Mak

   
ReplyQuote
Forum 1
 Lowell Herr
(@lowell)
Noble Member Admin Registered
Joined: 12 years ago
Posts: 652
Topic starter March 15, 2019 6:03 AM  

Albert,

This may take a bit to sort out.  When working in the Position Sizing (Manual) worksheet, I assume you first set a percentage risk for the portfolio in the Position Sizing (Auto) worksheet.  Once that is accomplished, the recommended shares are transferred over to the Position Sizing (Manual) worksheet.  At that point you will set the number of shares you want to invest in the portfolio, using the recommendations as a guideline.

Lowell

 

 

This post was modified 6 years ago by Lowell Herr

   
ReplyQuote
Forum 1
 Lowell Herr
(@lowell)
Noble Member Admin Registered
Joined: 12 years ago
Posts: 652
Topic starter March 15, 2019 8:27 AM  

Albert,

If you need more help, let me know as I don't think I fully answered your question.  Perhaps HedgeHunter will fill in some gaps.

Lowell

 


   
ReplyQuote
Forum 1
 Lowell Herr
(@lowell)
Noble Member Admin Registered
Joined: 12 years ago
Posts: 652
Topic starter March 15, 2019 9:28 AM  

Albert,

I'm perplexed by the very high percentages you show in the right-hand column.  Is your spreadsheet corrupted?

In the Position % column, those percentages are based on the manual number of shares the portfolio manager selects as the number of shares to invest (Column titled Shares to HOLD).

Lowell


   
ReplyQuote
Forum 2
 Albert Mak
(@a-mak)
Active Member
Joined: 12 years ago
Posts: 8
March 15, 2019 4:23 PM  

Lowell,

I think there is something wrong with the inserted table. It is missing cell border. It should read:

Position Value Position %
22305.5 22%
20937.5 20%

Is the Shares to HOLD column, allowing us to override the etf we want to do long term hold? 

-Albert 

This post was modified 6 years ago by Albert Mak

   
ReplyQuote
Forum 1
 Lowell Herr
(@lowell)
Noble Member Admin Registered
Joined: 12 years ago
Posts: 652
Topic starter March 17, 2019 10:35 AM  

Albert,

I need more direction.  Are you working in the Position Sizing (Manual)?

Only make changes in the salmon colored cells.  The Position Value and Position % will automatically adjust when you make changes in the Shares to HOLD column.

Lowell


   
ReplyQuote
Forum 1
 Lowell Herr
(@lowell)
Noble Member Admin Registered
Joined: 12 years ago
Posts: 652
Topic starter March 17, 2019 10:44 AM  

Albert,

Do you have an "original" copy of the Kipling SS?  If so, go back to that copy, rename it and then enter your securities and the shares you hold in each.  Don't forget to enter the correct Cash value in the Portfolio worksheet.

Lowell


   
ReplyQuote
Forum 2
 Albert Mak
(@a-mak)
Active Member
Joined: 12 years ago
Posts: 8
April 2, 2019 6:27 PM  

Lowell,

Thanks for you help. I was just wasn't thinking about it correctly. I had left over values that I should overwrite.

-Albert


   
ReplyQuote

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Save Draft Saved
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Kipling Workbook Overview
    5 years ago
  • Kipling Spreadsheet
    5 years ago
  • Kipling Spreadsheet: Looking Forward to New Version Release
    7 years ago
Topic Tags:  Kipling Spreadsheet (4) ,

Search Blog

Recent Posts

  • Copernicus Portfolio Review: 3 July 2025
  • Millikan Portfolio Review: 1 July 2025
  • Schrodinger Portfolio Review: 20 June 2025
  • Carson Sector BPI Portfolio Review: 18 June 2025
  • Franklin Sector BPI Portfolio Review: 12 June 2025
Share:
Forum Information
Recent Posts
Unread Posts
Tags
  • 17 Forums
  • 562 Topics
  • 726 Posts
  • 2 Online
  • 278 Members
Our newest member: Adam Imiolek
Latest Post: Real Estate Overbought (6/6/2025)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo  Powered by wpForo version 2.4.6

(Visited 30,143 times, 2 visits today)

Share this:

  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • More
  • Click to share on Bluesky (Opens in new window) Bluesky

Like this:

Like Loading...

Meta Data

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Search

Recent Posts

  • Copernicus Portfolio Review: 3 July 2025 July 5, 2025
  • Millikan Portfolio Review: 1 July 2025 July 1, 2025
  • Schrodinger Portfolio Review: 20 June 2025 June 21, 2025
  • Carson Sector BPI Portfolio Review: 18 June 2025 June 19, 2025
  • Franklin Sector BPI Portfolio Review: 12 June 2025 June 12, 2025
  • Schrodinger Portfolio Review: 5 June 2025 June 6, 2025
  • Franklin Sector BPI Portfolio Review: 4 June 2025 June 5, 2025

Recent Comments

  • Lowell Herr on Bullish Percent Indicators: 2 May 2025
  • Lowell Herr on Millikan Portfolio Review: 1 July 2025
  • Lowell Herr on Bullish Percent Indicators: 2 May 2025
  • Lowell Herr on Carson Sector BPI Portfolio Review: 18 June 2025
  • Lowell Herr on Schrodinger Portfolio Review: 20 June 2025
  • Lowell Herr on Bullish Percent Indicator: 30 May 2025
  • Lee Cash on Closed End Funds (CEFs): 19 May 2025
  • Lee Cash on Selecting Closed End Funds (CEFs)
  • hedgehunter on Selecting Closed End Funds (CEFs)
  • Lowell Herr on Selecting Closed End Funds (CEFs)

Popular Posts

  • Schrodinger Portfolio Review: 11 April 2025
  • Closed End Funds (CEFs): 19 May 2025
  • Buffett Indicator & Shiller PE Ratio
  • What Should I Do If I Sell My House or Come Into An…
  • Selecting Closed End Funds (CEFs)
  • Bullish Percent Indicators: 11 April 2025
  • Bullish Percent Indicators: 17 April 2025
  • Bullish Percent Indicators: 4 April 2025
  • Bullish Percent Indicators: 2 May 2025
  • Franklin Portfolio Update: 8 April 2025

General Investment News

Portfolios coming up for review.  Bethe, Millikan, McClintock, Copernicus, and Pauling are the critical portfolios next up for review.  Non-scheduled portfolios may be reviewed.  If you are a new user, check the posts you missed. Links to Random Posts are found in the lower right-hand footer or just to the right of what you are now reading.  Most popular posts are found in the lower left-hand footer.

Check the Forum for more detailed information.  If you wish to begin a financial discussion, use the Forum.

This blog is free to all who signup as a Guest.

Random Posts

  • Bullish Percent Indicator Data: 6 October 2023
  • The Golden Rule of Investing
  • Gordon Equation Revisited: A Time To Be Cautious
  • Where To Begin If You Have Never Managed a Portfolio*
  • The True Cost of Management Fees
  • Hawking Portfolio Review: 2 June 2023
  • Back Testing Issues: Remain Skeptical of Results
  • Rutherford Portfolio Review (Tranche 4): 1 March 2024
  • Sector BPI Investing: Bohr Portfolio Review – 22 November 2023
  • Rutherford Portfolio Review (Tranche 3): 1 November 2024
  • Rutherford Portfolio Review (Tranche 3): 22 March 2024

Log in | Website Design by BOING

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.
      %d