jay-jay69 | Ci-joint mon code complet !
Code :
- <?php
- require("sql.php" );
- $mydate=date("d/m/y" );
- $sqldate=date("Y-m-d" );
- echo $sqldate;
- echo "<br>";
- $m=0;
- // on nettoie la table à chaque alimentation
- $query_vidage = "TRUNCATE TABLE `master_data`;";
- $result_vidage = mysql_query($query_vidage);
- $f = file("http://www.euronext.com/search/download/pricesearchdownloadpopup.jcsv?pricesearchresults=actif&equitiesChoice=1&structuredProductType=8&requestComesFromSearchBoxParameter=true&lan=EN&resultsTitle=Warrants&cha=1812&underlying=FR0003500008*XPAR*ISIN&instrumentType=3&underlyingType=2&riskLevel=L&format=xls&formatDecimal=.&formatDate=dd/MM/yy" );
- $f = array_slice($f, 5); // Supprime l'en-tete
- foreach($f as $key => $val)
- {
- $arr = explode("\t", $val);
- $query = "INSERT INTO `master_data` ( `Instrument` , `ISIN` , `Euronext_code` , `Market` , `Symbol` , `Underlying` , `Type` , `Strike` , `Maturity` , `Currency` , `Last1` , `Last2` , `D_D-1` , `Date` , `Turnover` , `Parity` , `Trading_mode` , `Day_First` , `Day_High` , `Day_High_Date` , `Day_Low` , `Day_Low_Date` , `Change_3112` , `High_3112` , `HighDate_3112` , `Low_3112` , `LowDate_3112` , `Change_52w` , `High_52w` , `HighDate_52w` , `Low_52w` , `LowDate_52w` , `Issuer` , `Suspended` , `Suspended_Date` , `Reserved` , `Reserved_Date` ) VALUES (";
- for ($i = 0; $i < count($arr); $i++)
- {
- $query .= "'$arr[$i]'";
- if ($i < (count($arr) - 1)) $query .= ", ";
- }
- $query .= " )";
-
- //$sub = substr($query,542);
- //echo $query;
- //echo "<br>";
-
- $result = mysql_query($query);
- }
- echo "BDD alimentée par Euronext avec succés ! <br>";
- //on vide data retraitee
- $query_vidage = "TRUNCATE TABLE `data_retraitee`;";
- $result_vidage = mysql_query($query_vidage);
- $query="SELECT `Instrument`,`date`,`turnover`,`d_d-1` FROM `master_data`";
- $result=mysql_query($query);
- $num_results=mysql_num_rows($result);
- for($k=0;$k<$num_results+1;$k++)
- {
- $row=mysql_fetch_array($result);
- htmlspecialchars(stripslashes($code=$row["Instrument"]));
- htmlspecialchars(stripslashes($date=$row["date"]));
- htmlspecialchars(stripslashes($turnover=$row["turnover"]));
- htmlspecialchars(stripslashes($volume=$row["d_d-1"]));
- if ($date <> '-') {
- $date_insert = substr($date,0,8);
- //echo $date_insert;
- //echo "<br>";
- $turbo_call=0;
- $turbo_put=0;
- $turbo_procall=0;
- $turbo_proput=0;
- $CAP=0;
- $FLO=0;
- $CPP=0;
- $FLP=0;
- $BO=0;
- $warr_call=0;
- $warr_put=0;
- if ($date_insert == $mydate) {
- $pos = strpos( $code, 'TL' );
- if (is_int($pos)==TRUE) $turbo_call=$volume;
- $pos = strpos( $code, 'TS' );
- if (is_int($pos)==TRUE ) $turbo_put=$volume;
- $pos = strpos( $code, 'TPL' );
- if (is_int($pos)==TRUE ) $turbo_procall=$volume;
- $pos = strpos( $code, 'TPS' );
- if (is_int($pos)==TRUE ) $turbo_proput=$volume;
- $pos = strpos( $code, 'CAP' );
- if (is_int($pos)==TRUE ) $CAP=1;
- $pos = strpos( $code, 'FLO' );
- if (is_int($pos)==TRUE ) $FLO=1;
- $pos = strpos( $code, 'CPP' );
- if (is_int($pos)==TRUE ) $CPP=1;
- $pos = strpos( $code, 'FLP' );
- if (is_int($pos)==TRUE ) $FLP=1;
- $pos = strpos( $code, 'BO' );
- if (is_int($pos)==TRUE ) $BO=1;
- $pos = strpos( $code, '0C' );
- if (is_int($pos)==TRUE ) {if($CAP+$FLO+$CPP+$FLP+$BO=0) $warr_call=$turnover;}
- $pos = strpos( $code, '0P' );
- if (is_int($pos)==TRUE ) {if($CAP+$FLO+$CPP+$FLP+$BO=0) $warr_put=$turnover;}
- echo $code;echo">>>>>> ";echo $turbo_call;echo " / ";echo $turbo_put;echo " / ";echo $turbo_procall;echo " / ";echo $turbo_proput;echo " / ";echo $CAP;echo " / ";echo $FLO;echo " / ";echo $CPP;echo " / ";echo $FLP;echo " / ";echo $warr_call;echo " / ";echo $warr_put;echo " <br>";
- $requete_ajo="INSERT INTO `data_retraitee` VALUES
- ('$date_insert','$code','$turnover','$volume','$turbo_call','$turbo_put','$turbo_procall','$turbo_proput','$warr_call','$warr_put','$CAP','$FLO','$BO','$CPP','$FLP','0');";
- //echo $requete_ajo."<br>";
- mysql_query($requete_ajo);
- }
- }
- }
- //on vide cac40
- $query_vidage = "TRUNCATE TABLE `cac40`;";
- $result_vidage = mysql_query($query_vidage);
- $f = file("http://www.euronext.com/tools/datacentre/dataCentreDownloadExcell.jcsv?cha=3047&lan=FR&fileFormat=xls&separator=,&dateFormat=dd/MM/yy&isinCode=FR0003500008&selectedMep=1&typeDownload=3" );
- $f = array_slice($f, 3); // Supprime l'en-tete
- foreach($f as $key => $val)
- {
- $arr = explode("\t", $val);
- $query = "INSERT INTO `cac40` ( `indice` , `isin` , `code` , `marche` , `mnemo` , `cours` , `j_j-1` , `date` , `ouverture` , `max` , `heure_max` , `min` , `heure_min` , `var_annee` , `annee_haut` , `date_haut` , `annee_bas` , `date_bas` , `var_52s` , `52s_haut` , `date52s_haut` , `52s_bas` , `date52s_bas` , `hausses` , `baisses` , `neutre` )
- VALUES (";
- for ($i = 0; $i < count($arr); $i++)
- {
-
- $query .= "'$arr[$i]'";
- if ($i < (count($arr) - 1)) $query .= ", ";
- }
- $query .= " )";
-
- //$sub = substr($query,542);
- //echo $query;
- //echo "<br>";
-
- $result = mysql_query($query);
- }
- $query = "SELECT * FROM `irma14` WHERE `irma14`.`date` = '$sqldate'";
- $result=mysql_query($query);
- $num_results=mysql_num_rows($result);
- if ($num_results==0)
- {
- //echo "pas ma date<br>";
- $query = "SELECT `cours`,`ouverture`,`max`,`min`,`j_j-1` FROM `cac40`";
- $result=mysql_query($query);
- $num_results=mysql_num_rows($result);
- $row=mysql_fetch_array($result);
- htmlspecialchars(stripslashes($cours=$row["cours"]));
- htmlspecialchars(stripslashes($ouverture=$row["ouverture"]));
- htmlspecialchars(stripslashes($max=$row["max"]));
- htmlspecialchars(stripslashes($min=$row["min"]));
- htmlspecialchars(stripslashes($diff_veille=$row["j_j-1"]));
- $diff_veille=str_replace(",",".",$diff_veille);
- $test=round((1+($diff_veille/100)),4);
- $cours=str_replace(' ', '',$cours);
- $cours=str_replace(',', '.',$cours);
- //print_r($cours);
- //$cours=floatval($cours);
- //$cours=number_format($cours,4,'.',' ');
- $fermeture = $cours/$test;
- echo $cours.">".$ouverture.">".$min.">".$max.">".$fermeture.">".$test;
- }
- else {echo "vas-y fonce bonhomme<br>";}
- ?>
|
|