PAIR TRADING TOOL

663 views
Skip to first unread message

manoj.borse9

unread,
Nov 2, 2013, 2:12:13 PM11/2/13
to pairtra...@googlegroups.com
Posting simple PAIR TRADING TOOL !
Hope this would help in some context !

Thank you !
Happy Diwali !

Tool :
http://www.4shared.com/file/hYGk_yLt/Pair_Trading_with_Chart_by_MAN.html

~
Regards
MANoj Borse

jaya prakash reddy chilla

unread,
Nov 4, 2013, 12:32:57 AM11/4/13
to pairtra...@googlegroups.com
Dear monoj,
really nice work done by you. it really helps the traders as the data is automatically updated. keep it up.
regards
jaya prakash reddy


--
You received this message because you are subscribed to the Google Groups "Pair Trading" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pairtrade-gro...@googlegroups.com.
To post to this group, send email to pairtra...@googlegroups.com.
Visit this group at http://groups.google.com/group/pairtrade-group.
For more options, visit https://groups.google.com/groups/opt_out.

MANoj BORSE

unread,
Nov 4, 2013, 1:31:45 AM11/4/13
to pairtra...@googlegroups.com
Thanks Vinay & Jaya Prakash !

@Vinay : Data are updated for EOD only, also it wont show u current live market rates. so you need to act accordingly to previous days data.

I dont know how profitable it would prove to all, but created so shared !
Hope all will enjoy !

Happy Trading !
--
Best Regards,
Manoj Borse

nilesh neharia

unread,
Nov 4, 2013, 3:00:10 AM11/4/13
to pairtra...@googlegroups.com

Manoj I m not able to access the file can u pls resend it.

nilesh neharia

unread,
Nov 4, 2013, 3:57:20 AM11/4/13
to pairtra...@googlegroups.com

Manoj 4 Shared it solutions I have to instal .

Vinay Shetty

unread,
Nov 4, 2013, 4:00:21 AM11/4/13
to pairtra...@googlegroups.com
Manoj,

could you please explain more about sheet 1 and sheet 2. do they also get refreshed by EOD. i see comments like "strong buy/sell" are they updated too.

also i assume if X will be always BUY and Y will be sell .please clarify.


On Mon, Nov 4, 2013 at 2:27 PM, nilesh neharia <nehari...@gmail.com> wrote:

Manoj 4 Shared it solutions I have to instal .

--

nilesh neharia

unread,
Nov 4, 2013, 4:04:35 AM11/4/13
to pairtra...@googlegroups.com

Vinay can u send me the sheet as there is a problem in my side as I m unable to access it

Vinay Shetty

unread,
Nov 4, 2013, 4:05:49 AM11/4/13
to pairtra...@googlegroups.com
attached document
Pair Trading with Chart by MANoj.xlsm

nilesh neharia

unread,
Nov 4, 2013, 4:18:00 AM11/4/13
to pairtra...@googlegroups.com

Thanx vinay

MANoj BORSE

unread,
Nov 4, 2013, 4:31:39 AM11/4/13
to pairtra...@googlegroups.com
Sorry for delay !

@Nilesh : its extension is .xlsx wo you need to update your MS OFFICE.
@Vinay : First of all thanks for easing my work, providing excel file to Vinay .

Main AUTO-UPDATABLE sheets are just "Pair-Trade-SPOT" and "Charts".
others are just my notes from differenet different sources, they are not auto-updatable.
Best Regards,
Manoj Borse

nilesh neharia

unread,
Nov 4, 2013, 6:00:43 AM11/4/13
to pairtra...@googlegroups.com

Nice work done manoj.keep it up

MANoj BORSE

unread,
Nov 4, 2013, 8:34:31 AM11/4/13
to pairtra...@googlegroups.com
Thanks Nilesh :)

Vinay Shetty

unread,
Nov 4, 2013, 11:56:52 PM11/4/13
to pairtra...@googlegroups.com
Manoj,

when RULE 2 is staisfied both ways .. then which pair should be BUY and which one should be SELL.
CURRENT SPREAD < MIN SPREAD
CURRENT SPREAD > MAX SPREAD

do we need to decide on below 3 pairs ?

jAlpha
Sharp
Trenor
 

Thanks,
Vinay.

vpav...@gmail.com

unread,
Nov 8, 2013, 12:40:05 AM11/8/13
to pairtra...@googlegroups.com
Manoj,

Any updates on this please?

MANoj BORSE

unread,
Nov 10, 2013, 6:47:39 AM11/10/13
to pairtra...@googlegroups.com
if all the conditions are satisfied,
wait for confirmation for the same from chart

once confirmed enter it as said :
CURRENT SPREAD < MIN SPREAD : BUY FIRST SYMBOL , SELL SECOND
vice-versa for  CURRENT SPREAD > MAX SPREAD

Rishi Roy

unread,
Dec 25, 2013, 2:49:44 AM12/25/13
to pairtra...@googlegroups.com
Hi Manioj,

    I'm tracking pair trading from last 3months .i like to start real trade .  If u have any updated excel sheet pls post ...

Regards,
Rishi  

Vikas Patni

unread,
Jul 23, 2014, 11:23:07 AM7/23/14
to pairtra...@googlegroups.com
hi i need the three month data instead of one month pls let me know the procedure and what do u mean by if condition satisfy take confirmation from chart can u explain it

Vikas Patni

unread,
Jul 30, 2014, 2:20:50 AM7/30/14
to pairtra...@googlegroups.com
I WANT CALCULATE MEAN SPREAD FOR 
60  DAYS AND 90 DAYS BUT YOUR TRADING TOOL EXCEL CALCULATE ONLY FOR 22 DAYS , PLS LET US KNOW TO EDIT OR LET US KNOW THE WAY TO EDIT

MANOJ BORSE

unread,
Jul 30, 2014, 2:33:28 AM7/30/14
to pairtra...@googlegroups.com
It calculates based on dates passed if third is selected as "unselected" otherrwisse it will do 1 month , 3 month irrespective of dates passed.


--
You received this message because you are subscribed to the Google Groups "Pair Trading" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pairtrade-gro...@googlegroups.com.
To post to this group, send email to pairtra...@googlegroups.com.
Visit this group at http://groups.google.com/group/pairtrade-group.
For more options, visit https://groups.google.com/d/optout.



--
Best Regards,
Manoj Borse


Sr. Executive Java Web Developer
(NJ Finlogic India Pvt. Ltd.)
Cell. No : +91 9429090498

Vikas Patni

unread,
Jul 30, 2014, 5:54:21 AM7/30/14
to pairtra...@googlegroups.com
CAN I INTIATE THE TRADE HDFCBANK AND HDFC CUURENT PR CASH MKT 1.2987


--
You received this message because you are subscribed to a topic in the Google Groups "Pair Trading" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pairtrade-group/G86l-zrCprA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pairtrade-gro...@googlegroups.com.

MANOJ BORSE

unread,
Jul 30, 2014, 6:02:16 AM7/30/14
to pairtra...@googlegroups.com
I am not good at selecting pairs, I am good at coding for coded a tool and shared.
Ask masters for call to be take or not.

Happy Trading !

Vikas Patni

unread,
Jul 30, 2014, 6:05:42 AM7/30/14
to pairtra...@googlegroups.com
OK THANKS .
sorry to bother u , i didnt understand It calculates based on dates passed if third is selected as "unselected" otherrwisse it will do 1 month , 3 month irrespective of dates passed., what is third ?

Vikas Patni

unread,
Jul 30, 2014, 6:24:53 AM7/30/14
to pairtra...@googlegroups.com
ok got it third is unseleted


On Wed, Jul 30, 2014 at 12:02 PM, MANOJ BORSE <manoj....@gmail.com> wrote:

--
You received this message because you are subscribed to a topic in the Google Groups "Pair Trading" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pairtrade-group/G86l-zrCprA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pairtrade-gro...@googlegroups.com.

MANOJ BORSE

unread,
Jul 30, 2014, 6:42:51 AM7/30/14
to pairtra...@googlegroups.com
Welcome :)

Vikas Patni

unread,
Aug 1, 2014, 3:24:02 AM8/1/14
to pairtra...@googlegroups.com
IN YOUR TRADING TOOL RATIO CHART IS NOT WORKING PLS LET ME KNOW HOW IT WILL WORK  AND PLS ADD PR COLOUM ALSO  SO WE CAN UNDERSTAND THE PR TRADES BETTER
Reply all
Reply to author
Forward
0 new messages