Showing posts with label Excel Trading System. Show all posts
Showing posts with label Excel Trading System. Show all posts

Saturday, January 6, 2018

Money Management Using The Kelly Criterion !!!

The Kelly criterion is a formula used to determine the optimal size of a series of bets in order to maximise the logarithm of wealth. In recent years, Kelly has become a part of mainstream investment theory and the claim has been made that well-known successful investors including Warren Buffett and Bill Gross use Kelly methods.

• Win probability - The probability that any given trade you make will return a positive amount. 
• Win/loss ratio - The total positive trade amounts divided by the total negative trade amounts.

These two factors are then put into Kelly's equation: 
Kelly % = W – [(1 – W) / R]

Where: 
W = Winning probability 
R = Win/loss ratio = value of profitable trade/ value of loss making trade

Example: say you are winning 60% of the time and your Win/ Loss ratio is 1.5. Then you should invest:

= 0.6-[0.4/1.5]=0.33 or 33% of your capital on a trade.

Another example: say you are winning 20% of the time and your Win/ Loss ratio is 5. Then you should invest:

= 0.2-[0.8/5]=0.04 or 4% of your capital on a trade.

Last example: say you are winning 50% of the time and your Win/ Loss ratio is 2. Then you should invest:

= 0.5-[0.5/2]=0.25 or 25% of your capital on a trade.


NOTE: I am risk averse and prefer capping investment per trade at 5% of capital.

Read more at https://www.investopedia.com/articles/trading/04/091504.asp



Kindly Note : All ideas and materials presented herein are for informational and educational purposes only, and is not intended for commercial or trading purposes. Neither does it mean to misguide anyone. Kindly make informed decisions on your own risk. Neither livettcelearn.blogspot.in website nor any of its owner shall be liable for any errors or delays in the content or for any actions taken in reliance thereon.

Read More

Saturday, December 30, 2017

Seven Steps To Becoming a Successful Trader : By Matthew Teuschel !!!






I've recently started reading a book written by a very successful trader named Alexander Elder. The book is called "Trading for a Living". If you guys haven't read it yet, put it at the top of your list of books to read because it is an absolute GAME CHANGER!

For a while now, I've realized that there is nothing wrong with the trading system we use on this website. It is indeed very powerful, consistent, and reliable. It's myself as a trader that is, as Mr. Elder would call it, the "weakest link" of the trading system.In the book, he constantly reiterates the fact that the key to success as a trader is not in the trading system, your analysis methods, or finding the right guru. 

It's all about managing your emotions and trading based on intellect. And I couldn't agree more.Time and time again, I've seen the MACD trading system produce amazing results, but yet, here I am, still trying to work out some kind of detail. Truth be told, the details were not the problem. It was my tendency to trade emotional AND very poor money management. Trading without stops is NO LONGER ALLOWED!

The rest is up to you to read but I did want to give you a 7 step plan from the book that I believe will truly help you become the professional trader you want to be, as it's already helped me grow by leaps and bounds. Enjoy!

Alexander Elder's 7 steps for becoming a professional trader:


1. Decide that you are in the market for the long haul - that is, you want to be a trader even 20 years from now.

2. Learn as much as you can. Read and listen to experts, but keep a degree of healthy skepticism about everything. Ask questions, and do not accept experts at their word.

3. Do not get greedy and rush to trade - take your time to learn. The markets will be there with more good opportunities in the months and years ahead.

4. Develop a method for analyzing the market - that is, "If A happens, then B is likely to happen." Markets have many dimensions - use several analytic methods to confirm trades. Test everything on historical data and then in the markets, using real money. Markets keep changing - you need different tools for trading bull and bear markets and transitional periods as well as a method for telling the difference.

5. Develop a money management plan. Your first goal must be long-term survival; your second goal, a steady growth of capital; and your third goal, making high profits. Most traders put the third goal first and are unaware that goals 1 and 2 exist.

6. Be aware that a trader is the weakest link in any trading system. Go to a meeting of Alcoholics Anonymous (yes, Alexander Elder actually went to an AA meeting and every time he heard the word "alcohol", he replaced it with the word "losses". Talk about commitment!) to learn how to avoid losses or develop your own method for cutting out impulsive trades.

7. Winners think, feel, and act differently than losers. You must look within yourself, strip away your illusions, and change your old ways of being, thinking, and acting. Change is hard, but if you want to be a professional trader, you have to work on changing your personality.

Kindly Note : All ideas and materials presented herein are for informational and educational purposes only, and is not intended for commercial or trading purposes. Neither does it mean to misguide anyone. Kindly make informed decisions on your own risk. Neither livettcelearn.blogspot.in website nor any of its owner shall be liable for any errors or delays in the content or for any actions taken in reliance thereon.
Read More

Tuesday, August 5, 2014

Tips & Tricks: GoogleFinance in Google spreadsheets



Would you like to easily keep track of stock market quotes and other data relevant to your stock portfolio? You can use the GoogleFinance function in Google spreadsheets to automatically pull up-to-date information into your spreadsheet. Using the GoogleFinance function in a spreadsheet allows you to create a one-stop shop for your stock data.

Using the GoogleFinance functionTo use the GoogleFinance function, enter the formula into the desired spreadsheet cell:=GoogleFinance(“Symbol”, “Attribute”) where “symbol” represents the stock symbol of the company or mutual fund you’re looking for and “attribute” represents the type of market data that you want information about. If attribute is left blank, the stock price is populated into the cell by default.

For example, if I wanted to find out the 52-week price high for Procter & Gamble stock, I’d enter=GoogleFinance(“PG”, “high52”). Make sure to put quotation marks around both the symbol and the attribute in order for the formula to compute properly.

The 52-week price high for Procter & Gamble then shows in the cell in which the formula was entered.

I can also apply the formula to a larger list of symbols and attributes in order to get data for multiple different stock/mutual fund listings across various types of data. Instead of typing the formula out like before, I want to click the cell of the first symbol in my list, in this case it’s PG. Next, I want to reference the cell in which I name the attribute I’m looking up, in this case, price.

Freezing the appropriate row and column with a “$” allows me to drag the formula across to the “52-week high” and “52-week low” columns, as well as down the other rows to apply the formula to all of the other stocks. When I apply the formula to all of the other cells, the results will show.

Here are a few more examples of attributes you can access using the GoogleFinance function:
  • price: market price of the stock.
  • priceopen: the opening price of the stock for the current day.
  • high: the highest price the stock traded for the current day.
  • low: the lowest price the stock traded for the current day.
  • volume: number of shares traded of this stock for the current day.
  • marketcap: the market cap of the stock.
  • tradetime: the last time the stock traded.
  • datadelay: the delay in the data presented for this stock using the googleFinance() function.
  • volumeavg: the average volume for this stock.
  • pe: the Price-to-Earnings ratio for this stock.
  • eps: the earnings-per-share for this stock.
  • high52: the 52-week high for this stock.
  • low52: the 52-week low for this stock.
  • change: the change in the price of this stock since yesterday's market close.
  • beta: the beta value of this stock.
  • changepct: the percentage change in the price of this stock since yesterday's close.
  • closeyest: yesterday's closing price of this stock.
  • shares: the number of shares outstanding of this stock.
  • currency: the currency in which this stock is traded.
Using GoogleFinance to show historical dataThe GoogleFinance function also allows you to easily show historical stock data, allowing you to track the performance of any stock across a certain time period. To show historical data, type =GoogleFinance("symbol", "attribute", "start_date", "num_days|end_date", "interval") into a spreadsheet cell. You’ll find details about the syntax of this formula below:
  • “Symbol" and “attribute” follow the same rules as above
  • “Start date” is the day you’d like to start showing information from
  • "num_days" | "end_date" [Optional] can be either the end date for the time period over which you want to see historical data, or the number of days from the start date. Any number less than 50 is considered to be num_days. Otherwise it is considered an end_date.
  • "interval" specifies granularity at which the stock data is shown, either daily or weekly. You can enter either “Daily” or “1” if you would like daily information and either “Weekly” or “7” for weekly data.
You can find more information about historical data and mutual fund data in the Google spreadsheets help center.

Give it a try and let us know what you think.


Note:
This feature currently focuses on U.S. stock exchanges - we're working to add more international data, but for now, stock symbols default to U.S. exchanges. International results may not be supported, and results are only in English. Data may be delayed by up to 20 minutes, and we can't guarantee its accuracy - please see our Stock Quotes Disclaimer.
Read More

Tuesday, August 13, 2013

GTXL file



Hi JN Team,
Attached two Files:

Thank you for all responding to my GTXL. To prepare this file took at least one year, thank you to all those who prepared and shared their valuable files on Internet. I.e. Just nifty file, Murray Math File, Option Analysis, Gann Square 9, LOGEST, Regression analysis, Sine Weighted Moving average etc..

I did just collate all these available information in Structured Manner to find out the right direction of the Market.
Based on predefined Conditions, GTXL file give the correct direction of the Market as well as right ITM options strikes and its fare premium pricing.

- Basic Points to remember while using GTXL File:

1. Start using this file after 9:20 AM
2. Starting of the day refresh all data (Excel -> Data -> Click on Refresh All Button).
3. There is no Manual Intervention required on this File. Just Click on refresh all Button and get the Trend of the Market.
4. Am also updated comments on most usefully cells that basic comments will help to understand the functionality of file.

Disclaimer:
GTXL is only for educational Purpose, not for trading, Trade as per your own analysis and risk.

Regards

GT



Read More

Sunday, March 17, 2013

HEDGING TECHNIQUE NIFTY & BANKNIFTY


                                        HEDGING TECHNIQUE NIFTY & BANKNIFTY


Points : 

I HAVE BEEN FOLLOWING A VERY SIMPLE HEDGING TECHNIQUE FOR THE PAST FEW MONTHS WHICH HAS BEEN GIVING ENCOURAGING POSITIVE RESULTS. I WOULD LIKE TO SHARE THE SAME HERE.

IT IS VERY SIMPLE. AT AROUND 3.27 PM WE HAVE TO COMPUTE THE PIVOT POINT (PP) OF BANKNIFTY....  

PP = (OPEN + HIGH + LOW) / 3. 

IF LTP AT 3.27PM IS ABOVE PP, IT IS A "BUY" SIGNAL FOR NEXT DAY AND IF LTP IS LESS THAN PP, IT IS "SELL" SIGNAL FOR NEXT DAY.

BASED ON THE ABOVE, IF BUY SIGNAL IS GENERATED, BUY 1 LOT OF BANKNIFTY AND SELL 2 LOTS OF NIFTY AT THE SAME TIME AROUND 3.28-3.29PM JUST BEFORE MARKET CLOSING.

NEXT DAY WE HAVE TO EXIT FROM BOTH POSITIONS SIMULTANEOUSLY WHEN IN PROFITS...

THIS METHOD HAS BEEN GIVING VERY GOOD RESULTS AND IS A SMALL RISK HEDGING STRATEGY...

    
   Link : https://docs.google.com/file/d/0B1y9IhKnJKiPdW55RU9pT1otRVU/edit?usp=sharing
   

Read More

LIVETTC OPTION TRADING WORKBOOK


                                          LIVETTC OPTION TRADING WORKBOOK



   Link : https://docs.google.com/file/d/0B1y9IhKnJKiPYWl6UVdPYzkzR0E/edit?usp=sharing
Read More

Thursday, November 22, 2012

Strategy Based on Moving average







NOW LET ME EXPLAIN THIS DATA :

YOU WILL OBSERVE THAT THE FIRST 2 BUY SIGNALS IN 8 SMA AND 15 SMA WERE GENERATED ON 28TH MAY, 2012. ON THIS DAY THE FIGURE OF (33.24) IN 8-34 I.E. COLUMN K IS ALSO SHOWING AN INCREASING TREND COMPARED TO PREVIOUS DAYS….THUS BUY ON 28TH MAY IS CONFIRMED AND LTP WAS  411.85…..

THEREAFTER YOU WILL SEE AN UPTREND IN PRICE….HOWEVER ON 1ST, 4TH & 5TH JUNE THE PRICE HAS FALLEN BUT THE FIGURE IN COLUMN K (8-34) IS STILL SHOWING AN INCREASING TREND, THEREBY INDICATING THAT THE TREND IS UP AND THE “SELL” SIGNALS GENERATED IN 8 SMA AND 15 SMA ON THOSE DAYS ARE "FALSE"….

THOSE WHO WERE HOLDING LONGS FOLLOWING THIS UPTREND WILL SEE THAT TATASTEEL KEPT MOVING UP DAILY THEREAFTER AND MADE A HIGH OF 444 ON 29TH JUNE, 2012….. 

IT IS STILL IN UPTREND AS THE FIGURE IN COLUMN K (8-34) IS STILL INCREASING.



FOR EXAMPLE, TO GET 8 SMA SIGNAL, FOLLOW THE BELOW STEPS :

1.  WORK OUT 8 DAYS SMA, WHICH IS SUM OF LAST 8 DAYS LTP DIVIDE BY 8.

2.  IF TODAY'S LTP IS HIGHER THAN 8 SMA COMPUTED IN 1, IT IS 

    BUY SIGNAL AND VICE VERSA...

SIMILARLY YOU MAY COMPUTE 15 DAYS SMA AND 34 DAYS SMA....



Read More

NIFTY TRADING SECRET REVEALED






YOU NEED TO INSERT OHLC DATA DAILY TO GET THE BUY / SELL SIGNALS....YOU CAN DRAG DOWN THE PREVIOUS DAY'S DATA FOR COLUMNS OTHER THAN OHLC....

I NORMALLY INSERT THE ACTUAL OHLC VALUES AROUND 3.20 PM AND BASED ON SIGNALS GENERATED, I TAKE POSITIONS FOR THE NEXT TRADING DAY....

YOU CAN KEEP UPDATING OHLC VALUES DURING TRADING HOURS TO GET THE SIGNAL FOR THAT DAY....

IF YESTERDAY THE SIGNAL WAS SAY "BUY" AND YOU HAD GONE LONG AND TODAY DURING THE TRADING HOURS YOU SEE THAT THE SIGNAL IS STILL "BUY" AFTER INSERTING OHLC VALUES, YOU MAY CONTINUE HOLDING YOUR PREVIOUS DAY LONG POSITIONS AND ADD FURTHER QTY.....


ONE MORE TIP, YOU HAVE TO ALSO CONSIDER THE VALUES IN 8-34 COLUMN (COLUMN "V")....

IF THE VALUE IS REDUCING COUPLED WITH "SELL" SIGNALS IN SMA TRADING COLUMNS, YOU CAN SELL NIFTY FUT OR BUY PUTS....

IF THE VALUE IS INCREASING COUPLED WITH "BUY" SIGNALS IN SMA TRADING COLUMNS, YOU CAN BUY NIFTY FUT OR BUY CALLS....

IF THERE IS A CHANGE IN SIGNAL IN 8 SMA TRADING COLUMN BUT THE CORRESPONDING VALUE IN 8-34 COLUMN "V" DOES NOT CONFIRM THE SAME, PLZ AVOID TRADING ACCORDING TO THE TREND CHANGE GENERATED IN 8 SMA....


Link : https://docs.google.com/open?id=0B1y9IhKnJKiPRmIyY2NfMWw4Ykk

Read More
Powered By Blogger And Premium Template By Lord HTML