Macro adjustment

进行中 已发布的 5 年前 货到付款
进行中 货到付款

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的应用程式

项目ID: #17977258

关于项目

1个方案 远程项目 活跃的5 年前

1 威客就此工作平均出价 ₹12777

juvigy

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

₹12777 INR 在2天内
(6条评论)
2.5