My Excel Profit_Loss Traking Utility

#1
Hello All,
Whether u r day trading or doing delivery based trading--knowledge of the risk u can really take is of utmost importance----Moreover during day trading---when a script starts falling---the risk aspect(the Loss--along with the consideration of the brokerage and other taxes) plays a crucial role----Many a times we tend to calculate Profit/Loss approximately with out the least considerations of the brokerage and other miscellaneous costs---Moreover instead of relaying on the Data provided by broking houses ---one should manualy maintain the porfolio details too---

For both this purposes--this is a small excel utility(entirely made by me--which will be part of of a bigger software later)--- I would like to put forward here in this forum---where from I have benefitted immensely---This is still now professionally sold by me at a nominal cost-----

Dearest Traderji---The zipped Excel file----occupies around 900 kb---If u kindly let me know---how I can upload it here---I will be obliged---

Regards,
joy_mitali
 
#5
Hi Joy
I know u track derivatives more closely than others. Pls advice on my long in Bharti Tel Futures @321 and short BOI futures @ 122
Thanx
 
#6
Hi SSM,
If u consider the data from Aug to 2nd Sept---BOI started falling from 143 level to a low of 114.8 leve(on 24th AUG) after which it has stared increasng to 122 level---I think as the market itself is quite high there can be a correction any moment---where by it may fall to 112 level---U can cover up ur short there----On the upside BOI can go to 135 level----Keep a Stop loss of 126---130-----dependind on ur risk apetite----

Bharti tele is in already in a high side pricing range---this stk can move to 335--340 level on upside and 300 on dwn side(has a greater probablity)----Remain in the long position with a stop loss of 315---310---depending on ur risk ability---But my opinion---do not take too much chance on upside----sell it around 330-----unless u feel the market too bulluish---

Regards,
joy_mitali
 
#8
Hi Friends--
As suggested by Karthikmarrar---I m uploading the file---www.savefile.com---
The link is----
http://www.savefile.com/projects/898411
Some datas r included in the file ----u just try to see---if u can understand it---
I will explain--the file ---next time--
One more imp think---Plz ---never ever remove the split----otherwise---u wont be again to create the split as the file is ---password protected---

Do give ur suggestions----for further improvement---
Regards,
joy_mitali
 
#9
Hi All---
As per as I said---I m explaining the terms in my excel file---
Column A---Client type---U can put J(actually J for Joy) or ADM(administrator)--Acutally my original version has diff client types---for whom there r diff brok. structures---If someone wants to tailor-make it ---do mail me at [email protected]

Col B---Brok.House----it can be SK(ShareKhan),IB(Indiabuls),ICICI---If u put J--(in col 1)---then there r diff brok. structures for diff . Brok.houses---If others want to include some more brok. houses,(with more diff brokerages for intraday and delivery)---then put the suggestions here----

Col C---self explanatory
Col D----Stk. Ex.--only Indian Stock Exchanges has been includd---For international exchanges---and the brokerages---I will like to have more information---Knowledgables---Plz provide it---I will try to incorporate them---
Col--E---self explanatory--
Col F---Buy Typ.--I--for intraday trading---D---for delivery based---For both these diff values---the brokerages gets changed differently----

Col--G----Put the value at which u r buying the stock---
Col H---How many u r buying---
Col I---Prob. Investment---If u put the value in Col H--then value in col I should not be present----this col is to get idea of bow many stks u can buy for for ur choisable investment----
Col K---The CMP--is to see to see how much deviatiation(%)--is occuring from buy priceCan be seen in Col J------(it is optional)----

Col O ---for SP(actual) which will give u--the profit and loss---

Col P---only if Col A--is ADM----
Regards,
joy_mitali
 
#10
I went to http://www.savefile.com/projects.php?pid=898411 but couldn't get a DOWNLOAD LINK.... A smiley ad overlays the download bar. Apart from this, the download button has no link to anywhere...

Its not downloadable! Please help!

Thanks in advance.
 

Similar threads