Tracking Excel Spreadsheet including charts
$20-30 NZD / hour
I am wanting a spreadsheet created with Excel 2016, the spreadsheet will be used for tracking patterns in the stock market and recording profits and losses etc
I need the following tabs
A - "Company name" no formula required
B - "Ticker Symbol" no formula required
C- "Chart image" no formula required
D- "Date" will require a drop down or pop up calendar box to select the date
E- "Time Of Day Entry" no formula required
F- "Hold Timeframe" no formula required
G- "Entry Price" will require entered numbers to be displayed as $
H- "Long Or Short" require a drop down or pop up box to select Long or Short for easy entry
I- "Position Cost" will require entered numbers to be displayed as $
J- "Position Size" no formula required
K- "Profit" will require entered numbers to be displayed as $ . also positive numbers displayed Green/negative red
L- "Risk" no formula required
M- "Reward" no formula required
N- "Sector" no formula required
O- "Catalyst" no formula required
P- "Pattern" no formula required
Q- "Positives" no formula required
R- "Mistakes" no formula required
S- "Scenario" no formula required
T- "Emotions" no formula required
Charts
"Win/loss ratio" - pie chart ratio formulated from the profits tab (K) example for number entries 100.00 100.00 -100.00 -100.00 would be a %50 win ratio x2 winners and x2 losers
"Earnings Bar chart" - A bar chart with the option to select daily profits weekly profits monthly profits
"Patterns Chart" - A list of the patterns entered with a success rate based on the profits for that particular entry, example Pattern 1 x2 entries with that pattern has x2 positive profits that would be 100% success using that pattern. also, I would like to select weekly and monthly options
"
"Chart top 20 Profits" a chart showing the top 20 highest profits, with the option of selecting daily weekly monthly
"Chart top 20 losses" a chart showing the top 20 highest losses, with the option of selecting daily weekly monthly
"Mistakes list/chart" creates a list of the most common mistakes being made from mistakes box entries
"Chart Average win & average loss"
"Chart Average cost of position"
"Chart" based on Catalyst entries with highest profit win/loss ratio
I need a very nice looking clean modern design there may be a few little changes here and there but that is the base of it. Any question let me know.
Many thanks
Daniel
Project ID: #16404733
About the project
Awarded to:
Hi Daniel, I read and understood your requirements and I have done similar projects , can share a sample with you of one such and if you like my work you can hire me to do your job. I am based in california and wil More