I have notable Powershell experience, but I haven't played with VB in over a decade and I don't do much with Excel, so while I'm sure I could figure this out on my own, and I may need too, I figure this might be a common enough scenario where someone might have an elegant solution I can tweak and save myself a bunch of time.
What I'm looking to do is generate a DCA (Dollar cost average) list from a collection of transactions; so I'm looking to grab all the unique ticker values from one column (D) and for each unique value, add up the dollar amounts for it (from column C) and then divide by the share counts (column F); then output the ticker and the DCA value to a seperate set of cells.
Anyone have anything roughly in line with that?
Here's an example table:
What I'm looking to do is generate a DCA (Dollar cost average) list from a collection of transactions; so I'm looking to grab all the unique ticker values from one column (D) and for each unique value, add up the dollar amounts for it (from column C) and then divide by the share counts (column F); then output the ticker and the DCA value to a seperate set of cells.
Anyone have anything roughly in line with that?
Here's an example table:
Purchase History | |||||
for purchases with fiat | |||||
date | Price paid (in local fiat) | Coin Bought/sold (insert ticker symbol) | Amount of coins bought/sold (crypto) | ||
31-May-19 | 500 | ltc | Litecoin | 3 | |
2-Jun-20 | 1000 | btc | Bitcoin | 0.03 | |
8-Jun-20 | 100 | btc | Bitcoin | 0.025 | |
14-Jun-20 | 100 | btc | Bitcoin | 0.0018 | |
22-Jun-20 | 100 | eth | Ethereum | 0.1 |