Function to compute the avg price of stock in PHP

MQL5 Diğer

İş Gereklilikleri

Hello, 

I need a PHP programmer who can write a function that calculates the avg weighted price paid per symbol. Here is a sample table.

TID   |DATE      |TIME    |SYMBOL|SIDE|QUANTITY |PRICE    |OPENPOSITION

339791|2014-11-14|12:45:25|TMO |Buy |  -900.00|15.920000|        -900

339780|2014-11-21|10:54:37|TMO |Sell|   900.00|16.650000|           0

339775|2014-11-24|14:52:59|GOOG |Buy | -1500.00|16.950000|       -1500

339725|2017-01-20|14:54:26|GOOG |Sell|  1500.00|17.280000|           0

339662|2017-02-03|10:43:31|ABEV3 |Buy | -5900.00|17.020000|       -5900

339661|2017-02-03|11:44:57|ABEV3 |Buy | -5900.00|17.229492|      -11800

339655|2017-02-03|12:37:08|ABEV3 |Sell| 10800.00|17.250000|       -1000

339528|2017-02-15|11:04:07|ABEV3 |Buy |-15000.00|17.580000|      -16000

From the example above, the ABEV3 transactions have an avg price of 17.56

The function will load up the transactions from a mysql db, compute each avg price and save to an avgprice col.

I won't go over the math because I expect someone experienced with programming financial apps.

Any questions? Just let me know.


Yanıtlandı

1
Geliştirici 1
Derecelendirme
(229)
Projeler
339
49%
Arabuluculuk
21
5% / 33%
Süresi dolmuş
24
7%
Serbest
2
Geliştirici 2
Derecelendirme
(54)
Projeler
64
42%
Arabuluculuk
5
20% / 60%
Süresi dolmuş
4
6%
Serbest
3
Geliştirici 3
Derecelendirme
(25)
Projeler
36
17%
Arabuluculuk
14
14% / 57%
Süresi dolmuş
3
8%
Serbest
4
Geliştirici 4
Derecelendirme
(258)
Projeler
395
28%
Arabuluculuk
69
19% / 49%
Süresi dolmuş
120
30%
Serbest
5
Geliştirici 5
Derecelendirme
Projeler
0
0%
Arabuluculuk
0
Süresi dolmuş
0
Serbest
Benzer siparişler
Dear Colleagues, I am currently seeking the assistance of an experienced professional who can help me integrate my TradingView alerts with Interactive Brokers in order to execute live trades automatically. If you have the expertise in setting up such an automation or know someone who does, I would greatly appreciate your support. Please feel free to reach out to me if you can assist with this project or if you need
I am in search of a driven and results-oriented individual to promote my forex trading signals under the "Elevated Tradinghub" brand. The perfect candidate will have a strong background in digital marketing, particularly within the finance and trading sectors. Your main goal will be to expand my follower base by effectively promoting my signals across a variety of platforms, such as social media, trading forums, and
Connect from Mt4 via binary derive account api. I have a bot. You need to convert the bot to an indicator. After converting I need to connect with my binary deriv through api. I want to trade my derivative binary account through mt4. If anyone can setup via API then contact me
I need a way of viewing Renko Charts in MT5. Only apply if you have experience with Renko Charts. And how you would tackle this project. Timeline is less than 5 days
Hey greetings. Am in need of a tradingview developer that can add a simple alert to my existing tradingview indicator with a simple conditions. Kindly bid for the project if it is what you can do for me and let proceed
Hello, ,I will briefly explain what I need, I would like to know if you can make me an indicator for cTrader, for the forex market, that can count the candles starting from the first candle starting at 00:00. Obviously in a 5 minute TF the candle count will be much higher than that of the H1 TF, also I use 250/500/1000 ticks charts, so this indicator should also count the candles of this type of charts I would like a
I have access to a paid/subscription TradingView Strategy but I'am unable to see the script/code. I'm looking for someone who is able to reverse engineer this Strategy and create a new version that I would have full access to. I believe this would be using PineScript. If you've done this sort of thing before, please message me. $400 is my budget for this project on completion
I need a professional who have the full knowledge in Ctrader and I want to add new idea for my ctrader https://ctrader.com/algos/indicators/show/3444/ Let me know if this is what you can do and the price to get it done. Thanks
We are looking for an experienced MQL5 developer to create a custom drawing tool for MetaTrader 5. The tool should include the following functionalities: - Creation of 4 equally spaced horizontal lines on the chart. - A trend-line that measures the price movement. - Interactive buttons to control the drawing of these objects. - The tool should be user-friendly and efficiently handle chart events. **Requirements:** -
Bid-ask spread trader 30 - 75 USD
I'm looking for bid, ask order buttons with plus and minus. Market order buy and sell buttons. Close sll, Reverse button. (Just the order button pad). The Platform I uses is R Trader Pro, Send a message if you can do it

Proje bilgisi

Bütçe
20 USD
Geliştirici için
18 - 18 USD
Son teslim tarihi
to 2 gün