Завершено

Stock FIFO - Price Gain/Loss and Other gain/Loss

Hi,

I have a table as follows:

Date|TranType|Symbol|Units|Price|Brokerage|Charges|Total

2018-01-01|Buy|ABC|100|10.5|5.0|2.5|1057.5

2019-06-01|Sell|ABC|50|15|2.5|1.25|746.25

I want the FIFO result of all the buys in the above table.

Also it should be able to calculate the Price Gain/Loss, Other gain/Loss and Total Gain/Loss along with the number of days the position was held.

Project will be considered complete only if all test results are found to be as per requirement.

Квалификация: MySQL, PHP

Показать больше determining cost basis of stock sold where cost is unknown, tax method selling stocks, cost basis for dummies, how to determine cost basis of old stock, stock cost basis calculator with dividend reinvestment, cost basis formula, calculate cost basis multiple stock purchases, turbotax cost basis calculator, realtime stock price web services, fao stock price finance accounting outsourcing, adobe flex stock price, adobe flex stock chart price volume, calculate profit loss sale stock fifo, fifo price usb, stock top gain php scripts, stock typical price modified, earthlink stock ipo price, individual stock portfolio percentage gain loss, stock portfolio gain loss, gain loss stock portfolio software

О работодателе:
( 3 отзыв(-а, -ов) ) Bangalore, India

ID проекта: #20439177

Поручен:

revathi7devi

I have 4 years experience in core PHP with mysql development. I am working in customized ERP projects and CRM. In this project you have to give sammple database in sql format or excel format. I will done this in within Больше

₹1050 INR за 3 дней(-я)
(0 отзывов(-а))
0.0

5 фрилансеров(-а) в среднем готовы выполнить эту работу за ₹1920

kishanpala

Let me know i will get it done your FIFO algorithm. as per the mentioned tabular format followed by generated profit and loss value.

₹4500 INR за 2 дней(-я)
(20 отзывов(-а))
4.1
Bhavin8530227433

Hi, I have reviewed your job description and i am very confident to handle this project perfectly. I am an expert with 7+ years of vast experience in IT solutions.I will ensure that you will be 100% satisfied with my w Больше

₹1500 INR за 1 день
(1 отзыв)
0.0
idnfreelancer

Give me the table for testing purpose and I will deliver it in 2 days at most. Will only use basic PHP so there will be no version discrepancy problem. thanks.

₹1050 INR за 2 дней(-я)
(0 отзывов(-а))
0.0
inforafeesoft

Hi sir I'm a [login to view URL] Engineer Database Administrator and System Administrator Also Network Administrator I'm expert in Microsoft Office (Specially Word, Excel,Outlook,Powerpoint...etc ),Google Docs,Spreadsheet,VB. Больше

₹1500 INR за 1 день
(1 отзыв)
0.0