Import from a csv and process In and out data

[kcentric]

I'm trying to do math to determine rewards for people staking their tokens in a cryptocurrency farming contract. The explorer for the contract has a button that exports a .csv file. Each line of the file is either a user staking (moving tokens from their wallet address to the contract address) or un-staking (moving tokens from the contract address to their wallet address). We need a file that can import the data from the .csv file and then determine who is still staking in the contract, how much they are staking, and what percentage of the total pool that represents.

The important fields in the csv file are From, To, DateTime, and Quantity

When the user's wallet address is in the "from" field and the contract address is in the "to" field that is them staking to the contract.

When the contract address is in the "from" field and their wallet address is in the "to" field that is them un-staking.

DateTime and Quantity tell us how many tokens were moved in or out of the contract and when they were moved.

We need to get a list of wallet addresses that still have tokens staked in the contract, and how many they have remaining, and what percentage of the total pool each wallet holds.

There would only be one field which requires a manual user input, and that would be the address of the contract, since we have multiple contracts that we may be calculating from.

I guess I have two problems 1) the best way to either pull the data into a sheet from the external csv file, or to paste formulae into the csv file? and 2) converting the unsorted from and to transactions into a total for each wallet.

[AliGW]

You can import the .csv file from its location on your system:

Data ribbon | From Text/CSV.

You can then use PowerQuery to manipulate it or add your formulae.

[torachan]

give us a clue, is the contract address 0x3056923a2321c6d73036927541a1017cca522cb5

[kcentric]

Yes, sorry that is it. I realized that my question was a bit wordy so I cut some text out, unfortunately that was part of the text.

[AliGW]

It would be helpful if you provided a mock-up of how you want this to look once processed to give us an idea of what we are aiming for. A visual is better than words.

[torachan]

As a starter look at the attached - it has a long-winded macro on the orange button.
All I have done is load the .csv file direct to Excel (you will need to look at 'All files' in the search dialog box.
The macro needs columns ("H:N") so leave clear - this needs @Jindons 'magic dust' sprinkling on the macro to reduce it to ten lines of code.

[kcentric]

So the way I imagined it is at the top of the sheet 1) a button that says "Import .csv file" It browses for the file. 2) An input box that says "Paste Farming Contract Address" where the user pastes the address to be tested, and then 3) a button that says "Process" which would sort the list into the rows below sorting by how many tokens each wallet still had staked the largest at the top and the smallest or zero at the bottom (or preferrably with the zero holders not listed at all).

[AliGW]

Can you mock up your imaginings in a workbook and post it here?

[torachan]

there is no need to paste a .csv into a sheet - you can open it direct into Excel.