En cours

Macro adjustment

I have a FIFO (Trading ) spreadsheet ...

Need someone who can review the sheet/macros... make timely adjustments and be a realiable developer for future enhancments.... ( automation / Google sheet(possibly) )

For now ...

I have a FIFO (Trading ) spreadsheet ...

FIFO working ...calculating a sheet detailing stocks prices and buy / sell dates etc.... and gives a status of a type of stock after calc ... either ... SoldOUT , BoughtElsewhere or Tokens Sold or Unsold

There is also a summary sheet taking the last calculated line of each stock and creates a summarized list of all stocks status's / remaining amounts etc...

The JOB.. ... (Summary page needs adjusted so it follows 5 rules when displaying each stock.. currently 3/5 correct )

Summary sheet grouped by Stock... and stock trades can be reterived by date format filter..

Sheet has pivot table .+ vba macros..

5 rules should be followed ( see pic for 1 to 5 ) for summary sheet ... (however summary sheet should follow rule 5 to 1 in order to display stocks correctly )

See typical code for rule checks... that would need adjusted)

see example data.... (created to fall under a specific rule,,for testing purposes )

see summary sheet pic ... for testing .. the stock (exchange coloum) ... Notice... the Stock names are actually created to reflect what should be presented in the 4 colored coloums to the right).. for easy reference.. (instead of say APPLE, Microsoft, Tesla stock .. for example) .... so in doing it this way you can see rule 1,3,4 is working ok.. the others need tweaked !

NOTE : If you review the data sheet .. you can see the coloums/cells that need to be referenced by the macro to make the rules work ...

if things work out I've got more ideas for further adjustments/project work than can be done to enhance sheet ..

Compétences : Excel, Javascript, PHP, Visual Basic, Visual Basic pour les apps

en voir plus : format date lastwritetime, adobe form designer java format date time field, vba excel save format date, vba excel date format date, work log sheet hours employee date, excel macro list worksheet names sheet, zencart change date format date expected, vb6 execl format date numberformat, php import csv format date, format date infopath 2003, format date excel using format, change format date excel macro, copy data sheet filter macro trial, macro excel format date

Concernant l'employeur :
( 2 commentaires ) walkinstown, Ireland

Nº du projet : #17932838

Décerné à:

Walshie1987

Hi, I'm Chris from Sheffield, UK. I've just reviewed your project and it's something I'd love to do for you. The additions to the FIFO sheet can be done quite easily and I always support any work I do, so if you fin Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(8 Commentaires)
4.7

15 freelance font une offre moyenne de €62 pour ce travail

schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Macro adjustment. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(301 Commentaires)
7.6
techwelfare

We can review the sheet/macros...and can make timely [login to view URL] can rely on us...........We have been working in website industry for last 10 years... We are ready to [login to view URL] let us know when would you like Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(161 Commentaires)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(212 Commentaires)
6.8
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(55 Commentaires)
5.3
sloker18

I am proficient with excel macro/VBA development, I can adjust the macro as specified, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further an Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(47 Commentaires)
4.9
daniyal3214

I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data analysis, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(40 Commentaires)
5.2
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(8 Commentaires)
2.8
rIbrarahmed

hi, I am very good in data entry having good typing speed as well and also very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(6 Commentaires)
2.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(1 Évaluation)
2.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(0 Commentaires)
0.0
tatangmatanda

Has been in the BPO industry for almost 10 years with vast experience in data analytics. Proficient in MS Excel and has experience in utilizing business intelligence tools. kindly refer to my linkedin account as well ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(0 Commentaires)
0.0
Colin1M

Hi, You have clearly put a lot of work into this spreadsheet and I'm sure that you are nearly there. The logic is not overly complex and I'm sure with a quick call, we could resolve the issue. I would be happy Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0
WhiteShade

I do this kind of macros in my company all the time. It is not hard but a bit long job. And I know what you will need about that job. Because I do similar works.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0