Switch To Product Links Languages Themes Feedback Sign Up Now
Loading...
Updating...
Please wait to edit...
Ready for editing X
reliance-money-shares-sales-pu... by shwetasoftwares  158 views
Print Export Copy to My Account Embed in Website/Blog
$ Macros
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Client CodeExchangeTradeID ExchangeOrderNo TradingAccount Exchange TradeType Group B/S Scrip Quantity Price Amount ExchangeTradeDate ExchangeTradeTime BrokerTranID OrderPlacedBy ID
S00000001285922274483206DELIVERYBSEDELDELIVERYBABC CO. LTD10010010,000.004/1/200715:02:051215721S00000001274483206285922
S0000000142383558304201DELIVERYBSEDELDELIVERYSABC CO. LTD10015015,000.004/2/200710:28:371264416S0000000155830420142383
Remarks:-
1) Reliance Money format for sale/purchase of Shares.
2) The Reliance Money users can download their sale/purchase transactions using following option:-
* After logging to Reliance Money, select option "History -> Trades".
* Next, specify the FROM/TO dates and click on EXPORT
* This will export the data into a Columnar format. You need to copy this and paste it into a Excel sheet
3) The XML tags are written in Cells A1, M1 and Q1.
4) Column Q has been added as Tally requires a UNIQUE field for each transaction.
5) The following Brokerage and Taxes rates have been adjusted in the above sales/purchase transactions
* Securities Transaction Tax (STT)0.125%
* Brokerage (per Trade)0.01 paise
* Other Charges on SaleRs 12/-
Sheet1
 
     
Processing...
Assign Macro Edit Label More