2023-04-02, 10:19:32
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 : 2023-04-02

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 = 0
match
botman
**n_bot***
line 248 = 0
2023-04-02_10:19:32 
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 = '2023-04-02'
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 = '2023-04-02' 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 : 2023-04-02
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 = '2023-04-02' order by code;
line 46 count = 0
success
2023-04-02_10:19:39 
US Robie List rec insertion = 0, update = 0, date = 2023-04-02


2023-04-02_10:19:39 
Successful completion of program...