Excel/spreadsheets DASHBOARD. Stock Trading Portfolio

Do you want to work with me to continously develop my trading dashboard?

I have created a excel/googel spreadsheets program analysing +100 trading strategies + 20 assets,

Data consists of +10k buy/sells.

Input: Strategy, Asset, date, time, buy/sell, qty.

From there I'm analysing +30 KPIs, financial formulas, multiple charts (equity curve, rolling KPIS ex risk, profitability, max gain), I want to further add new features and display them in a report of +40 pages that updates automatically.

(You do not need financial formulas/trading experience) only good at solving math and creating custom formulas/programs. I have a degree in enginering and management and will help you find solutions and formulas when stuck, (available daily if needed). You need to be a good developer though, flexible to collaborate on my preferences, filtering skills, visualising large data sets, and create advanced excel formulas. Simple pivot charts will not be enough.

- Contact will only be through videomeetings, working together online when needed simultaniously. I want to be able to have a close colaboration with my developer and rather want you to ask for help instead of trying to figure it all out by yourself, pay is of course included in meetings.

I have already put lots of hours of work into this dashboard, but there are still many hours of improvement left if you want to help. So if you want to start a longterm partnership and learn to collaborate with me and become familiar with the dataset I have lots of ideas and programs i need help with.

Future development nearby are, displaying the data in a report +40 pages. Comparisons between stratgies, assets, timeframes, new charts, correlations, randomizing data, automations, filtering strategies, realtime stock data etc.

Example dashboards pictures below:

---------------------------------------------------------------------

Automatic descripton from freelancer below:

I am seeking a freelancer to develop an Excel/spreadsheets dashboard for my stock trading portfolio. The ideal candidate will have extensive experience data visualization.

Features:

- Performance analysis to track and analyze my portfolio's returns and risk

- Portfolio tracking to monitor my holdings and positions

- Risk management tools to help me make informed investment decisions

Dashboard Format:

- A combination of charts and graphs, as well as tables and data

- The dashboard should be visually appealing and easy to understand

Level of Customization:

- Advanced customization is needed to ensure the dashboard meets my specific needs and preferences

Ideal Skills and Experience:

- Proficient in Excel/spreadsheet software

- Strong background in data visualization and math (I can help you with financial analysis)

- Experience in designing customized dashboards, programs in excel

- Excellent communication skills to collaborate and ensure the project meets my expectations.

Excel Visual Basic Traitement de Données Visual Basic pour les apps Développement de logiciel

Nº du projet : #36392078

À propos du projet