US/EST: 14 Oct 2019 08:59

For Buyers - Shares Bought - CSV File using Excel

3 posts, 2 voices


 
Lolito78
Lolito78 83 points
112 posts
status: Enthusiast
Send Message Recent Forum Posts watchlist permalink

22 days 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 83 points
112 posts
status: Enthusiast
Send Message Recent Forum Posts watchlist permalink

22 days ago

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

Schabernack
Schabernack 1340 points
10273 posts
status: Moderator
Send Message Recent Forum Posts watchlist permalink

22 days ago

Thanks Lolito, very interesting!