PHPize Online / SQLize Online  /  SQLtest Online

<?php // Simulate file upload $csv_data = "Date,Open,High,Low,Close,Volume 2023-10-01,150,155,148,152,100000 2023-10-02,152,158,151,157,120000 2023-10-03,157,160,156,159,110000 2023-10-04,159,162,158,161,130000 2023-10-05,161,165,160,164,140000"; // Convert CSV data to an array $data = array_map('str_getcsv', explode("\n", $csv_data)); $headers = array_shift($data); // Remove headers // Extract closing prices $closing_prices = array_column($data, 4); // Assuming Close is the 5th column // Calculate Simple Moving Average (SMA) for prediction $sma_period = 5; // Adjust as needed $sma = array_sum(array_slice($closing_prices, -$sma_period)) / $sma_period; // Predict next day's price (simple example) $last_price = end($closing_prices); $predicted_price = $last_price + ($last_price - $sma); // Buy/Sell recommendation if ($predicted_price > $last_price) { $recommendation = "Buy"; $class = "buy"; } else { $recommendation = "Sell"; $class = "sell"; } // Display results echo '<div class="spp-results ' . $class . '">'; echo '<h3>Prediction Results</h3>'; echo '<p>Last Closing Price: ' . $last_price . '</p>'; echo '<p>Predicted Next Day Price: ' . $predicted_price . '</p>'; echo '<p>Recommendation: <strong>' . $recommendation . '</strong></p>'; echo '</div>'; ?>