Ditutup

Modifying a Trading Journal on Excel

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 [url removed, login to view] ADMIN]

Kemahiran: Excel

Lihat lebih lanjut: excel Do some Excel Work aviation, excel Do some Excel Work, i need an accountant to come to my store and fix my problems, design excel cashflow forecast for my new business plan, vba excel journal, excel options trading spreadsheet, excel journal accounting, excel vba trading, create excel application trading, excel forex trading calculator, excel program trading, excel orders trading, free excel futures trading log, excel options trading, excel backtest trading, excel problem trading concern, excel based trading software, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file

Tentang Majikan:
( 0 ulasan ) Australia

ID Projek: #14493677

18 pekerja bebas membida secara purata $397 untuk pekerjaan ini

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view] Lagi

$526 AUD dalam 4 hari
(475 Ulasan)
8.0
schoudhary1553

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 e Lagi

$500 AUD dalam 7 hari
(171 Ulasan)
6.8
$250 AUD dalam 10 hari
(1 Ulasan)
4.0
aimefx

Hi, I am Ms Excel expert and professional Forex Trader, Being trader myself I can complete your project 100% accurately. If you are interested communicate me on chat. Relevant Skills and Experience You can check some Lagi

$250 AUD dalam 3 hari
(4 Ulasan)
3.5
awaisjahangir25

I can work on it. Do let me know over chat.

$250 AUD dalam 2 hari
(8 Ulasan)
3.7
$250 AUD dalam 10 hari
(6 Ulasan)
3.6
arranmercer

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, Ex Lagi

$500 AUD dalam 7 hari
(5 Ulasan)
3.5
avidusman

With over 9 years of experience in accounts and finance and Microsoft Excel, I am capable enough to meet your requirements.

$495 AUD dalam 2 hari
(4 Ulasan)
3.2
bhavnishvw

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, Lagi

$555 AUD dalam sehari
(1 Ulasan)
4.0
$250 AUD dalam 5 hari
(6 Ulasan)
2.6
$300 AUD dalam 5 hari
(7 Ulasan)
3.1
$600 AUD dalam 7 hari
(1 Ulasan)
0.7
$250 AUD dalam sehari
(3 Ulasan)
0.4
wwwmukul

. I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. Relevant Skills and Experience Excel Proposed Milestones $277 AUD - milestone

$277 AUD dalam 8 hari
(0 Ulasan)
0.0
RubyOnRail

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 Lagi

$833 AUD dalam 10 hari
(0 Ulasan)
0.0
$555 AUD dalam 3 hari
(0 Ulasan)
0.0
$250 AUD dalam 10 hari
(0 Ulasan)
0.0
RushService

Feel fee to contact me [url removed, login to view] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [url removed, login to view] payment only after the work [url removed, login to view] yo Lagi

$250 AUD dalam 10 hari
(1 Ulasan)
0.0