Hello everyone! Thank you for checking out this video on how to improve the format of data retrieved from an exchange. I put together this video together to try to help you save time figuring out what is really reflected in the data pulled down from an exchange, and make it into a format that can be replicated across exchanges. Within the video we talk about –
1) How to use the len(), right(), left(), and find() functions
2) Logical ways to improve data, or extract data in a repeatable and dynamic fashion
3) Vlookup and Index Match functions
I hope this helped you under excel better, while also helping to prepare you for the crypto tax process. The data that comes through exchanges can often be daunting and confusing, but hopefully using these simple and effective methods, you can transform the data to fit your needs!
If you enjoy the video or have any questions, please let me know in the comments below and subscribe. I hope to make more videos in the future relating to efficiency, excel and macro development. If you found this very useful, and would like to donate to help me improve my channel and make more videos in the future, please feel free to do so at www.paypal.me/everydayefficiencies.
Disclaimer: Nothing stated or referenced within or in relation to this video is intended to provide tax, legal or accounting advice. All information provided herein is the author’s opinion. This material has been prepared for informational purposes only, and is not intended to provide, and should not be relied on for, tax, legal or accounting advice. You must obtain alternative professional or specialist advice before taking, or refraining from, any action on the basis of the content in this publication.
