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.HK	Tencent Holdings	1465	2017-12-27	401.20	2023-12-01	319.00	-20.49
A	Agilent Technologies	1478	2018-01-19	73.07	2023-12-01	128.79	76.26
AA	American Airlines	1197	2019-03-05	29.20	2023-12-01	27.74	-5.00
AAPL	Apple Computer	1510	2017-12-01	171.05	2023-12-01	191.24	11.80
ABB	ABB	1458	2018-02-16	25.42	2023-12-01	191.24	652.32
ABBV	Abbvie Inc	1505	2017-12-08	95.95	2023-12-01	143.41	49.46
ABNB	AirBnB	728	2021-01-12	160.80	2023-12-01	135.02	-16.03
ABT	Abbott Labs	1140	2019-05-24	76.98	2023-12-01	104.88	36.24
ACB	Aurora Cannabis Inc	1364	0000-00-00	0.00	2023-06-30	0.54	inf
ADBE	Adobe Inc	1501	2017-12-14	175.00	2023-12-01	612.47	249.98
ADP	Automatic Data Processing	963	2020-02-06	180.26	2023-12-01	232.94	29.22
ADSK	Autodesk	1222	2019-01-28	140.77	2023-12-01	224.93	59.79
AGN	Allergan PLC	1374	2018-01-19	181.33	2023-12-01	224.93	24.04
AKAM	Akamai	1197	2019-03-05	70.55	2023-12-01	116.03	64.46
ALB	Albemarle Corp	1193	2019-03-14	84.73	2023-12-01	126.16	48.90
AMAT	Applied Materials	1345	2018-07-31	48.63	2023-12-01	151.59	211.72
AMD	Advanced Micro Devices	1466	2018-02-06	11.65	2023-12-01	121.39	941.97
AMT	American Tower	1142	2019-05-22	200.67	2023-12-01	210.47	4.88
AMZN	Amazon	1510	2017-12-01	1,162.35	2023-12-01	147.03	-87.35
ANET	Arista Networks	1502	2017-12-13	225.13	2023-12-01	216.64	-3.77
APA	Apache Corp	1503	2017-12-12	39.72	2023-12-01	36.20	-8.86
AQMIX	AQR Managed Futures Strategy Fund Class I	1503	2017-12-12	9.17	2023-12-01	8.92	-2.73
ARKK	ARK Disruptive Innovation ETF	950	2020-02-26	53.54	2023-12-01	48.43	-9.54
ATVI	Activision Blizzard Inc	727	2021-01-04	89.90	2023-12-01	48.43	-46.13
AVGO	Broadcom	1194	2019-03-08	264.19	2023-12-01	930.00	252.02
AVID	Avid Technology Inc	958	2020-02-11	8.95	2023-12-01	930.00	10,291.06
AXP	American Express	738	2020-12-28	118.36	2023-12-01	173.76	46.81
AY	Atlantica Sustainable Infrastructure	975	2020-01-21	28.12	2023-12-01	19.68	-30.01
BA	Boeing	1505	2017-12-08	285.90	2023-12-01	233.87	-18.20
BABA	Alibaba	1502	2017-12-13	176.47	2023-12-01	73.99	-58.07
BAC	Bank of America	1505	2017-12-08	29.05	2023-12-01	30.96	6.57
BCEL	Atreca Inc Cl A	734	2021-01-04	15.77	2023-12-01	0.22	-98.64
BDX	Becton Dickinson	1444	2018-03-09	226.12	2023-12-01	238.25	5.36
BEAM	Beam Therapeutics	963	2020-02-06	18.75	2023-12-01	29.57	57.71
BLK	BlackRock Inc	984	2020-01-07	507.22	2023-12-01	756.35	49.12
BLUE	Bluebird bio	968	2020-01-30	82.24	2023-12-01	4.26	-94.82
BLV	Vanguard Select Long-Term Bond ETF	1404	2018-05-07	87.93	2023-12-01	70.69	-19.61
BMY	Bristol Myers Squibb	1505	2017-12-08	62.42	2023-12-01	50.10	-19.74
BND	Vanguard Total Bond Market ETF	1404	2018-05-07	78.84	2023-12-01	71.81	-8.92
BNDX	Vanguard Intl Bond ETF	1345	2018-07-31	54.74	2023-12-01	49.44	-9.68
BP	BP PLC SPON ADR	1503	2017-12-12	40.66	2023-12-01	35.98	-11.51
BRK B	BERKSHIRE HATHAWAY INC CL B NEW	25	2023-05-26	35.55	2023-07-03	35.93	1.07
BRK-B	Berkshire Hathaway	736	2020-12-30	229.65	2023-12-01	357.07	55.48
BSV	Vanguard Short-Term Bond ETF	1510	2017-12-01	79.25	2023-12-01	76.27	-3.76
CAT	Caterpillar Inc	1055	2019-09-25	126.61	2023-12-01	256.76	102.80
CBLK	Carbon Black	1363	2018-06-25	25.45	2023-12-01	256.76	908.88
CCI	Crown Castle International	1142	2019-05-22	126.63	2023-12-01	118.57	-6.37
CCL	Carnival Corp	1361	2018-07-09	57.94	2023-12-01	15.76	-72.80
CGC	Canopy Growth Corp	1352	2018-01-12	25.91	2023-05-26	0.88	-96.62
CHKP	Checkpoint	1245	2018-12-21	100.04	2023-12-01	145.83	45.77
CHTR	Charter Communications	873	2020-06-16	532.45	2023-12-01	401.87	-24.52
CHWY	Chewy Inc	966	2020-02-03	28.20	2023-12-01	18.32	-35.04
CINF	Cincinnati Financial Corp	1503	2017-12-12	74.52	2023-12-01	102.65	37.75
CLX	Clorox	1505	2017-12-08	145.23	2023-12-01	143.84	-0.96
CMCSA	Comcast Corp Cl A	1486	2018-01-08	40.48	2023-12-01	42.21	4.27
COIN	Coinbase	623	2021-06-14	239.10	2023-12-01	133.76	-44.06
COST	Costco	1192	2019-03-12	232.96	2023-12-01	596.25	155.95
Cresco Labs	CRLBF	653	2021-04-30	372.09	2023-12-01	596.25	60.24
CRL	Charles River Labs	1101	2019-07-22	136.46	2023-12-01	201.68	47.79
CRM	Salesforce.com Inc	1501	2017-12-14	104.24	2023-12-01	260.00	149.42
CRON	Cronos Group Inc	1452	2018-02-27	7.62	2023-12-01	2.10	-72.44
CRSP	Crispr Therapeutics	968	2020-01-30	52.42	2023-12-01	68.65	30.96
CRWD	Crowdstrike	1128	2019-06-12	58.00	2023-12-01	235.03	305.22
CSCO	Cisco Systems	1502	2017-12-13	38.15	2023-12-01	48.47	27.05
CTRA	Coterra Energy Inc	642	2021-05-17	18.31	2023-12-01	26.14	42.76
CURLF	Curaleaf Holdings	898	2020-05-11	4.82	2023-12-01	3.59	-25.52
CVS	CVS Health Corp	1193	2019-03-11	53.75	2023-12-01	68.48	27.40
CVX	Chevron Corp	1037	2019-10-21	116.61	2023-12-01	144.81	24.18
CYBR	CyberArk	1370	2018-06-25	62.79	2023-12-01	201.39	220.74
DAL	Delta Airlines	1214	2019-02-07	50.41	2023-12-01	38.05	-24.52
DBA	Invesco DB Agriculture Fund	934	2020-03-19	13.88	2023-12-01	22.02	58.65
DDOG	Data Dog	966	2020-02-03	45.26	2023-12-01	118.62	162.09
DE	Deere & Co	723	2021-01-20	300.94	2023-12-01	368.81	22.55
DHI	D.R. Horton	1050	2019-10-02	51.40	2023-12-01	130.86	154.59
DHR	Danaher	1478	2018-01-19	100.56	2023-12-01	223.48	122.24
DIS	Disney	1505	2017-12-08	104.23	2023-12-01	92.58	-11.18
DNA	Ginkgo Bioworks	336	2022-08-03	3.06	2023-12-01	1.43	-53.27
DOCU	Docusign	1131	2019-06-07	48.16	2023-12-01	45.99	-4.51
DOW	Dow	1107	2019-03-20	49.80	2023-12-01	52.30	5.02
DT	Dynatrace Inc	960	2020-02-11	35.69	2023-12-01	54.82	53.60
DUK	Duke Energy Corp New	1505	2017-12-08	88.05	2023-12-01	92.64	5.21
DVN	Devon Energy	671	2021-04-06	22.78	2023-12-01	45.17	98.29
DVY	Ishares Select Dividend ETF	1503	2017-12-12	98.74	2023-12-01	113.96	15.41
DWDP	DowDupont Inc	1360	2017-12-12	70.79	2023-12-01	113.96	60.98
DXY	US Dollar index	259	2022-10-28	118.86	2023-12-01	113.96	-4.12
EDIT	Editas Medicine	968	2020-01-30	26.84	2023-12-01	10.77	-59.87
EFA	Core MSCI Eafe	1404	2018-05-07	70.94	2023-12-01	73.18	3.16
EFG	Ishares MSCI EAFE Growth ETF	1504	2017-12-12	79.79	2023-12-01	92.95	16.49
EIX	Edison International	1060	2019-09-18	72.07	2023-12-01	67.48	-6.37
EMR	Emerson electric	435	2022-03-11	93.00	2023-12-01	90.12	-3.10
ENPH	Enphase Energy	718	2021-01-27	179.02	2023-12-01	106.52	-40.50
ERIC	Ericsson	1142	2019-05-22	10.05	2023-12-01	5.02	-50.05
ETSY	Etsy	1197	2019-03-05	70.61	2023-12-01	82.04	16.19
EWJ	iShares MSCI Japan ETF	1014	2019-11-21	59.53	2023-12-01	63.21	6.18
EWT	Ishares Taiwan ETF	934	2020-03-19	29.48	2023-12-01	49.02	66.28
EWW	iShares MSCI Mexico	635	2021-05-26	47.38	2023-12-01	63.80	34.66
EWY	Ishares South Korea ETF	934	2020-03-19	39.00	2023-12-01	63.32	62.36
EXAS	Exact Sciences	910	2020-04-23	74.70	2023-12-01	67.03	-10.27
EXPE	Expedia	978	2020-01-15	110.74	2023-12-01	139.31	25.80
F	Ford Motor	1404	2018-05-07	11.34	2023-12-01	10.58	-6.70
FAQIX	Nuveen Dividend Value Fund Class I	1503	2017-12-12	16.64	2023-12-01	14.01	-15.81
FARCX	Nuveen Real Estate Securities Fund Class I	1503	2017-12-12	22.92	2023-12-01	14.56	-36.47
FB	Facebook	1314	2017-12-01	175.10	2023-07-27	14.91	-91.48
FCX	Freeport-McMoRan Inc	1056	2019-09-24	10.01	2023-12-01	39.24	292.01
FSLR	First Solar	1056	2019-09-24	65.48	2023-12-01	160.29	144.79
FSPHX	Fidelity Select Health Care Fund	1510	2017-12-01	23.19	2023-12-01	26.69	15.09
FTNT	Fortinet	1370	2018-06-25	62.12	2023-12-01	52.49	-15.50
FYIPX	Nuveen Inflation Protected Securities Fund Class I	581	2017-12-12	11.25	2023-01-23	50.51	348.98
GDX	Vaneck Gold ETF	934	2020-03-19	21.27	2023-12-01	31.81	49.55
GE	General Electric Co.	1486	0000-00-00	0.00	2023-11-30	121.80	inf
GEHC	GE HEALTHCARE TECHNOLOGIES INC	112	2022-12-15	60.00	2023-05-26	78.43	30.72
GH	Guardant Health	910	2020-04-23	75.10	2023-12-01	26.33	-64.94
GHC	Graham Holdings Company	1099	2019-07-24	735.36	2023-12-01	637.86	-13.26
GILD	Gilead	1056	2019-09-24	64.56	2023-12-01	77.65	20.28
GLD	SPDR Gold Shares ETF	1014	2019-11-21	138.00	2023-12-01	192.01	39.14
GLK	GlaxoSmithKline	18	2021-10-08	164.23	2023-01-23	179.63	9.38
GLW	Corning	934	2020-03-19	21.27	2023-12-01	28.84	35.59
GM	General Motors	1494	2017-12-26	41.80	2023-12-01	32.36	-22.58
GOOG	Alphabet class C	1509	2017-12-01	1,010.17	2023-12-01	133.32	-86.80
GOOGL	Alphabet Inc CL A	1502	2017-12-13	1,051.39	2023-12-01	131.86	-87.46
GPS	Gap Stores	1360	2018-07-10	31.01	2023-12-01	21.02	-32.22
GRA	W R Grace	1036	2019-10-18	65.87	2023-12-01	21.02	-68.09
GSK	GlaxoSmithKline	1053	2019-09-27	42.34	2023-12-01	36.57	-13.63
GTBIF	Green Thumb Industries	898	2020-05-11	7.39	2023-12-01	10.54	42.63
HAL	Halliburton	682	2021-03-19	21.79	2023-12-01	37.71	73.06
HAS	Hasbro Inc	1505	2017-12-08	91.36	2023-12-01	48.46	-46.96
HD	Home Depot	1443	2018-03-12	179.71	2023-12-01	319.62	77.85
HEQ	John Hancock Hedged Equity & Income	642	2021-05-17	12.53	2023-12-01	10.17	-18.83
HON	Honeywell	700	2021-02-23	205.04	2023-12-01	197.78	-3.54
HRI	Herc Rentals	1038	2019-10-18	46.71	2023-12-01	131.32	181.14
HUM	HUMANA INC	378	2022-06-02	449.55	2023-12-01	495.21	10.16
HZEMF	Horizons Emerging Marijuana Growers Index (ETF)	773	2019-02-15	5.54	2023-12-01	495.21	8,835.74
IBM	IBM	1360	2018-07-10	144.71	2023-12-01	160.55	10.95
IEMG	iShares Core MSCI Emerging Markets	1014	2019-11-21	51.52	2023-12-01	49.92	-3.11
IJK	S&P MidCap Growth ETF	1404	2018-05-07	220.64	2023-12-01	75.58	-65.75
IJT	S&P SmallCap Growth ETF	1404	2018-05-07	178.83	2023-12-01	114.53	-35.96
ILMN	Illumina	1478	2018-01-19	243.55	2023-12-01	109.79	-54.92
INDA	iShares MSCI India	635	2021-05-26	44.07	2023-12-01	46.40	5.29
INPHI	Inphi	994	2019-12-19	325.20	2023-12-01	46.40	-85.73
INTC	Intel	1502	2017-12-13	43.34	2023-12-01	43.74	0.92
INTU	Intuit	800	2020-09-29	323.64	2023-12-01	574.32	77.46
IP	International Paper	1360	2018-07-10	53.47	2023-12-01	37.19	-30.45
IPHI	Inphi Corp	1045	2019-04-18	46.70	2023-07-27	35.40	-24.20
ISRG	Intuitive Surgical	1444	2018-03-09	440.46	2023-12-01	315.20	-28.44
JBLU	Jet Blue Airlines	1056	2019-09-24	16.63	2023-12-01	4.63	-72.16
JNJ	Johnson and Johnson	1510	2017-12-01	139.98	2023-12-01	158.38	13.14
JPM	JP Morgan Chase	1505	2017-12-08	105.93	2023-12-01	156.84	48.06
JWN	Nordstrom	1360	2018-07-10	52.09	2023-12-01	16.19	-68.92
KHC	Kraft Heinz	1360	2018-07-10	64.00	2023-12-01	35.52	-44.50
KLAC	KLA Corp	801	2020-09-28	193.25	2023-12-01	549.00	184.09
KMB	Kimberly Clark	1509	2017-12-04	123.11	2023-12-01	124.04	0.76
KNBE	KnowBe4, Inc.	653	2021-04-22	24.14	2023-12-01	124.04	413.84
KO	Coca-Cola Company	1435	2018-03-22	42.76	2023-12-01	58.64	37.14
LEN	Lennar homebuilders	1052	2019-09-30	55.85	2023-12-01	131.58	135.60
LIT	Global X Lithium & Battery ETF	1191	2019-03-13	28.66	2023-12-01	48.30	68.53
LLY	Eli Lilly & Co	672	2021-04-05	184.89	2023-12-01	584.04	215.89
LOW	Lowe's	1052	2019-09-30	109.96	2023-12-01	203.92	85.45
LRCX	Lam Research Corporation	1474	2018-01-25	199.25	2023-12-01	722.08	262.40
LTHM	Livent	1042	2019-10-14	6.95	2023-12-01	14.32	106.04
LUV	Southwest Airlines	1055	2019-09-25	54.82	2023-12-01	26.69	-51.31
MA	Mastercard	1494	2017-12-26	151.28	2023-12-01	414.36	173.90
MANH	Manhattan Associates	1056	2019-09-24	81.15	2023-12-01	227.92	180.86
MCD	McDonald's	1140	2019-05-23	198.97	2023-11-30	281.84	41.65
MCHI	iShares MSCI China	1403	2018-05-07	67.35	2023-11-30	42.68	-36.63
MDT	Medtronic	1140	2019-05-23	91.64	2023-11-30	79.27	-13.50
META	Meta fka Facebook	577	2021-08-17	358.45	2023-11-30	327.15	-8.73
MFA	MFA Financial	671	2021-04-05	4.16	2023-11-30	10.80	159.62
MLHR	Herman Miller	1042	2019-09-30	46.09	2023-11-30	10.80	-76.57
MMM	3M Company	1058	2019-09-19	167.07	2023-11-30	99.07	-40.70
MOAT	VanEck Vectors Morningstar Wide Moat ETF	1473	2018-01-25	45.48	2023-11-30	79.38	74.54
MORT	VanEck Vectors Mortgage REIT Income	1033	2019-10-24	23.31	2023-11-30	11.25	-51.74
MOS	Mosaic Company	702	2021-02-18	27.65	2023-11-30	35.89	29.80
MRK	Merck & Company Inc New	1502	2017-12-12	57.07	2023-11-30	102.48	79.57
MRNA	Moderna	1197	2019-03-04	21.12	2023-11-30	77.70	267.90
MRVL	Marvell Technology Group	1140	2019-05-23	22.12	2023-11-30	55.73	151.94
MS	Morgan Stanley	1403	2018-05-07	52.39	2023-11-30	79.34	51.44
MSFT	Microsoft Corp	1502	2017-12-12	85.58	2023-11-30	378.91	342.76
MSOS	Advisor Shares Pure US Cannabis ETF	817	2020-09-02	24.67	2023-11-30	6.82	-72.36
MTH	Meritage Home	1051	2019-09-30	70.35	2023-11-30	141.30	100.85
MTN	Vail Resorts	1033	2019-10-24	232.85	2023-11-30	217.31	-6.67
MTUM	iShares Edge MSCI USA Momentum Factor ETF	1204	2019-02-21	109.71	2023-11-30	150.11	36.82
MU	Micron Technology	1501	2017-12-13	42.05	2023-11-30	76.12	81.02
NEE	NextEra Energy	1443	2018-03-09	154.81	2023-11-30	58.51	-62.21
NFLX	Netflix	1129	2019-06-10	352.01	2023-11-30	473.97	34.65
NHMRX	Nuveen High Yield Municipal Bond Fund Class I	1502	2017-12-12	17.39	2023-11-30	14.45	-16.91
NLOK	Symantec/Norton	1197	2019-03-04	22.09	2023-11-30	14.45	-34.59
NOBL	ProShares S&P 500 Dividend Aristocrat	1378	2018-06-12	64.18	2023-11-30	91.10	41.94
NOK	Nokia	1140	2019-05-23	4.97	2023-11-30	3.48	-29.98
NOW	ServiceNow Inc	1500	2017-12-14	126.17	2023-11-30	685.74	443.50
NTLA	Intellia Therapeutics	966	2020-01-31	11.91	2023-11-30	29.63	148.78
NTRS	Northern Trust Corp	1502	2017-12-12	98.55	2023-11-30	79.25	-19.58
NVDA	NVidia	1501	2017-12-13	186.18	2023-11-30	467.70	151.21
NVR	NVR Inc	1051	2019-09-30	3,717.35	2023-11-30	6,155.39	65.59
NVS	Novartis AG Spon ADR	1504	2017-12-08	83.96	2023-11-30	97.90	16.60
NVTA	Invitae Corp	936	2020-03-16	9.92	2023-11-30	0.51	-94.88
OGN	ORGANON	503	2021-05-14	33.25	2023-11-30	11.32	-65.95
OKTA	Okta Inc	1370	2018-06-22	51.89	2023-11-30	67.05	29.22
ORCL	Oracle	1501	2017-12-13	50.05	2023-11-30	116.21	132.19
PACB	Pacific Biosciences	908	2020-04-24	3.22	2023-11-30	8.48	163.35
PANW	Palo Alto Networks	1370	2018-06-22	207.59	2023-11-30	295.09	42.15
PAYC	Paycom Software	1192	2019-03-11	181.16	2023-11-30	181.66	0.28
PEP	Pepsico Inc	1504	2017-12-08	116.57	2023-11-30	168.29	44.37
PETS	Pet Meds	966	2020-01-31	25.21	2023-11-30	6.93	-72.51
PFE	Pfizer Inc	1504	2017-12-08	35.74	2023-11-30	30.47	-14.75
PFPT	Proofpoint	1220	2018-06-22	119.67	2023-11-30	30.47	-74.54
PG	Procter & Gamble Co	1502	2017-12-12	89.85	2023-11-30	153.52	70.86
PHM	PulteGroup	1051	2019-09-30	36.55	2023-11-30	88.42	141.92
PJT	P J T Partners Inc Cl A	984	2020-01-06	43.52	2023-11-30	90.06	106.94
PLD	Prologis	1055	2019-09-24	84.22	2023-11-30	114.93	36.46
PRNHX	T. Rowe Price New Horizons	1493	2017-12-26	52.65	2023-11-30	50.95	-3.23
PXD	Pioneer	623	2021-06-11	162.90	2023-11-30	231.64	42.20
PYPL	PayPal Holdings	1443	2018-03-09	80.71	2023-11-30	57.61	-28.62
QCOM	Qualcomm	1142	2019-05-21	77.75	2023-11-30	129.05	65.98
QLYS	Qualys	1370	2018-06-22	88.80	2023-11-30	184.84	108.15
QQQ	Nasdaq big tech	1509	2017-12-01	154.49	2023-11-30	388.83	151.69
QRVO	Qorvo	1140	2019-05-23	60.66	2023-11-30	96.50	59.08
REGL	ProShares MidCap 400 Dividend Aristocrats	1378	2018-06-12	54.93	2023-11-30	69.22	26.01
RHT	Red Hat Inc	1451	2017-12-14	126.13	2023-11-30	69.22	-45.12
RNG	RingCentral	1197	2019-03-04	103.56	2023-11-30	28.46	-72.52
ROKU	Roku Inc Cl. A	1291	2018-10-15	61.69	2023-11-30	104.20	68.91
SAIL	Sailpoint Technologies	1040	2019-10-07	18.39	2023-11-30	104.20	466.61
SAVE	Spirit Airlines	671	2021-04-05	37.49	2023-11-30	104.20	177.94
SBAC	SBA Communications	1140	2019-05-23	210.03	2023-11-30	246.96	17.58
SBUX	Starbucks	1055	2019-09-24	89.92	2023-11-30	99.30	10.43
SCHW	Charles Schwab Corp	1390	2018-05-24	58.14	2023-11-30	61.32	5.47
SEDG	Solaredge Technologies	1197	2019-03-04	41.55	2023-11-30	79.38	91.05
SGMO	Sangamo Therapeutics	966	2020-01-31	7.33	2023-11-30	0.43	-94.13
SHOP	Shopify	1493	2017-12-26	104.84	2023-11-30	72.82	-30.54
SLG	SL Green	922	2020-04-03	39.79	2023-11-30	36.57	-8.09
SMH	VanEck Vectors Semiconductor ETF	1473	2018-01-25	104.60	2023-11-30	160.48	53.42
SNOW	Snowflake Inc	777	2020-09-16	253.93	2023-11-30	187.68	-26.09
SO	Southern Company	1504	2017-12-08	51.06	2023-11-30	70.98	39.01
SPG	Simon Property Group	1008	2019-11-29	151.21	2023-11-30	124.89	-17.41
SPLK	Splunk Inc	1500	2017-12-14	81.19	2023-11-30	151.54	86.65
SPOT	Spotify Technology	1370	2018-06-22	180.94	2023-11-30	185.11	2.30
SQ	Square	1197	2019-03-04	74.69	2023-11-30	63.43	-15.08
SRE	Sempra Energy	1443	2018-03-09	109.08	2023-11-30	72.87	-33.20
STX	Seagate Tech	1190	2019-03-13	47.68	2023-11-30	79.10	65.90
SWKS	Skyworks Solutions	1482	2018-01-11	99.92	2023-11-30	96.93	-2.99
SYMC	Symantec	1318	2018-06-22	20.72	2023-11-30	96.93	367.81
T	AT&T Inc	1504	2017-12-08	36.73	2023-11-30	16.57	-54.89
TCNNF	Trulieve Cannabis	898	2020-05-08	10.43	2023-11-30	5.55	-46.79
TDOC	Teledoc	1197	2019-03-04	63.13	2023-11-30	18.14	-71.27
TEAM	Atlassian	1379	2018-06-11	64.35	2023-11-30	190.95	196.74
TECH	Bio-Techne	1477	2018-01-19	140.72	2023-11-30	62.90	-55.30
TER	Teradyne	1457	2018-02-16	43.31	2023-11-30	92.23	112.95
TGT	Target Corp	671	2021-04-05	205.35	2023-11-30	133.81	-34.84
TIIHX	TIAA-CREF inflation bond	1344	2018-07-31	11.23	2023-11-30	10.39	-7.48
TLRY	Tilray Inc	1335	2018-07-19	22.39	2023-11-30	1.81	-91.92
TMHC	Taylor Morrison Home	1050	2019-10-01	25.58	2023-11-30	45.10	76.31
TMO	Thermo Fisher Scientific Inc	1477	2018-01-19	213.51	2023-11-30	495.76	132.20
TMUS	T-Mobile US Inc.	1140	2019-05-23	76.01	2023-11-30	150.45	97.93
TOL	Toll Brothers	1050	2019-10-01	40.27	2023-11-30	85.89	113.29
TPR	Tapestry brands	1359	2018-07-10	46.50	2023-11-30	31.67	-31.89
TRIP	Trip Advisor	873	2020-06-15	20.82	2023-11-30	17.83	-14.36
TRMB	Trimble	283	2022-10-17	54.50	2023-11-30	46.40	-14.86
TSLA	Tesla	1493	2017-12-26	317.29	2023-11-30	240.08	-24.33
TSM	Taiwan Semiconductor	940	2020-03-10	54.51	2023-11-30	97.31	78.52
TTD	TheTradeDesk	1197	2019-03-04	189.38	2023-11-30	70.46	-62.79
TWLO	Twilio Inc	1430	2018-03-28	37.43	2023-11-30	64.68	72.80
UBER	Uber Technologies	1149	2019-05-10	41.57	2023-11-30	56.38	35.63
UNH	United Healthcare	1508	2017-12-04	221.42	2023-11-30	552.97	149.74
UNP	Union Pacific	1056	2019-09-24	165.08	2023-12-01	231.37	40.16
UPS	United Parcel Service Inc Cl B	1503	2017-12-12	118.16	2023-12-01	154.91	31.10
USB	US Bancorp	923	2020-04-03	31.19	2023-12-01	39.38	26.26
USO	United States Oil ETF	1510	2017-12-01	11.67	2023-12-01	69.24	493.32
V	Visa Inc	1494	2017-12-26	112.99	2023-12-01	256.45	126.97
VAW	Vanguard Materials ETF	1506	2017-12-07	133.93	2023-12-01	183.09	36.71
VB	Vanguard Small-Cap Index Fund	1507	2017-12-06	145.31	2023-12-01	199.76	37.47
VBK	Vanguard Small-Cap Growth ETF	1507	2017-12-06	157.14	2023-12-01	225.14	43.27
VBR	Vanguard Small-Cap Value ETF	672	2021-04-05	168.31	2023-12-01	169.29	0.58
VCIT	Vanguard Intermediate Corp bond etf	1345	2018-07-31	83.94	2023-12-01	78.99	-5.90
VCLT	Vanguard long-term corp bond etf	1345	2018-07-31	89.16	2023-12-01	76.42	-14.29
VCR	Vanguard Consumer Staples ETF	1506	2017-12-07	153.17	2023-12-01	289.67	89.12
VDC	Vanguard Consumer Discretionary ETF	1506	2017-12-07	144.95	2023-12-01	187.70	29.49
VDE	Vanguard Energy ETF	1506	2017-12-07	93.80	2023-12-01	119.24	27.12
VEEV	Veeva Systems Inc. Cl A	1360	2018-07-10	79.45	2023-12-01	178.84	125.10
VFH	Vanguard Financials ETF	1510	2017-12-01	69.50	2023-12-01	87.88	26.45
VGSTX	Vanguard Star Fund Investor Shares	1503	2017-12-12	27.62	2023-12-01	26.97	-2.35
VGT	Vanguard Information Technology ETF	1506	2017-12-07	163.48	2023-12-01	464.65	184.22
VHT	Vanguard Health Care ETF	1506	2017-12-07	152.90	2023-12-01	240.15	57.06
VIG	Vanguard Dividend Appreciation ETF	1377	2018-06-14	104.50	2023-12-01	165.77	58.63
VIGRX	Vanguard Growth Index Inv	1510	2017-12-01	71.82	2023-12-01	154.33	114.88
VIOV	Vanguard S&P Small Cap Value ETF	874	2020-06-15	105.49	2023-12-01	81.18	-23.04
VIS	Vanguard Industrial ETF	1506	2017-12-07	139.84	2023-12-01	209.01	49.46
VIVAX	Vanguard Value Index Inv	1510	2017-12-01	41.03	2023-12-01	56.40	37.46
VMBS	Vanguard Mortgage Backed Securities ETF	577	2021-08-18	53.42	2023-12-01	45.14	-15.50
VMC	Vulcan Materials	1055	2019-09-25	150.88	2023-12-01	215.63	42.91
VMW	VMware Inc	1499	2017-12-14	121.25	2023-12-01	215.63	77.84
VNM	VanEck Vectors Vietnam ETF	1438	2018-03-19	19.16	2023-12-01	13.31	-30.53
VNQ	Vanguard Real Estate ETF	1506	2017-12-07	83.60	2023-12-01	83.74	0.17
VOE	Vanguard Mid-Cap Value ETF	379	2022-06-01	144.11	2023-12-01	139.45	-3.23
VOX	Vanguard Communication Services ETF	1404	2018-05-07	83.49	2023-12-01	112.50	34.75
VPL	Vanguard Pacific etf	367	2022-06-17	63.03	2023-12-01	70.12	11.25
VPU	Vanguard Utilities ETF	1507	2017-12-06	122.58	2023-12-01	136.99	11.76
VRT	Vertiv Holdings	1035	2019-10-23	10.27	2023-12-01	45.14	339.53
VT	Vanguard Total World ETF	984	2020-01-07	81.12	2023-12-01	99.46	22.61
VTI	Vanguard Total Market	1510	2017-12-01	136.07	2023-12-01	228.17	67.69
VTIP	Vanguard Short Term Inflation Protected Securities ETF	1503	2017-12-12	49.49	2023-12-01	47.75	-3.52
VWEHX	Vanguard High-Yield Corporate Fund	1098	2019-07-25	5.87	2023-12-01	5.29	-9.88
VWIGX	Vanguard International Growth	1397	2018-05-16	31.88	2023-12-01	31.41	-1.47
VWITX	Vanguard int term tax-exempt bond	523	2021-11-03	14.67	2023-12-01	13.51	-7.91
VWO	Vanguard FTSE Emerging Markets ETF	1510	2017-12-01	44.05	2023-12-01	40.80	-7.38
VWOB	Vanguard Emerging Mkts Govt Bd ETF	1292	2018-10-15	74.81	2023-12-01	61.96	-17.18
VXUS	Vanguard Total Int'l Stock ETF	1506	2017-12-07	55.64	2023-12-01	56.49	1.53
VYM	Vanguard High Dividend Yield ETF	1376	2018-06-15	85.34	2023-12-01	107.84	26.37
VZ	Verizon Communications	1505	2017-12-08	51.09	2023-12-01	38.58	-24.49
WBD	Warner Bros Discovery	642	2021-05-17	33.85	2023-12-01	11.33	-66.53
WCLD	Wisdom Tree Cloud Computing ETF	1046	2019-10-08	23.80	2023-12-01	32.68	37.31
WDAY	WorkDay Inc	1501	2017-12-14	103.35	2023-12-01	272.92	164.07
WE	WeWork	421	2021-10-21	11.78	2023-12-01	272.92	2,216.81
WFC	Wells Fargo	1360	2018-07-10	56.62	2023-12-01	45.02	-20.49
WMT	Walmart	1494	2017-12-26	99.16	2023-12-01	154.34	55.65
WORK	Slack	960	2019-06-20	38.62	2023-12-01	154.34	299.64
XOM	Exxon Mobil	1505	2017-12-08	82.66	2023-12-01	102.99	24.59
YETI	Yeti	119	2018-09-25	0.00	2022-04-14	87.83	inf
ZM	Zoom	1260	2018-10-25	17.00	2023-12-01	70.29	313.47
ZS	Zscaler	1370	2018-06-25	36.36	2023-12-01	198.03	444.64
ZTS	Zoetis Inc Cl A	1505	2017-12-08	71.88	2023-12-01	179.13	149.21
^GSPC	S&P 500 Index	1504	2017-12-01	2,642.22	2023-12-01	4,594.63	73.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