help for ms-excle formula

#1
hi
all visitor of traderji i use ms-excle sheet for calculation my mcx trade but i need help for it i want to formula gold and gold lot is 100 lead lot is 5000 copper is 1000
every time i enter lot size
so i need help for it
for example if i enter gold in Cell A1 the lot size automatic show in cell B2
(if A1=gold, 100 A1=silver, 30 A1=copper, 100)
so please help me
 

nac

Well-Known Member
#3
^ Don't waste your time by typing each every trade. Better download your trade book at the end of the day(I guess, you would have such choice in your software) and copy and paste them in your excel. Calculate only your P/L, T. Charges, brokerage and service tax.
Keep everyday's data in a separate worksheet. If there is 20 trading days in a month keep 20 worksheets.(1 month 1 file)
If you still got doubt, you can send me your trade book(downloaded). Or some of our TJ member could help you.
 

AW10

Well-Known Member
#4
Another approach is
1) on sheet 2, sort the table for column B, in ascending order so that entries are like
Aluminium, copper, crude etc.
2) on cell F2, enter the formula =VLOOKUP(B2,Sheet2!B:C,2)
In short, this formula is using value in B2, to look in the table created on sheet 2 betweencolumn B and C, and when there is match found, return the value from 2nd column of that table.

You can use excel help on Vlookup function for more details.
3) Copy the same formula in column L as well. Actually you don't need column L. instead use qty from column F in your formulas.

Hope this helps.
Happy Trading
 

Similar threads