Crypto Trade Buy Sell Spread sheet -- 3
Budget: $35 – $60 AUD
Hi I would like to get an excel spread sheet for crypto trading.
My requirements
1)An "active trade" sheet
2)Completed Trade sheet (when I finish a trade it should automatically move from active to completed trade)
3) Buy and cell buttons on active page
4)When Buy Button is pressed, I should have 2 combo boxes on that Userform(one for coin names and second one for exchange name) , when I select the items from combo boxes, (a) if I have a matching trade, our new trade should be added to it . If we clearly says that particular active trade will be updated with number of new coins and cost of purchase. (b) If you don't have a matching trade, then enter this as a new trade in a new row.
5) When sell button is pressed, Userform will show two combo boxes(exchange name and coin name) and text box to enter the number of coins you sold, it will give you a list box wilthe values(price of per coin sold, Total value of remaining coins in the wallet, value per coin remaining in the wallet, number of coins remaining in the wallet). Copy and update the remaining coins data (price per coin, total price, Number of coins in the same listing. Copy the sold coins name, price and number of coins on the completed trade sheet.
6) Both buy and sell userform should have date text boxes, and transaction fee entry text boxes
7) If Transaction fee text box can be prefilled when selecting a particular exchange , that will be good. When I enter exchange name , I can enter exchange fee (usually transaction fee remains same for all trades for any particular exchange).
Please reply, if you can go ahead with this
My requirements
1)An "active trade" sheet
2)Completed Trade sheet (when I finish a trade it should automatically move from active to completed trade)
3) Buy and cell buttons on active page
4)When Buy Button is pressed, I should have 2 combo boxes on that Userform(one for coin names and second one for exchange name) , when I select the items from combo boxes, (a) if I have a matching trade, our new trade should be added to it . If we clearly says that particular active trade will be updated with number of new coins and cost of purchase. (b) If you don't have a matching trade, then enter this as a new trade in a new row.
5) When sell button is pressed, Userform will show two combo boxes(exchange name and coin name) and text box to enter the number of coins you sold, it will give you a list box wilthe values(price of per coin sold, Total value of remaining coins in the wallet, value per coin remaining in the wallet, number of coins remaining in the wallet). Copy and update the remaining coins data (price per coin, total price, Number of coins in the same listing. Copy the sold coins name, price and number of coins on the completed trade sheet.
6) Both buy and sell userform should have date text boxes, and transaction fee entry text boxes
7) If Transaction fee text box can be prefilled when selecting a particular exchange , that will be good. When I enter exchange name , I can enter exchange fee (usually transaction fee remains same for all trades for any particular exchange).
Please reply, if you can go ahead with this