2025-05-09, 16:48:30
Start of program...
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'admin_vsauser'@'localhost' (using password: YES) in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 98
SELECT date from `eodvsa_index` where name = 'SP500' order by date desc LIMIT 1;
Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 105
Date to process : 2025-05-09
Warning: mysqli_close() expects parameter 1 to be mysqli, bool given in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 120
Warning: mysqli_connect(): (HY000/1044): Access denied for user 'tradevs1_robie'@'162.214.228.206' to database 'tradevs1_robie_stock_us' in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 127
SELECT DISTINCT name,fname,exchange from us_class where name = 'AAPL' order by name
Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 133
line 132 n listing
Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 172
Warning: mysqli_close() expects parameter 1 to be mysqli, bool given in /home/tradevs1/public_html/robie/robie_process_comment_eod_exit_us.php on line 187
*****difference*****
count = 0match
botman
**n_bot***
line 248 = 0
2025-05-09_16:48:30
Start of program fundamental us ratings ...
SELECT date from `eodvsa_index` where name = 'SP500' order by date desc LIMIT 1;
line 103 = CREATE table `nasd_nyse_1d` as select concat(t1.date,'-',t1.symbol) Id,t1.date,t1.symbol,t1.close,t1.volume,'NASD' from nasd1y as t1 inner join fundamental_sp500_eh as t2 on t1.symbol = t2.code and t1.date = '2025-05-09' UNION select concat(t1.date,'-',t1.symbol) Id,t1.date,t1.symbol,t1.close,t1.volume,'NYSE' from nyse1y as t1 inner join fundamental_sp500_eh as t2 on t1.symbol = t2.code and t1.date = '2025-05-09' order by symbol;Array ( [0] => Basic Materials [1] => Communication Services [2] => Consumer Cyclical [3] => Consumer Defensive [4] => Energy [5] => Financial Services [6] => Healthcare [7] => Industrial Goods [8] => Industrials [9] => Other [10] => Real Estate [11] => Technology [12] => Utilities ) Array ( [0] => 32.50 [1] => 51.27 [2] => 56.75 [3] => 28.50 [4] => 102.44 [5] => 21.90 [6] => 48.52 [7] => 12.65 [8] => 33.31 [9] => 24.52 [10] => 73.33 [11] => 51.61 [12] => 28.25 ) Array ( [0] => 1.66 [1] => 1.37 [2] => 0.87 [3] => 2.08 [4] => 2.95 [5] => 1.94 [6] => 0.81 [7] => 4.54 [8] => 1.30 [9] => 351.52 [10] => 2.77 [11] => 1.05 [12] => 3.11 ) Array ( [0] => 0.18 [1] => 0.20 [2] => 0.32 [3] => 0.47 [4] => 0.03 [5] => 0.19 [6] => 0.29 [7] => 0.14 [8] => 0.29 [9] => 0.00 [10] => 0.13 [11] => 0.33 [12] => 0.10 ) Date to process : 2025-05-09
SELECT t3.name,t3.code,t3.syariah,t3.main_industry,t4.close,t4.volume,t3.eps,t3.pe,t3.diy,t3.book_value,t3.market_cap,t3.roe,t3.url,t3.exchange,t3.industry,t3.shareholder_date,t3.shareholder_name from fundamental_sp500_eh as t3 inner join nasd_nyse_1d as t4 where t3.code = t4.symbol and t4.date = '2025-05-09' order by code;line 46 count = 0
success
2025-05-09_16:48:37
US Robie List rec insertion = 0, update = 0, date = 2025-05-09
2025-05-09_16:48:37
Successful completion of program...