It looks like you're new here. If you want to get involved, click one of these buttons!
Hello there want to program database app that is related to stocks traded in stock market. There may be 500 stocks that may be bought and sold several times a day at different rates and different quantities need to add all buys of particular stock average its rate then add all sells of particular stock get its selling average next to subtract sells from buy to get net profit or loss. this has to done for all the stocks and report needs to be prepared for all stocks with buy qty buy avg price sell qty sell average price and profit loss from it and data from next date be merged to get combined report for specific dates (files to be uploaded will be available and that too in fixed field format).