2022-12-04_00:36:29
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
2022-12-04_00:36:29