Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getSellPrice($db, $omc){
- $realPrice = 0; //Init variable for real price.
- $totalSells = 0; //Total number of sells.
- $arr = array();
- $query = $db->query("SELECT * FROM trans censored ;) WHERE category='sell' AND username='example'");
- $buysCount = $query->rowCount();
- if($buysCount == 0){ return "0.00"; }
- $rows = $query->fetchAll();
- foreach($rows as $row){
- $oldTime = $row['timestamp'];
- $newTime = time();
- //echo $newTime - $oldTime . "<br/>";
- if(($newTime - $oldTime) < 99999999){ //99999 is the seconds transactions are relevant
- $omcAmount = $row['amount'];
- $price = $row['pricePerOmc'];
- $nA = $buysCount*$price;
- $arr = array_merge(array($nA), $arr);
- }
- }
- return $this->standard_deviation($arr) / $buysCount;
- //return print_r($this->sd($arr));
- }
- function standard_deviation($x) {
- $summation = 0;
- $values = 0;
- $ex2 = 0;
- foreach ($x as $value) {
- if (is_numeric($value)) {
- $summation = $summation + $value;
- $values++;
- }
- }
- $mean = $summation/$values;
- foreach ($x as $value) {
- if (is_numeric($value)) {
- $ex2 = $ex2 + ($value*$value);
- }
- }
- $rawsd = ($ex2/$values) - ($mean * $mean);
- $sd = sqrt($rawsd);
- return $sd;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement