Macro adjustment

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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 ..

Excel JavaScript PHP Visual Basic Visual Basic for Apps

Project ID: #17977258

About the project

1 proposal Remote project Active 5 years ago

1 freelancer is bidding on average ₹12777 for this job

juvigy

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

₹12777 INR in 2 days
(6 Reviews)
2.5