Create Stock Portfolio in Excel/Google Sheet, Part 2 - Import Data from Meroshare
In this video, I will show you how we can import Mero Share application data in our portfolio application. This will be very helpful when you have large number of transaction and don't have enough time to enter them manually in google app. If you have any question please leave them below and you can also provide your feedback's on this video.
If you don't have Excel, then use following steps
1. Open google sheet
2. Go to the File Menu
3. Select Open Menu
4. Go to the Upload
5. Click on the select a file from your device
6. Select the file you have downloaed from meroshare. This will open meroshare CSV file in google sheet.
Formula:
Company Full Name=Index(Sheet2!E:E,Match(B2,Sheet2!C:C,0))
Transaction Type=IF(REGEXMATCH(H2,"CA-Bonus"),"Bonus","")