US/EST: 15 Dec 2019 20:58

For Buyers - Shares Bought - CSV File using Excel

3 posts, 2 voices


 
Lolito78
Lolito78 193 points
233 posts
status: Grinder
Send Message Recent Forum Posts watchlist permalink

3 months ago

so guyz, if u wanna find out how much u invested and how much u got back as buyer the csv file is not helpful really as all data is in one cell.

Do not use Excel menu to open the csv file. Use VBA to open the csv file.

Open new Workbook.
Add new Modul in VBA and copy this code and adapt your location of the file.

Workbooks.Open “C:\Users\thomas.xxxx\chipmeup.csv” End Sub

hese are my investments and winnings as a buyer: 1053,42 823,13

as u see they are different to what cmu says:
https://gyazo.com/8701150a346569e02052900126be74d8

Hope i could help


How enable VBA:
https://www.excelcampus.com/vba/enable-develope...
New Modul:
https://www.excelcampus.com/vba/copy-import-vba...

Lolito78
Lolito78 193 points
233 posts
status: Grinder
Send Message Recent Forum Posts watchlist permalink

3 months ago

Public Sub Test()
Workbooks.Open “C:\Users\thomas.xxxx\Desktop\Testlöschen\chipmeup.csv”
End Sub

Schabernack
Schabernack 1341 points
10277 posts
status: Moderator
Send Message Recent Forum Posts watchlist permalink

3 months ago

Thanks Lolito, very interesting!