ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Important Notes & InstructionsChange LogPlaces I have posted this
4
How to copy:On your top left open "file" > select "make a copy"DateVersionNotesDateSub Reddit
5
Help me in this Great Depression 2.0 if you liked my work05/07/20211.0Created the sheet07/07/2021r/IndianStreetBets
6
07/07/20211.0.1Corrected wrong formula in cell U27 (Single PF sheet)08/07/2021r/IndianStockMarket
7
07/07/20211.0.2Modified Colours and minor UI changes09/07/2021r/dalalstreetbets
8
07/07/20211.0.3Added contact info and easy steps to copy09/07/2021r/StockMarketIndia
9
08/07/20211.0.4Added new feature in cell T35 (Single PF Sheet)09/07/2021r/IndiaInvestments
10
08/07/20211.1Added BETA version of Multiple Portfolios
11
08/07/20211.1.1Added (Daily Change) Function to all sheets
12
08/07/20212.0Finished Multiple Portfolios section
13
09/07/20212.0.1Added BETA version of Watchlist
14
09/07/20212.0.2Added BETA version of Trend Analysis
15
10/07//20212.0.3Added Intro Sheet
16
12/07/20212.0.4Added new feature (30 Day stock charts)
17
13/07/20212.1Added new feature (Buy/Sell P/L Journal)
18
Finished Watchlist & Trend Analysis Section
19
23/07/20212.2Modified "Buy/Sell P/L Journal" to support intraday
20
13/10/20212.3Added "Missed out P/L" Data in "Buy/Sell P/L Journal Sheet"
21
14/10/20212.4Added "P/L Contributors" Sheet
22
23
24
25
26
27
28
Be sure to regularly check Change Log for updates
29
Enter Data manually in yellow colour cells
30
Made by: u/chunky_doryEmail for queries: pradaderi@gmail.com
31
For detailed instructions and OG post click HERE
32
Please do tell me if you face any bugs. I will sort them out. Use Email to send Screenshots and explain
33
WARNING: Charges and taxes are calculated for equity delivery trades only. Intraday and FnO have diff. rates
34
Please use correct codes sourced from google finance while customising Index and stock Tickers
35
Search for any Index Tickers in google finance and select the Code after "INDEXNSE:"
36
E.g. Code for Bank Nifty is "NIFTY_BANK"
37
For Stock Tickers Select the code after "NSE:"
38
E.g. Code for Bajaj Finance is "BAJFINANCE"
39
Please Check "Multiple PF Data" sheet for instructions on how to use Multiple Portfolios
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100