CHARTROOM STOCKS CRAWLER
DATA UPDATED 2023-12-02
ATTENTION - Data collection update routine needs work - incomplete date ranges etc. This version update Dec 1, 2018
DEBUG tickercount=318


TICKER=IPHI
EARLIEST EXISTING DATA DATE=2019-04-18
LATEST EXISTING DATA DATE=2023-07-27
Ticker IPHI has data and earliest date (2019-04-18 is at least 365 calendar days ago.
Regular update for ticker IPHI starts 2023-07-27 up through today date (2023-12-02
Ticker IPHI regular fetch request begins with 1690430400
Ticker IPHI regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/IPHI/history?period1=1690430400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.306033 size download:36 connect time:0.233028
NO DATA FOUND FOR stock history data as of December 2nd, 2023 -- 8:24am:
Key phrase not found =data-test="historical-prices"

not found - file dump: Found. Redirecting to /lookup?s=IPHI
TICKER IS IPHI AND SID IS 190
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

latest date is 2023-07-27
earliest date is 2019-04-18
UPDATE master SET date_earliest = '2019-04-18', value_earliest = '46.7000', total_date_vals = '1045' WHERE sid = 190
UPDATE ROUTINE COMPLETE FOR IPHI
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=ISRG
EARLIEST EXISTING DATA DATE=2018-03-09
LATEST EXISTING DATA DATE=2023-11-30
Ticker ISRG has data and earliest date (2018-03-09 is at least 365 calendar days ago.
Regular update for ticker ISRG starts 2023-11-30 up through today date (2023-12-02
Ticker ISRG regular fetch request begins with 1701320400
Ticker ISRG regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/ISRG/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.57233 size download:1431108 connect time:0.003173
ticker:ISRG
Collecting for date:2023-12-01
ticker:ISRG
Collecting for date:2023-11-30
ticker:ISRG
Collecting for date:lose-
TICKER IS ISRG AND SID IS 111
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED ISRG for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2018-03-09
UPDATE master SET date_earliest = '2018-03-09', value_earliest = '440.4600', total_date_vals = '1444' WHERE sid = 111
UPDATE ROUTINE COMPLETE FOR ISRG
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=JBLU
EARLIEST EXISTING DATA DATE=2019-09-24
LATEST EXISTING DATA DATE=2023-11-30
Ticker JBLU has data and earliest date (2019-09-24 is at least 365 calendar days ago.
Regular update for ticker JBLU starts 2023-11-30 up through today date (2023-12-02
Ticker JBLU regular fetch request begins with 1701320400
Ticker JBLU regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/JBLU/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.844944 size download:1418210 connect time:0.002679
ticker:JBLU
Collecting for date:2023-12-01
ticker:JBLU
Collecting for date:2023-11-30
ticker:JBLU
Collecting for date:lose-
TICKER IS JBLU AND SID IS 216
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED JBLU for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-09-24
UPDATE master SET date_earliest = '2019-09-24', value_earliest = '16.6300', total_date_vals = '1056' WHERE sid = 216
UPDATE ROUTINE COMPLETE FOR JBLU
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=JNJ
EARLIEST EXISTING DATA DATE=2017-12-01
LATEST EXISTING DATA DATE=2023-11-30
Ticker JNJ has data and earliest date (2017-12-01 is at least 365 calendar days ago.
Regular update for ticker JNJ starts 2023-11-30 up through today date (2023-12-02
Ticker JNJ regular fetch request begins with 1701320400
Ticker JNJ regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/JNJ/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.733465 size download:1426597 connect time:0.002678
ticker:JNJ
Collecting for date:2023-12-01
ticker:JNJ
Collecting for date:2023-11-30
ticker:JNJ
Collecting for date:lose-
TICKER IS JNJ AND SID IS 6
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED JNJ for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2017-12-01
UPDATE master SET date_earliest = '2017-12-01', value_earliest = '139.9800', total_date_vals = '1510' WHERE sid = 6
UPDATE ROUTINE COMPLETE FOR JNJ
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=JPM
EARLIEST EXISTING DATA DATE=2017-12-08
LATEST EXISTING DATA DATE=2023-11-30
Ticker JPM has data and earliest date (2017-12-08 is at least 365 calendar days ago.
Regular update for ticker JPM starts 2023-11-30 up through today date (2023-12-02
Ticker JPM regular fetch request begins with 1701320400
Ticker JPM regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/JPM/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.600635 size download:1421389 connect time:0.002361
ticker:JPM
Collecting for date:2023-12-01
ticker:JPM
Collecting for date:2023-11-30
ticker:JPM
Collecting for date:lose-
TICKER IS JPM AND SID IS 39
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED JPM for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2017-12-08
UPDATE master SET date_earliest = '2017-12-08', value_earliest = '105.9300', total_date_vals = '1505' WHERE sid = 39
UPDATE ROUTINE COMPLETE FOR JPM
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=JWN
EARLIEST EXISTING DATA DATE=2018-07-10
LATEST EXISTING DATA DATE=2023-11-30
Ticker JWN has data and earliest date (2018-07-10 is at least 365 calendar days ago.
Regular update for ticker JWN starts 2023-11-30 up through today date (2023-12-02
Ticker JWN regular fetch request begins with 1701320400
Ticker JWN regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/JWN/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.833314 size download:1424844 connect time:0.00221
ticker:JWN
Collecting for date:2023-12-01
ticker:JWN
Collecting for date:2023-11-30
ticker:JWN
Collecting for date:lose-
TICKER IS JWN AND SID IS 153
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED JWN for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2018-07-10
UPDATE master SET date_earliest = '2018-07-10', value_earliest = '52.0900', total_date_vals = '1360' WHERE sid = 153
UPDATE ROUTINE COMPLETE FOR JWN
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=KHC
EARLIEST EXISTING DATA DATE=2018-07-10
LATEST EXISTING DATA DATE=2023-11-30
Ticker KHC has data and earliest date (2018-07-10 is at least 365 calendar days ago.
Regular update for ticker KHC starts 2023-11-30 up through today date (2023-12-02
Ticker KHC regular fetch request begins with 1701320400
Ticker KHC regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/KHC/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.46431 size download:1425085 connect time:0.003059
ticker:KHC
Collecting for date:2023-12-01
ticker:KHC
Collecting for date:2023-11-30
ticker:KHC
Collecting for date:2023-11-30
ticker:KHC
Collecting for date:lose-
TICKER IS KHC AND SID IS 149
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED KHC for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2018-07-10
UPDATE master SET date_earliest = '2018-07-10', value_earliest = '64.0000', total_date_vals = '1360' WHERE sid = 149
UPDATE ROUTINE COMPLETE FOR KHC
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=KLAC
EARLIEST EXISTING DATA DATE=2020-09-28
LATEST EXISTING DATA DATE=2023-11-30
Ticker KLAC has data and earliest date (2020-09-28 is at least 365 calendar days ago.
Regular update for ticker KLAC starts 2023-11-30 up through today date (2023-12-02
Ticker KLAC regular fetch request begins with 1701320400
Ticker KLAC regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/KLAC/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.609117 size download:1424254 connect time:0.002814
ticker:KLAC
Collecting for date:2023-12-01
ticker:KLAC
Collecting for date:2023-11-30
ticker:KLAC
Collecting for date:lose-
TICKER IS KLAC AND SID IS 285
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED KLAC for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2020-09-28
UPDATE master SET date_earliest = '2020-09-28', value_earliest = '193.2500', total_date_vals = '801' WHERE sid = 285
UPDATE ROUTINE COMPLETE FOR KLAC
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=KMB
EARLIEST EXISTING DATA DATE=2017-12-04
LATEST EXISTING DATA DATE=2023-11-30
Ticker KMB has data and earliest date (2017-12-04 is at least 365 calendar days ago.
Regular update for ticker KMB starts 2023-11-30 up through today date (2023-12-02
Ticker KMB regular fetch request begins with 1701320400
Ticker KMB regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/KMB/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.795816 size download:1426350 connect time:0.002661
ticker:KMB
Collecting for date:2023-12-01
ticker:KMB
Collecting for date:2023-11-30
ticker:KMB
Collecting for date:lose-
TICKER IS KMB AND SID IS 17
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED KMB for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2017-12-04
UPDATE master SET date_earliest = '2017-12-04', value_earliest = '123.1100', total_date_vals = '1509' WHERE sid = 17
UPDATE ROUTINE COMPLETE FOR KMB
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=KNBE
EARLIEST EXISTING DATA DATE=2021-04-22
LATEST EXISTING DATA DATE=2023-11-30
Ticker KNBE has data and earliest date (2021-04-22 is at least 365 calendar days ago.
Regular update for ticker KNBE starts 2023-11-30 up through today date (2023-12-02
Ticker KNBE regular fetch request begins with 1701320400
Ticker KNBE regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/KNBE/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.076218 size download:36 connect time:0.002883
NO DATA FOUND FOR stock history data as of December 2nd, 2023 -- 8:24am:
Key phrase not found =data-test="historical-prices"

not found - file dump: Found. Redirecting to /lookup?s=KNBE
TICKER IS KNBE AND SID IS 292
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED KNBE for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2021-04-22
UPDATE master SET date_earliest = '2021-04-22', value_earliest = '24.1400', total_date_vals = '653' WHERE sid = 292
UPDATE ROUTINE COMPLETE FOR KNBE
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=KO
EARLIEST EXISTING DATA DATE=2018-03-22
LATEST EXISTING DATA DATE=2023-11-30
Ticker KO has data and earliest date (2018-03-22 is at least 365 calendar days ago.
Regular update for ticker KO starts 2023-11-30 up through today date (2023-12-02
Ticker KO regular fetch request begins with 1701320400
Ticker KO regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/KO/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.59579 size download:1430476 connect time:0.001893
ticker:KO
Collecting for date:2023-12-01
ticker:KO
Collecting for date:2023-11-30
ticker:KO
Collecting for date:2023-11-30
ticker:KO
Collecting for date:lose-
TICKER IS KO AND SID IS 116
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED KO for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2018-03-22
UPDATE master SET date_earliest = '2018-03-22', value_earliest = '42.7600', total_date_vals = '1435' WHERE sid = 116
UPDATE ROUTINE COMPLETE FOR KO
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LEN
EARLIEST EXISTING DATA DATE=2019-09-30
LATEST EXISTING DATA DATE=2023-11-30
Ticker LEN has data and earliest date (2019-09-30 is at least 365 calendar days ago.
Regular update for ticker LEN starts 2023-11-30 up through today date (2023-12-02
Ticker LEN regular fetch request begins with 1701320400
Ticker LEN regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LEN/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.52859 size download:1417018 connect time:0.0027
ticker:LEN
Collecting for date:2023-12-01
ticker:LEN
Collecting for date:2023-11-30
ticker:LEN
Collecting for date:lose-
TICKER IS LEN AND SID IS 226
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LEN for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-09-30
UPDATE master SET date_earliest = '2019-09-30', value_earliest = '55.8500', total_date_vals = '1052' WHERE sid = 226
UPDATE ROUTINE COMPLETE FOR LEN
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LIT
EARLIEST EXISTING DATA DATE=2019-03-13
LATEST EXISTING DATA DATE=2023-11-30
Ticker LIT has data and earliest date (2019-03-13 is at least 365 calendar days ago.
Regular update for ticker LIT starts 2023-11-30 up through today date (2023-12-02
Ticker LIT regular fetch request begins with 1701320400
Ticker LIT regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LIT/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.579718 size download:1371983 connect time:0.002537
ticker:LIT
Collecting for date:2023-12-01
ticker:LIT
Collecting for date:2023-11-30
ticker:LIT
Collecting for date:lose-
TICKER IS LIT AND SID IS 185
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LIT for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-03-13
UPDATE master SET date_earliest = '2019-03-13', value_earliest = '28.6600', total_date_vals = '1191' WHERE sid = 185
UPDATE ROUTINE COMPLETE FOR LIT
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LLY
EARLIEST EXISTING DATA DATE=2021-04-05
LATEST EXISTING DATA DATE=2023-11-30
Ticker LLY has data and earliest date (2021-04-05 is at least 365 calendar days ago.
Regular update for ticker LLY starts 2023-11-30 up through today date (2023-12-02
Ticker LLY regular fetch request begins with 1701320400
Ticker LLY regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LLY/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.738138 size download:1420353 connect time:0.00224
ticker:LLY
Collecting for date:2023-12-01
ticker:LLY
Collecting for date:2023-11-30
ticker:LLY
Collecting for date:lose-
TICKER IS LLY AND SID IS 302
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LLY for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2021-04-05
UPDATE master SET date_earliest = '2021-04-05', value_earliest = '184.8900', total_date_vals = '672' WHERE sid = 302
UPDATE ROUTINE COMPLETE FOR LLY
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LOW
EARLIEST EXISTING DATA DATE=2019-09-30
LATEST EXISTING DATA DATE=2023-11-30
Ticker LOW has data and earliest date (2019-09-30 is at least 365 calendar days ago.
Regular update for ticker LOW starts 2023-11-30 up through today date (2023-12-02
Ticker LOW regular fetch request begins with 1701320400
Ticker LOW regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LOW/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.549074 size download:1426862 connect time:0.002834
ticker:LOW
Collecting for date:2023-12-01
ticker:LOW
Collecting for date:2023-11-30
ticker:LOW
Collecting for date:lose-
TICKER IS LOW AND SID IS 223
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LOW for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-09-30
UPDATE master SET date_earliest = '2019-09-30', value_earliest = '109.9600', total_date_vals = '1052' WHERE sid = 223
UPDATE ROUTINE COMPLETE FOR LOW
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LRCX
EARLIEST EXISTING DATA DATE=2018-01-25
LATEST EXISTING DATA DATE=2023-11-30
Ticker LRCX has data and earliest date (2018-01-25 is at least 365 calendar days ago.
Regular update for ticker LRCX starts 2023-11-30 up through today date (2023-12-02
Ticker LRCX regular fetch request begins with 1701320400
Ticker LRCX regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LRCX/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.648435 size download:1426080 connect time:0.003259
ticker:LRCX
Collecting for date:2023-12-01
ticker:LRCX
Collecting for date:2023-11-30
ticker:LRCX
Collecting for date:lose-
TICKER IS LRCX AND SID IS 100
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LRCX for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2018-01-25
UPDATE master SET date_earliest = '2018-01-25', value_earliest = '199.2500', total_date_vals = '1474' WHERE sid = 100
UPDATE ROUTINE COMPLETE FOR LRCX
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LTHM
EARLIEST EXISTING DATA DATE=2019-10-14
LATEST EXISTING DATA DATE=2023-11-30
Ticker LTHM has data and earliest date (2019-10-14 is at least 365 calendar days ago.
Regular update for ticker LTHM starts 2023-11-30 up through today date (2023-12-02
Ticker LTHM regular fetch request begins with 1701320400
Ticker LTHM regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LTHM/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.752183 size download:1427358 connect time:0.002692
ticker:LTHM
Collecting for date:2023-12-01
ticker:LTHM
Collecting for date:2023-11-30
ticker:LTHM
Collecting for date:lose-
TICKER IS LTHM AND SID IS 234
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LTHM for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-10-14
UPDATE master SET date_earliest = '2019-10-14', value_earliest = '6.9500', total_date_vals = '1042' WHERE sid = 234
UPDATE ROUTINE COMPLETE FOR LTHM
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=LUV
EARLIEST EXISTING DATA DATE=2019-09-25
LATEST EXISTING DATA DATE=2023-11-30
Ticker LUV has data and earliest date (2019-09-25 is at least 365 calendar days ago.
Regular update for ticker LUV starts 2023-11-30 up through today date (2023-12-02
Ticker LUV regular fetch request begins with 1701320400
Ticker LUV regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/LUV/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.548716 size download:1420720 connect time:0.007333
ticker:LUV
Collecting for date:2023-12-01
ticker:LUV
Collecting for date:2023-11-30
ticker:LUV
Collecting for date:lose-
TICKER IS LUV AND SID IS 222
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED LUV for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-09-25
UPDATE master SET date_earliest = '2019-09-25', value_earliest = '54.8200', total_date_vals = '1055' WHERE sid = 222
UPDATE ROUTINE COMPLETE FOR LUV
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=MA
EARLIEST EXISTING DATA DATE=2017-12-26
LATEST EXISTING DATA DATE=2023-11-30
Ticker MA has data and earliest date (2017-12-26 is at least 365 calendar days ago.
Regular update for ticker MA starts 2023-11-30 up through today date (2023-12-02
Ticker MA regular fetch request begins with 1701320400
Ticker MA regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/MA/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.663515 size download:1422680 connect time:0.00281
ticker:MA
Collecting for date:2023-12-01
ticker:MA
Collecting for date:2023-11-30
ticker:MA
Collecting for date:lose-
TICKER IS MA AND SID IS 87
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED MA for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2017-12-26
UPDATE master SET date_earliest = '2017-12-26', value_earliest = '151.2800', total_date_vals = '1494' WHERE sid = 87
UPDATE ROUTINE COMPLETE FOR MA
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


TICKER=MANH
EARLIEST EXISTING DATA DATE=2019-09-24
LATEST EXISTING DATA DATE=2023-11-30
Ticker MANH has data and earliest date (2019-09-24 is at least 365 calendar days ago.
Regular update for ticker MANH starts 2023-11-30 up through today date (2023-12-02
Ticker MANH regular fetch request begins with 1701320400
Ticker MANH regular fetch request ends with 1701493200
chartroom historical stock fetch version 0.1 updated 11/15/18
stock fetch for https://finance.yahoo.com/quote/MANH/history?period1=1701320400&period2=1701493200&interval=1d&filter=history&frequency=1d
began at December 2nd, 2023 -- 8:24am
total time:0.428541 size download:1426137 connect time:0.002541
ticker:MANH
Collecting for date:2023-12-01
ticker:MANH
Collecting for date:2023-11-30
ticker:MANH
Collecting for date:lose-
TICKER IS MANH AND SID IS 214
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02
SKIPPING date values where tickdate= AND todaymarketdate=2023-12-02

ADDED MANH for 2023-12-01
NOT A VALID DATE, string = lose-

latest date is 2023-12-01
earliest date is 2019-09-24
UPDATE master SET date_earliest = '2019-09-24', value_earliest = '81.1500', total_date_vals = '1056' WHERE sid = 214
UPDATE ROUTINE COMPLETE FOR MANH
=================================
LASTFETCH saved as 160
LASTFETCH update query=UPDATE admin SET lastfetch = 160
DEBUG the lastfetch value in DB is160


0700.HKTencent Holdings14652017-12-27401.202023-12-01319.00-20.49
AAgilent Technologies14782018-01-1973.072023-12-01128.7976.26
AAAmerican Airlines11972019-03-0529.202023-12-0127.74-5.00
AAPLApple Computer15102017-12-01171.052023-12-01191.2411.80
ABBABB14582018-02-1625.422023-12-01191.24652.32
ABBVAbbvie Inc15052017-12-0895.952023-12-01143.4149.46
ABNBAirBnB7282021-01-12160.802023-12-01135.02-16.03
ABTAbbott Labs11402019-05-2476.982023-12-01104.8836.24
ACBAurora Cannabis Inc13640000-00-000.002023-06-300.54inf
ADBEAdobe Inc15012017-12-14175.002023-12-01612.47249.98
ADPAutomatic Data Processing9632020-02-06180.262023-12-01232.9429.22
ADSKAutodesk12222019-01-28140.772023-12-01224.9359.79
AGNAllergan PLC13742018-01-19181.332023-12-01224.9324.04
AKAMAkamai11972019-03-0570.552023-12-01116.0364.46
ALBAlbemarle Corp11932019-03-1484.732023-12-01126.1648.90
AMATApplied Materials13452018-07-3148.632023-12-01151.59211.72
AMDAdvanced Micro Devices14662018-02-0611.652023-12-01121.39941.97
AMTAmerican Tower11422019-05-22200.672023-12-01210.474.88
AMZNAmazon15102017-12-011,162.352023-12-01147.03-87.35
ANETArista Networks15022017-12-13225.132023-12-01216.64-3.77
APAApache Corp15032017-12-1239.722023-12-0136.20-8.86
AQMIXAQR Managed Futures Strategy Fund Class I15032017-12-129.172023-12-018.92-2.73
ARKKARK Disruptive Innovation ETF9502020-02-2653.542023-12-0148.43-9.54
ATVIActivision Blizzard Inc7272021-01-0489.902023-12-0148.43-46.13
AVGOBroadcom11942019-03-08264.192023-12-01930.00252.02
AVIDAvid Technology Inc9582020-02-118.952023-12-01930.0010,291.06
AXPAmerican Express7382020-12-28118.362023-12-01173.7646.81
AYAtlantica Sustainable Infrastructure9752020-01-2128.122023-12-0119.68-30.01
BABoeing15052017-12-08285.902023-12-01233.87-18.20
BABAAlibaba15022017-12-13176.472023-12-0173.99-58.07
BACBank of America15052017-12-0829.052023-12-0130.966.57
BCELAtreca Inc Cl A7342021-01-0415.772023-12-010.22-98.64
BDXBecton Dickinson14442018-03-09226.122023-12-01238.255.36
BEAMBeam Therapeutics9632020-02-0618.752023-12-0129.5757.71
BLKBlackRock Inc9842020-01-07507.222023-12-01756.3549.12
BLUEBluebird bio9682020-01-3082.242023-12-014.26-94.82
BLVVanguard Select Long-Term Bond ETF14042018-05-0787.932023-12-0170.69-19.61
BMYBristol Myers Squibb15052017-12-0862.422023-12-0150.10-19.74
BNDVanguard Total Bond Market ETF14042018-05-0778.842023-12-0171.81-8.92
BNDXVanguard Intl Bond ETF13452018-07-3154.742023-12-0149.44-9.68
BPBP PLC SPON ADR 15032017-12-1240.662023-12-0135.98-11.51
BRK BBERKSHIRE HATHAWAY INC CL B NEW252023-05-2635.552023-07-0335.931.07
BRK-BBerkshire Hathaway7362020-12-30229.652023-12-01357.0755.48
BSVVanguard Short-Term Bond ETF15102017-12-0179.252023-12-0176.27-3.76
CATCaterpillar Inc10552019-09-25126.612023-12-01256.76102.80
CBLKCarbon Black13632018-06-2525.452023-12-01256.76908.88
CCICrown Castle International11422019-05-22126.632023-12-01118.57-6.37
CCLCarnival Corp13612018-07-0957.942023-12-0115.76-72.80
CGCCanopy Growth Corp13522018-01-1225.912023-05-260.88-96.62
CHKPCheckpoint12452018-12-21100.042023-12-01145.8345.77
CHTRCharter Communications8732020-06-16532.452023-12-01401.87-24.52
CHWYChewy Inc9662020-02-0328.202023-12-0118.32-35.04
CINFCincinnati Financial Corp15032017-12-1274.522023-12-01102.6537.75
CLXClorox15052017-12-08145.232023-12-01143.84-0.96
CMCSAComcast Corp Cl A14862018-01-0840.482023-12-0142.214.27
COINCoinbase6232021-06-14239.102023-12-01133.76-44.06
COSTCostco11922019-03-12232.962023-12-01596.25155.95
Cresco LabsCRLBF6532021-04-30372.092023-12-01596.2560.24
CRLCharles River Labs11012019-07-22136.462023-12-01201.6847.79
CRMSalesforce.com Inc15012017-12-14104.242023-12-01260.00149.42
CRONCronos Group Inc14522018-02-277.622023-12-012.10-72.44
CRSPCrispr Therapeutics9682020-01-3052.422023-12-0168.6530.96
CRWDCrowdstrike11282019-06-1258.002023-12-01235.03305.22
CSCOCisco Systems15022017-12-1338.152023-12-0148.4727.05
CTRACoterra Energy Inc6422021-05-1718.312023-12-0126.1442.76
CURLFCuraleaf Holdings8982020-05-114.822023-12-013.59-25.52
CVSCVS Health Corp11932019-03-1153.752023-12-0168.4827.40
CVXChevron Corp10372019-10-21116.612023-12-01144.8124.18
CYBRCyberArk13702018-06-2562.792023-12-01201.39220.74
DALDelta Airlines12142019-02-0750.412023-12-0138.05-24.52
DBAInvesco DB Agriculture Fund9342020-03-1913.882023-12-0122.0258.65
DDOGData Dog9662020-02-0345.262023-12-01118.62162.09
DEDeere & Co7232021-01-20300.942023-12-01368.8122.55
DHID.R. Horton10502019-10-0251.402023-12-01130.86154.59
DHRDanaher14782018-01-19100.562023-12-01223.48122.24
DISDisney15052017-12-08104.232023-12-0192.58-11.18
DNAGinkgo Bioworks3362022-08-033.062023-12-011.43-53.27
DOCUDocusign11312019-06-0748.162023-12-0145.99-4.51
DOWDow11072019-03-2049.802023-12-0152.305.02
DTDynatrace Inc9602020-02-1135.692023-12-0154.8253.60
DUKDuke Energy Corp New15052017-12-0888.052023-12-0192.645.21
DVNDevon Energy6712021-04-0622.782023-12-0145.1798.29
DVYIshares Select Dividend ETF15032017-12-1298.742023-12-01113.9615.41
DWDPDowDupont Inc13602017-12-1270.792023-12-01113.9660.98
DXYUS Dollar index2592022-10-28118.862023-12-01113.96-4.12
EDITEditas Medicine9682020-01-3026.842023-12-0110.77-59.87
EFACore MSCI Eafe14042018-05-0770.942023-12-0173.183.16
EFGIshares MSCI EAFE Growth ETF15042017-12-1279.792023-12-0192.9516.49
EIXEdison International10602019-09-1872.072023-12-0167.48-6.37
EMREmerson electric4352022-03-1193.002023-12-0190.12-3.10
ENPHEnphase Energy7182021-01-27179.022023-12-01106.52-40.50
ERICEricsson11422019-05-2210.052023-12-015.02-50.05
ETSYEtsy11972019-03-0570.612023-12-0182.0416.19
EWJiShares MSCI Japan ETF10142019-11-2159.532023-12-0163.216.18
EWTIshares Taiwan ETF9342020-03-1929.482023-12-0149.0266.28
EWWiShares MSCI Mexico6352021-05-2647.382023-12-0163.8034.66
EWYIshares South Korea ETF9342020-03-1939.002023-12-0163.3262.36
EXASExact Sciences9102020-04-2374.702023-12-0167.03-10.27
EXPEExpedia9782020-01-15110.742023-12-01139.3125.80
FFord Motor14042018-05-0711.342023-12-0110.58-6.70
FAQIXNuveen Dividend Value Fund Class I15032017-12-1216.642023-12-0114.01-15.81
FARCXNuveen Real Estate Securities Fund Class I15032017-12-1222.922023-12-0114.56-36.47
FBFacebook13142017-12-01175.102023-07-2714.91-91.48
FCXFreeport-McMoRan Inc10562019-09-2410.012023-12-0139.24292.01
FSLRFirst Solar10562019-09-2465.482023-12-01160.29144.79
FSPHXFidelity Select Health Care Fund15102017-12-0123.192023-12-0126.6915.09
FTNTFortinet 13702018-06-2562.122023-12-0152.49-15.50
FYIPXNuveen Inflation Protected Securities Fund Class I5812017-12-1211.252023-01-2350.51348.98
GDXVaneck Gold ETF9342020-03-1921.272023-12-0131.8149.55
GEGeneral Electric Co.14860000-00-000.002023-11-30121.80inf
GEHCGE HEALTHCARE TECHNOLOGIES INC1122022-12-1560.002023-05-2678.4330.72
GHGuardant Health9102020-04-2375.102023-12-0126.33-64.94
GHCGraham Holdings Company10992019-07-24735.362023-12-01637.86-13.26
GILDGilead10562019-09-2464.562023-12-0177.6520.28
GLDSPDR Gold Shares ETF10142019-11-21138.002023-12-01192.0139.14
GLKGlaxoSmithKline182021-10-08164.232023-01-23179.639.38
GLWCorning9342020-03-1921.272023-12-0128.8435.59
GMGeneral Motors14942017-12-2641.802023-12-0132.36-22.58
GOOGAlphabet class C15092017-12-011,010.172023-12-01133.32-86.80
GOOGLAlphabet Inc CL A15022017-12-131,051.392023-12-01131.86-87.46
GPSGap Stores13602018-07-1031.012023-12-0121.02-32.22
GRAW R Grace10362019-10-1865.872023-12-0121.02-68.09
GSKGlaxoSmithKline10532019-09-2742.342023-12-0136.57-13.63
GTBIFGreen Thumb Industries8982020-05-117.392023-12-0110.5442.63
HALHalliburton6822021-03-1921.792023-12-0137.7173.06
HASHasbro Inc15052017-12-0891.362023-12-0148.46-46.96
HDHome Depot14432018-03-12179.712023-12-01319.6277.85
HEQJohn Hancock Hedged Equity & Income6422021-05-1712.532023-12-0110.17-18.83
HONHoneywell7002021-02-23205.042023-12-01197.78-3.54
HRIHerc Rentals10382019-10-1846.712023-12-01131.32181.14
HUMHUMANA INC3782022-06-02449.552023-12-01495.2110.16
HZEMFHorizons Emerging Marijuana Growers Index (ETF)7732019-02-155.542023-12-01495.218,835.74
IBMIBM13602018-07-10144.712023-12-01160.5510.95
IEMGiShares Core MSCI Emerging Markets10142019-11-2151.522023-12-0149.92-3.11
IJKS&P MidCap Growth ETF14042018-05-07220.642023-12-0175.58-65.75
IJTS&P SmallCap Growth ETF14042018-05-07178.832023-12-01114.53-35.96
ILMNIllumina14782018-01-19243.552023-12-01109.79-54.92
INDAiShares MSCI India6352021-05-2644.072023-12-0146.405.29
INPHIInphi9942019-12-19325.202023-12-0146.40-85.73
INTCIntel15022017-12-1343.342023-12-0143.740.92
INTUIntuit 8002020-09-29323.642023-12-01574.3277.46
IPInternational Paper13602018-07-1053.472023-12-0137.19-30.45
IPHIInphi Corp10452019-04-1846.702023-07-2735.40-24.20
ISRGIntuitive Surgical14442018-03-09440.462023-12-01315.20-28.44
JBLUJet Blue Airlines10562019-09-2416.632023-12-014.63-72.16
JNJJohnson and Johnson15102017-12-01139.982023-12-01158.3813.14
JPMJP Morgan Chase15052017-12-08105.932023-12-01156.8448.06
JWNNordstrom13602018-07-1052.092023-12-0116.19-68.92
KHCKraft Heinz13602018-07-1064.002023-12-0135.52-44.50
KLACKLA Corp8012020-09-28193.252023-12-01549.00184.09
KMBKimberly Clark15092017-12-04123.112023-12-01124.040.76
KNBEKnowBe4, Inc.6532021-04-2224.142023-12-01124.04413.84
KOCoca-Cola Company14352018-03-2242.762023-12-0158.6437.14
LENLennar homebuilders10522019-09-3055.852023-12-01131.58135.60
LITGlobal X Lithium & Battery ETF11912019-03-1328.662023-12-0148.3068.53
LLYEli Lilly & Co6722021-04-05184.892023-12-01584.04215.89
LOWLowe's10522019-09-30109.962023-12-01203.9285.45
LRCXLam Research Corporation14742018-01-25199.252023-12-01722.08262.40
LTHMLivent10422019-10-146.952023-12-0114.32106.04
LUVSouthwest Airlines10552019-09-2554.822023-12-0126.69-51.31
MAMastercard14942017-12-26151.282023-12-01414.36173.90
MANHManhattan Associates10562019-09-2481.152023-12-01227.92180.86
MCDMcDonald's11402019-05-23198.972023-11-30281.8441.65
MCHIiShares MSCI China14032018-05-0767.352023-11-3042.68-36.63
MDTMedtronic11402019-05-2391.642023-11-3079.27-13.50
METAMeta fka Facebook5772021-08-17358.452023-11-30327.15-8.73
MFAMFA Financial6712021-04-054.162023-11-3010.80159.62
MLHRHerman Miller10422019-09-3046.092023-11-3010.80-76.57
MMM3M Company10582019-09-19167.072023-11-3099.07-40.70
MOATVanEck Vectors Morningstar Wide Moat ETF14732018-01-2545.482023-11-3079.3874.54
MORTVanEck Vectors Mortgage REIT Income10332019-10-2423.312023-11-3011.25-51.74
MOSMosaic Company7022021-02-1827.652023-11-3035.8929.80
MRKMerck & Company Inc New15022017-12-1257.072023-11-30102.4879.57
MRNAModerna11972019-03-0421.122023-11-3077.70267.90
MRVLMarvell Technology Group11402019-05-2322.122023-11-3055.73151.94
MSMorgan Stanley14032018-05-0752.392023-11-3079.3451.44
MSFTMicrosoft Corp15022017-12-1285.582023-11-30378.91342.76
MSOSAdvisor Shares Pure US Cannabis ETF8172020-09-0224.672023-11-306.82-72.36
MTHMeritage Home10512019-09-3070.352023-11-30141.30100.85
MTNVail Resorts10332019-10-24232.852023-11-30217.31-6.67
MTUMiShares Edge MSCI USA Momentum Factor ETF12042019-02-21109.712023-11-30150.1136.82
MUMicron Technology15012017-12-1342.052023-11-3076.1281.02
NEENextEra Energy14432018-03-09154.812023-11-3058.51-62.21
NFLXNetflix11292019-06-10352.012023-11-30473.9734.65
NHMRXNuveen High Yield Municipal Bond Fund Class I15022017-12-1217.392023-11-3014.45-16.91
NLOKSymantec/Norton11972019-03-0422.092023-11-3014.45-34.59
NOBLProShares S&P 500 Dividend Aristocrat13782018-06-1264.182023-11-3091.1041.94
NOKNokia11402019-05-234.972023-11-303.48-29.98
NOWServiceNow Inc15002017-12-14126.172023-11-30685.74443.50
NTLAIntellia Therapeutics9662020-01-3111.912023-11-3029.63148.78
NTRSNorthern Trust Corp15022017-12-1298.552023-11-3079.25-19.58
NVDANVidia15012017-12-13186.182023-11-30467.70151.21
NVRNVR Inc10512019-09-303,717.352023-11-306,155.3965.59
NVSNovartis AG Spon ADR15042017-12-0883.962023-11-3097.9016.60
NVTAInvitae Corp9362020-03-169.922023-11-300.51-94.88
OGNORGANON5032021-05-1433.252023-11-3011.32-65.95
OKTAOkta Inc13702018-06-2251.892023-11-3067.0529.22
ORCLOracle 15012017-12-1350.052023-11-30116.21132.19
PACBPacific Biosciences9082020-04-243.222023-11-308.48163.35
PANWPalo Alto Networks13702018-06-22207.592023-11-30295.0942.15
PAYCPaycom Software11922019-03-11181.162023-11-30181.660.28
PEPPepsico Inc15042017-12-08116.572023-11-30168.2944.37
PETSPet Meds9662020-01-3125.212023-11-306.93-72.51
PFEPfizer Inc15042017-12-0835.742023-11-3030.47-14.75
PFPTProofpoint12202018-06-22119.672023-11-3030.47-74.54
PGProcter & Gamble Co 15022017-12-1289.852023-11-30153.5270.86
PHMPulteGroup10512019-09-3036.552023-11-3088.42141.92
PJTP J T Partners Inc Cl A9842020-01-0643.522023-11-3090.06106.94
PLDPrologis 10552019-09-2484.222023-11-30114.9336.46
PRNHXT. Rowe Price New Horizons14932017-12-2652.652023-11-3050.95-3.23
PXDPioneer6232021-06-11162.902023-11-30231.6442.20
PYPLPayPal Holdings14432018-03-0980.712023-11-3057.61-28.62
QCOMQualcomm11422019-05-2177.752023-11-30129.0565.98
QLYSQualys13702018-06-2288.802023-11-30184.84108.15
QQQNasdaq big tech15092017-12-01154.492023-11-30388.83151.69
QRVOQorvo11402019-05-2360.662023-11-3096.5059.08
REGLProShares MidCap 400 Dividend Aristocrats13782018-06-1254.932023-11-3069.2226.01
RHTRed Hat Inc14512017-12-14126.132023-11-3069.22-45.12
RNGRingCentral11972019-03-04103.562023-11-3028.46-72.52
ROKURoku Inc Cl. A12912018-10-1561.692023-11-30104.2068.91
SAILSailpoint Technologies10402019-10-0718.392023-11-30104.20466.61
SAVESpirit Airlines6712021-04-0537.492023-11-30104.20177.94
SBACSBA Communications11402019-05-23210.032023-11-30246.9617.58
SBUXStarbucks10552019-09-2489.922023-11-3099.3010.43
SCHWCharles Schwab Corp13902018-05-2458.142023-11-3061.325.47
SEDGSolaredge Technologies11972019-03-0441.552023-11-3079.3891.05
SGMOSangamo Therapeutics9662020-01-317.332023-11-300.43-94.13
SHOPShopify14932017-12-26104.842023-11-3072.82-30.54
SLGSL Green9222020-04-0339.792023-11-3036.57-8.09
SMHVanEck Vectors Semiconductor ETF14732018-01-25104.602023-11-30160.4853.42
SNOWSnowflake Inc7772020-09-16253.932023-11-30187.68-26.09
SOSouthern Company15042017-12-0851.062023-11-3070.9839.01
SPGSimon Property Group10082019-11-29151.212023-11-30124.89-17.41
SPLKSplunk Inc15002017-12-1481.192023-11-30151.5486.65
SPOTSpotify Technology13702018-06-22180.942023-11-30185.112.30
SQSquare11972019-03-0474.692023-11-3063.43-15.08
SRESempra Energy14432018-03-09109.082023-11-3072.87-33.20
STXSeagate Tech11902019-03-1347.682023-11-3079.1065.90
SWKSSkyworks Solutions14822018-01-1199.922023-11-3096.93-2.99
SYMCSymantec13182018-06-2220.722023-11-3096.93367.81
TAT&T Inc15042017-12-0836.732023-11-3016.57-54.89
TCNNFTrulieve Cannabis8982020-05-0810.432023-11-305.55-46.79
TDOCTeledoc11972019-03-0463.132023-11-3018.14-71.27
TEAMAtlassian13792018-06-1164.352023-11-30190.95196.74
TECHBio-Techne14772018-01-19140.722023-11-3062.90-55.30
TERTeradyne14572018-02-1643.312023-11-3092.23112.95
TGTTarget Corp6712021-04-05205.352023-11-30133.81-34.84
TIIHXTIAA-CREF inflation bond13442018-07-3111.232023-11-3010.39-7.48
TLRYTilray Inc13352018-07-1922.392023-11-301.81-91.92
TMHCTaylor Morrison Home10502019-10-0125.582023-11-3045.1076.31
TMOThermo Fisher Scientific Inc14772018-01-19213.512023-11-30495.76132.20
TMUST-Mobile US Inc.11402019-05-2376.012023-11-30150.4597.93
TOLToll Brothers10502019-10-0140.272023-11-3085.89113.29
TPRTapestry brands13592018-07-1046.502023-11-3031.67-31.89
TRIPTrip Advisor8732020-06-1520.822023-11-3017.83-14.36
TRMBTrimble2832022-10-1754.502023-11-3046.40-14.86
TSLATesla14932017-12-26317.292023-11-30240.08-24.33
TSMTaiwan Semiconductor9402020-03-1054.512023-11-3097.3178.52
TTDTheTradeDesk11972019-03-04189.382023-11-3070.46-62.79
TWLOTwilio Inc14302018-03-2837.432023-11-3064.6872.80
UBERUber Technologies11492019-05-1041.572023-11-3056.3835.63
UNHUnited Healthcare15082017-12-04221.422023-11-30552.97149.74
UNPUnion Pacific10562019-09-24165.082023-12-01231.3740.16
UPSUnited Parcel Service Inc Cl B15032017-12-12118.162023-12-01154.9131.10
USBUS Bancorp9232020-04-0331.192023-12-0139.3826.26
USOUnited States Oil ETF15102017-12-0111.672023-12-0169.24493.32
VVisa Inc14942017-12-26112.992023-12-01256.45126.97
VAWVanguard Materials ETF15062017-12-07133.932023-12-01183.0936.71
VBVanguard Small-Cap Index Fund15072017-12-06145.312023-12-01199.7637.47
VBKVanguard Small-Cap Growth ETF15072017-12-06157.142023-12-01225.1443.27
VBRVanguard Small-Cap Value ETF6722021-04-05168.312023-12-01169.290.58
VCITVanguard Intermediate Corp bond etf13452018-07-3183.942023-12-0178.99-5.90
VCLTVanguard long-term corp bond etf13452018-07-3189.162023-12-0176.42-14.29
VCRVanguard Consumer Staples ETF15062017-12-07153.172023-12-01289.6789.12
VDCVanguard Consumer Discretionary ETF15062017-12-07144.952023-12-01187.7029.49
VDEVanguard Energy ETF15062017-12-0793.802023-12-01119.2427.12
VEEVVeeva Systems Inc. Cl A13602018-07-1079.452023-12-01178.84125.10
VFHVanguard Financials ETF15102017-12-0169.502023-12-0187.8826.45
VGSTXVanguard Star Fund Investor Shares 15032017-12-1227.622023-12-0126.97-2.35
VGTVanguard Information Technology ETF15062017-12-07163.482023-12-01464.65184.22
VHTVanguard Health Care ETF15062017-12-07152.902023-12-01240.1557.06
VIGVanguard Dividend Appreciation ETF13772018-06-14104.502023-12-01165.7758.63
VIGRXVanguard Growth Index Inv15102017-12-0171.822023-12-01154.33114.88
VIOVVanguard S&P Small Cap Value ETF8742020-06-15105.492023-12-0181.18-23.04
VISVanguard Industrial ETF15062017-12-07139.842023-12-01209.0149.46
VIVAXVanguard Value Index Inv15102017-12-0141.032023-12-0156.4037.46
VMBSVanguard Mortgage Backed Securities ETF5772021-08-1853.422023-12-0145.14-15.50
VMCVulcan Materials10552019-09-25150.882023-12-01215.6342.91
VMWVMware Inc14992017-12-14121.252023-12-01215.6377.84
VNMVanEck Vectors Vietnam ETF14382018-03-1919.162023-12-0113.31-30.53
VNQVanguard Real Estate ETF15062017-12-0783.602023-12-0183.740.17
VOEVanguard Mid-Cap Value ETF3792022-06-01144.112023-12-01139.45-3.23
VOXVanguard Communication Services ETF14042018-05-0783.492023-12-01112.5034.75
VPLVanguard Pacific etf3672022-06-1763.032023-12-0170.1211.25
VPUVanguard Utilities ETF15072017-12-06122.582023-12-01136.9911.76
VRTVertiv Holdings10352019-10-2310.272023-12-0145.14339.53
VTVanguard Total World ETF9842020-01-0781.122023-12-0199.4622.61
VTIVanguard Total Market15102017-12-01136.072023-12-01228.1767.69
VTIPVanguard Short Term Inflation Protected Securities ETF 15032017-12-1249.492023-12-0147.75-3.52
VWEHXVanguard High-Yield Corporate Fund10982019-07-255.872023-12-015.29-9.88
VWIGXVanguard International Growth13972018-05-1631.882023-12-0131.41-1.47
VWITXVanguard int term tax-exempt bond5232021-11-0314.672023-12-0113.51-7.91
VWOVanguard FTSE Emerging Markets ETF15102017-12-0144.052023-12-0140.80-7.38
VWOBVanguard Emerging Mkts Govt Bd ETF12922018-10-1574.812023-12-0161.96-17.18
VXUSVanguard Total Int'l Stock ETF15062017-12-0755.642023-12-0156.491.53
VYMVanguard High Dividend Yield ETF13762018-06-1585.342023-12-01107.8426.37
VZVerizon Communications15052017-12-0851.092023-12-0138.58-24.49
WBDWarner Bros Discovery6422021-05-1733.852023-12-0111.33-66.53
WCLDWisdom Tree Cloud Computing ETF10462019-10-0823.802023-12-0132.6837.31
WDAYWorkDay Inc15012017-12-14103.352023-12-01272.92164.07
WEWeWork4212021-10-2111.782023-12-01272.922,216.81
WFCWells Fargo13602018-07-1056.622023-12-0145.02-20.49
WMTWalmart14942017-12-2699.162023-12-01154.3455.65
WORKSlack9602019-06-2038.622023-12-01154.34299.64
XOMExxon Mobil15052017-12-0882.662023-12-01102.9924.59
YETIYeti1192018-09-250.002022-04-1487.83inf
ZMZoom12602018-10-2517.002023-12-0170.29313.47
ZSZscaler13702018-06-2536.362023-12-01198.03444.64
ZTSZoetis Inc Cl A15052017-12-0871.882023-12-01179.13149.21
^GSPCS&P 500 Index15042017-12-012,642.222023-12-014,594.6373.89


current CLOSE, CURRENT 200-day Exp MA, SLOPE OF 200MA, CURRENT 21-day Exp MA, SLOPE of 21MA
POSITION OF current CLOSE vs 21 and 200
DISPLAY results in desired formats
The three steps to calculating the EMA are: Calculate the SMA. Calculate the multiplier for weighting the EMA. Calculate the current EMA. The mathematical formula, in this case for calculating a 10-period EMA, looks like this: SMA: 10-period sum 10 Calculating the weighting multiplier: [2 (selected time period + 1)] = [2 (10 + 1)] = 0.1818 or 18.18% Calculating the EMA: [Closing price-EMA (previous day)] x multiplier + EMA (previous day) The weighting given to the most recent price is greater for a shorter-period EMA than for a longer-period EMA. For example, an 18.18% multiplier is applied to the most recent price data for a 10 EMA, whereas for a 20 EMA, only a 9.52% multiplier weighting is used. There are also slight variations of the EMA arrived at by using the open, high, low or median price instead of using the closing price. Read more: How is the Exponential Moving Average (EMA) formula calculated? | Investopedia https://www.investopedia.com/ask/answers/122314/what-exponential-moving-average-ema-formula-and-how-ema-calculated.asp#ixzz5XL5b70cK Follow us: Investopedia on Facebook