Find Jobs
Hire Freelancers

Modifying a Trading Journal on Excel

$250-750 AUD

Cerrado
Publicado hace más de 6 años

$250-750 AUD

Pagado a la entrega
I am a day trader on the stock market and looking to journal and keep statistics on my trades. A friend of mine has sent me an excel spreadsheet (attached) that does this, however we use different trading platforms. I am looking to change the data input of the spreadsheet so it is compatible with my trades extracted from my platform as well as making a few other changes. I have attached the spreadsheet as well as other files. The sections in the spreadsheet that I would like to be changed are Raw Data, Settings and Meta Data. These are interconnected so hoping that changes made flow across to the weekly dashboard/trade log and essentially present the data in the current format. Raw Data Please see the format in Book 1 - this is how my trades are extracted from my platform. They are ordered by the Ord# column and then sorted by date and time - from earliest trade of the day to the last. This input obviously is most important as it flows through to the trade log, weekly dashboard etc. Settings/Meta data Please see the “metadata dropdowns” file attached. I would like the Metadata dropdowns section to be presented like that with 20 rows for me to fill in. This section flows through to the 'Metadata' tab. My end goal would be for the Metadata Analytics to show the same statistics as they currently do for a ‘Momo High – News Play’ or an ‘Open match – Commodity move’ etc Finally, you will notice across the spreadsheet that 'Commissions' are calculated. Commission is generally worked out as a percentage of the total turnover. EG, if 10,000 shares of XYZ are bought and sold at $1 per share – the total turnover is $20,000. I am paying 0.0385% commission and hence $7.70 commission fee ($20,000 x 0.000385). I am unsure what commission is currently being calculated on the existing spreadsheet. To fix this issue, I am thinking a singular cell in the settings tab, where i can enter the commission rate (in case it changes in future) and this flows across to all sections in the spreadsheet. [REMOVED BY [login to view URL] ADMIN]
ID del proyecto: 14493677

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
16 freelancers están ofertando un promedio de $413 AUD por este trabajo
Avatar del usuario
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
$526 AUD en 4 días
5,0 (799 comentarios)
8,7
8,7
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement. Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $500 AUD - payment once project delivered
$500 AUD en 7 días
4,9 (372 comentarios)
8,1
8,1
Avatar del usuario
I can work on it. Do let me know over chat.
$250 AUD en 2 días
4,5 (35 comentarios)
5,3
5,3
Avatar del usuario
Hello, I can modify this trading journal for you, and include things such as macros to correctly order the raw data into the correct order. Thanks, Arran Relevant Skills and Experience 3 years as a data analyst, Excel, VBA, SQL, Certified Microsoft Office Specialist Proposed Milestones $500 AUD - Project Completion Are there any particular time frames on this project?
$500 AUD en 7 días
5,0 (32 comentarios)
4,4
4,4
Avatar del usuario
With over 9 years of experience in accounts and finance and Microsoft Excel, I am capable enough to meet your requirements.
$495 AUD en 2 días
4,9 (12 comentarios)
3,9
3,9
Avatar del usuario
Hello Greetings, After reading your project description, I know I can help you! I assures you of high quality Business card and graphic designing. We have over 10 years of design experience, and we specialize in logo, corporate identity/stationery design. We can start working right away on your project. I have some queries. Please initiate the chat/private message so that we can connect with each other and discuss your project in more details before finalizing the bid. We are here to provide you the perfect design you have been looking for. Cent percent customer satisfaction is what we thrive to achieve.
$555 AUD en 1 día
3,6 (2 comentarios)
4,0
4,0
Avatar del usuario
I have gone through your complete requirement and want to discuss the project further with you. Please Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end. Thanks!
$833 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Australia
0,0
0
Miembro desde jun 28, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.