Tamamlanmış

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.

Beceriler: MySQL, PHP

Daha fazlasını gör: 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

İşveren Hakkında:
( 3 değerlendirme ) Bangalore, India

Proje NO: #20439177

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 1050%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 5 freelancer ortalamada ₹1920 teklif veriyor

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 in 2 gün içinde
(20 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(1 Yorum)
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 in 2 gün içinde
(0 Değerlendirme)
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. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(1 Yorum)
0.0