In Progress

Macro adjustment

I have a FIFO (Trading ) spreadsheet ...

Need someone who can review the sheet/macros make timely adjustments and be a reliable developer for future enhancements.... ( 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 cal ... either ... Sold Out , Bought Elsewhere or tokens sold or [login to view URL] 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 retrieved by date format filter..

Sheet has pivot table .+ vb a 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 column) ... Notice... the Stock names are actually created to reflect what should be presented in the 4 colored columns 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 columns/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 ..

Skills: Excel, Javascript, PHP, Visual Basic, Visual Basic for Apps

See more: macros, best macro calculator, tracking macros, macros for cutting, macro adjustment calculator, macros for weight loss female, macro calculator, adjusting macros on keto, outlook macro extract specific body, configuration specific properties solidworks macro, macro paste data specific locations, solidworks macro configuration specific, create configuration specific properties macro solidworks, excel macro print specific page, macro save emails specific folder, change format date excel macro, copy specific excel files folder folder macro, outlook macro forward message specific recipient, excel find fall within specific radius, excel macro print specific page sheet

About the Employer:
( 0 reviews ) Nagina, India

Project ID: #17977258

Awarded to:

juvigy

Dear Sir/Madam, Please consider my offer for this project. BR, Stoyan Delchev ........................................................................

₹12777 INR in 2 days
(6 Reviews)
2.5