Excel Sheet Form For Other Sheet Sample: Fill & Download for Free

I am not sure if this question was asked in the right spirit (sincere or not) and I normally don’t answer questions of people who are giving investment advice themselves. You seem to give investment advice to others, so obviously your competency might be even higher than mine.However, assuming that this reply will be useful for an average investor/layman, I am answering it.The first thing you have done by writing this query is acknowledging that the mistake did happen.Second thing, welcome to the group. I am very sure that there is no soul who has ever invested in some asset class and not made a mistake and lost/regretted it. Even the great Warren Buffett in many interviews said about his regrets for making 15 investing mistakes. You can read it here: Warren Buffett’s failures: 15 investing mistakes he regretsSome people say marriage was the biggest mistake of their life and many are saying LTCG tax is a mistake. So, everyone makes their own mistakes. But accepting the mistake and rectifying it, is the most challenging part.Now, coming back to the query at hand. if you are 100% sure that the stocks that you have purchased are a mistake, then you need to man-up, sell those stocks and get back atleast some part of the capital. This can help you stave of the losses and restrict them to a portion.Incase you are not 100% sure if the stocks that you purchased are wrong, thenList out all the stocks and their sectors on an excel sheet, Do include their 52 wk highs and lows for clarity on the difference from the current stock price.Analyze and understand if the sectors are in favor currently, meaning, are the sectors/stocks getting support from govt. policies, do they have good growth prospects, are the EPS, P.E. debt and other financial parameters favorable.If the answer to point 2 is YES, then you are unnecessarily worrying and you probably need to wait out the current storm. Maybe, you can add another 25% - 50% more quantity to all those stocks. Prepare a table, with all the necessary information and play around with additional quantities to see what best suits you and then start adding a portion of that quantity over a period. (I will illustrate a sample below).If the answer to the point 2 is NO, then you need to accept the loss, sell them and regroup your thoughts and pick out stocks for the future.How to do point 2 (quick look):The results of the companies are being currently announced. So, check the 9 month EPS and compare it with previous year’s 9 month EPS. If the EPS growth is > 15% (or your expected returns), then your stock is fine on the financial part.You cannot calculate a price target at this point in time, as the market is going through serious volatility and hence, any attempts to calculate price targets would be futile.But, if you have a longer outlook, like Dec 2018, then take the full year EPS of calendar year 2017 (EPS of Q4 2016+current 9 month EPS), increase it by 15%, then multiply it by the Current P.E. This price would be the rough base price target for your stock by Dec 2018.Incase, you find that the price target above is reasonable and the indicated returns are acceptable, then proceed to the next step.How to do point 3 (full portfolio):If you are planning to build this excel sheet, it means that you have completed the above analysis and you are ready to invest further in those same companies. I am indicating a sample excel sheet which can help you get a broad picture of your portfolio.The additional quantity which is indicated by ‘B’ can be split into 4 parts andThe first part can be invested immediately, as the price correction from your earlier invested price might already be a lot. So, this will help you get your invested price averaged a little bit.The second part can be invested, when that particular stock goes up or down by 25% of your earlier loss. Let’s say your total loss earlier was 16%, so when the stock shifts by 4% (either positive or negative, invest this second part).Repeat the third part of investment in the above manner.Invest the fourth part at the end of Mar quarter or before each stock’s Q4 results (whichever suits you, based on your capital availability).Another option:In case you feel that the current market price is much lower than your invested price and you don’t think that the stock can lose much from here, then invest the full ‘additional quantity’ immediately. There is nothing wrong in it and if you have a longer outlook, it might work in your favor.I did the same when I Recasted The Portfolio on The List. You can see this post. Portfolio Building & Management !To err is human, so no one will judge you. So don’t be hard on yourself. After all, it is money, which can be earned at any point in time. Don’t lose your peace of mind over it.To other readers, who are stock brokers, investment advisers, whatsapp/twitter/email group managers, request you to kindly not send me insincere requests as I am writing on Quora only for the purpose of layman/newbies/ people without sufficient understanding of investments.Illustrations credits: Author’s own ability in usage of MS Excel.

There is ONE BIG lesson from UPSC prelims 2019…CHANGE THE WAY YOU STUDY FOR Prelims.After seeing 2018 and 2019 prelims papers, I do not think aspirants should study SUBJECT wise, i.e., History, Geography, International Affairs, Economics, Environment, Current Affairs etc. Most of the coaching institutes and teachers etc. create their study programs, notes/study material etc. subject wise and guide students to take up each subject and study. This is an OUTDATED technique to plan and study for the exam.In my view, it is pointless to do an analysis on the basis of xyz number of questions from History, Economic etc. provided on various websites. It only gives you an overall statistical analysis of how many questions came from where, so how does it help an aspirant?Therefore, in my view, this is how students should study for UPSC prelims now:Create sub-topics on the basis of past three year papers, i.e, 2017, 18, and 19.By ‘sub-topics’ I mean, further breakdown major topics into smaller sub-topics on the basis of question types into various categories such as:Polity: (1) Commissions (such as Sarkaria, CACP, Tendulkar etc.) (2) Rules notified by GoI (3) Articles (4) Schedules (5) Judgments by Supreme Court (6) Amendments;Environment: (1) Conventions (such as IPCC etc.) (2) Climate Funds (3) Wildlife — flora and fauna (4) Lakes — man made, and natural, brackish vs fresh (5) Declarations (6) National Parks etc. and so onCurrent Affairs: (1) World Reports (2) Schemes (3) Missions (4) World Conferences (5) Technological developments;Space: (1) Space Missions (2) Space Discoveries;Biology: (1) Microbials (2) DNA/RNA technologies (3) Genetic technologies (4) Techniques on fertilisation etc.Reports: (1) World reports such as World Development Report — which institution etc.? (2) Major report summaries (will help in Mains) — see a sample note below…and so on for other subjectsHow to create such sub-topics:Read the old papers and create them. Use common sense as well as do some work 3–4 days and it will be done. Write these sub-topics in an excel sheet or evernote or even physical paper notes, and then start categorising your notes under each sub-topic. Use google search, news paper and also books etc. to add various items to these sub-topics. Keep the nature of notes as short as possible and don’t write random details.Be good at filing system if these notes. Keep them very organized.This is a simple advice from me. I will make a video on how to do this soon. Hopefully it will help you to redo your studying technique and make it more effective.Here are some sample outlines and notes on how you can make them:Sample note of Reports:The point is, how to study more effectively. If you are able to create an exhaustive list of sub-topics (and study accordingly) and cover the traditional books, it will organise you studies in a much better way. If you study the question papers every year (for the past 7–8 years), sub-topics are pretty much the same.

I’d like you to think ahead a little bit. We too were a start-up once. We used many best-in-class tools - todo list software, bug tracking software, time-sheet software (for external consultants), forum software and in addition we maintained excel sheets for which there was no out-of-the-box software. And still many things slipped through the cracks. Plus there was no integration. That’s when it struck me that in addition to developing a great PM software, it would be more useful to develop an integrated all-in-one system that would make life easier for companies.In addition to providing great PM tools, including a beautiful interactive gantt that scales effortlessly to thousands of tasks, Celoxis can track your bugs, time sheets, expenses, issues, resources, documents, discussions and any other business processes unique to your company through our unique “Custom Apps” feature.Here is a sample screenshot of our gantt chart: