2025-05-09_18:24:02
Start of program fundamental us ratings ...
SELECT date from `eodvsa_index` where name = 'SP500' order by date desc LIMIT 1;
Notice: Undefined variable: daterequired in /home/tradevs1/public_html/robie/fundamental_us_process_ratings_avg.php on line 100
Notice: Undefined variable: daterequired in /home/tradevs1/public_html/robie/fundamental_us_process_ratings_avg.php on line 102
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 = ''
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 = '' 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 )
Notice: Undefined variable: daterequired in /home/tradevs1/public_html/robie/fundamental_us_process_ratings_avg.php on line 143
Date to process :
Notice: Undefined variable: daterequired in /home/tradevs1/public_html/robie/fundamental_us_process_ratings_avg.php on line 148
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 = '' order by code;line 46 count = 0
success
2025-05-09_18:24:02