In support and appendix for this Thread Post:
http://www.excelfox.com/forum/showth...1395#post11395
Data Files from Vixer

target2.xlsx
_____ Workbook: target2.xlsx ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
1
 Symbol
2
 ACC
3
 TCS
4
 MARICO
5
 M&MFIN
6
 TATAELXSI
7
 BAJAJ-AUTO
8
 BANKBARODA
9
10
11
12
Worksheet: Sheet1






target1.xls
_____ Workbook: target1.xls ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I J K L M N O P Q R S T U V W X Y
1 UserId AccountId EntityName Exchg-Seg Symbol Instrument Name Option Type NetBuyValue NetSellValue NetValue NetBuyQty NetSellQty NetQty BEP SellAvgPrice BuyAvgPrice LastTradedPrice MarkToMarket Realized MarkToMarket Unrealized MarkToMarket EL MarkToMarket Trading Symbol Client Context Series/Expiry Strike Price
2 WC5758 NSE MINDTREE EQ 765.00 760.10 -4.90 1 4 760.10 765.00 760.65 -4.9 -4.9 -4.9 MINDTREE-EQ EQ
3 WC5758 NSE BHEL EQ 135.30 67.65 -67.65 2 4 1 67.65 67.65 67.65 67.5 -0.15 -0.15 -0.15 BHEL-EQ EQ
4 WC5758 NSE SIEMENS EQ 2540.40 2504.10 -36.30 2 4 1252.05 1270.20 1253 -36.3 -36.3 -36.3 SIEMENS-EQ EQ
5 WC5758 NSE SUNTV EQ 945.70 939.60 -6.10 2 4 469.80 472.85 473.6 -6.1 -6.1 -6.1 SUNTV-EQ EQ
Worksheet: ap-Sheet1

_____ Workbook: target1.xls ( Using Excel 2007 32 bit )
UserId AccountId EntityName Exchg-Seg Symbol
WC5758 NSE MINDTREE
WC5758 NSE BHEL
WC5758 NSE SIEMENS
WC5758 NSE SUNTV
WC5758 NSE RELCAPITAL
WC5758 NSE JSWSTEEL
WC5758 NSE TVSMOTOR
WC5758 NSE RECLTD
WC5758 NSE PIDILITIND
WC5758 NSE VOLTAS
WC5758 NSE TITAN
WC5758 NSE PNB
WC5758 NSE OFSS
WC5758 NSE YESBANK
WC5758 NSE MFSL
WC5758 NSE PETRONET
WC5758 NSE HDFC
WC5758 NSE PVR
WC5758 NSE SUNPHARMA
WC5758 NSE NIITTECH
WC5758 NSE GRASIM
WC5758 NSE LICHSGFIN
WC5758 NSE MANAPPURAM
WC5758 NSE KAJARIACER
WC5758 NSE BERGEPAINT
WC5758 NSE VEDL
WC5758 NSE UPL
WC5758 NSE BAJAJFINSV
WC5758 NSE ULTRACEMCO
WC5758 NSE UJJIVAN
WC5758 NSE TATAGLOBAL
WC5758 NSE TATAELXSI
WC5758 NSE STAR
WC5758 NSE SRTRANSFIN
WC5758 NSE SRF
WC5758 NSE SAIL
WC5758 NSE HAVELLS
WC5758 NSE MCDOWELL-N
WC5758 NSE PEL
WC5758 NSE PAGEIND
WC5758 NSE NMDC
WC5758 NSE MOTHERSUMI
WC5758 NSE MARICO
WC5758 NSE M&MFIN
WC5758 NSE L&TFH
WC5758 NSE JUSTDIAL
WC5758 NSE IGL
WC5758 NSE IDFCFIRSTB
WC5758 NSE IDEA
WC5758 NSE IDBI
WC5758 NSE HINDZINC
WC5758 NSE HINDPETRO
WC5758 NSE GODREJCP
WC5758 NSE FEDERALBNK
WC5758 NSE EXIDEIND
WC5758 NSE ESCORTS
WC5758 NSE DISHTV
WC5758 NSE DHFL
WC5758 NSE CUMMINSIND
WC5758 NSE CONCOR
WC5758 NSE COLPAL
WC5758 NSE CESC
WC5758 NSE CENTURYTEX
WC5758 NSE CASTROLIND
WC5758 NSE CANBK
WC5758 NSE CADILAHC
WC5758 NSE BIOCON
WC5758 NSE BATAINDIA
WC5758 NSE BANKINDIA
WC5758 NSE ASHOKLEY
WC5758 NSE ARVIND
WC5758 NSE WIPRO
WC5758 NSE SBIN
WC5758 NSE APOLLOHOSP
WC5758 NSE ADANIPOWER
WC5758 NSE ADANIENT
WC5758 NSE TECHM
WC5758 NSE TCS
WC5758 NSE TATASTEEL
WC5758 NSE TATAPOWER
WC5758 NSE RELIANCE
WC5758 NSE POWERGRID
WC5758 NSE NTPC
WC5758 NSE LUPIN
WC5758 NSE HINDALCO
WC5758 NSE LT
WC5758 NSE IOC
WC5758 NSE INFY
WC5758 NSE ICICIBANK
WC5758 NSE IBULHSGFIN
WC5758 NSE HEROMOTOCO
WC5758 NSE HCLTECH
WC5758 NSE GAIL
WC5758 NSE EICHERMOT
WC5758 NSE DRREDDY
WC5758 NSE COALINDIA
WC5758 NSE BPCL
WC5758 NSE BOSCHLTD
WC5758 NSE BHARTIARTL
WC5758 NSE BANKBARODA
WC5758 NSE BAJAJ-AUTO
WC5758 NSE AUROPHARMA
WC5758 NSE ASIANPAINT
WC5758 NSE ADANIPORTS
WC5758 NSE ACC
Worksheet: ap-Sheet1