Review Sometimes I am better than AI

[Graybeard]

Time to alter code what is the easiest way AI?
Sometimes, it's plain easier not to waste time to `get er done`
Who's the teacher and who is the student here?

My date cheat sheet --should have looked first! This is MySQL specific however (copied from a search a few years ago):

The following specifiers can be used to specify the return format. The format value must start with a percentage sign (%).
Specifier Description
%a Abbreviated weekday name (Sun..Sat)
%b Abbreviated month name (Jan..Dec)
%c Month, numeric (0..12)
%D Day of the month with English suffix (0th, 1st, 2nd, 3rd, …)
%d Day of the month, numeric (00..31)
%e Day of the month, numeric (0..31)
%f Microseconds (000000..999999)
%H Hour (00..23)
%h Hour (01..12)
%I Hour (01..12)
%i Minutes, numeric (00..59)
%j Day of year (001..366)
%k Hour (0..23)
%l Hour (1..12)
%M Month name (January..December)
%m Month, numeric (00..12)
%p AM or PM
%r Time, 12-hour (hh:mm:ss followed by AM or PM)
%S Seconds (00..59)
%s Seconds (00..59)
%T Time, 24-hour (hh:mm:ss)
%U Week (00..53), where Sunday is the first day of the week; WEEK() mode 0
%u Week (00..53), where Monday is the first day of the week; WEEK() mode 1
%V Week (01..53), where Sunday is the first day of the week; WEEK() mode 2; used with %X
%v Week (01..53), where Monday is the first day of the week; WEEK() mode 3; used with %x
%W Weekday name (Sunday..Saturday)
%w Day of the week (0=Sunday..6=Saturday)
%X Year for the week where Sunday is the first day of the week, numeric, four digits; used with %V
%x Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v
%Y Year, numeric, four digits
%y Year, numeric (two digits)
%% A literal % character
%x x, for any “x” not listed above

Simple huh

 

[Graybeard]

AI's 5th try cat list.txt | sed -e 's/<[^>]*>//g' -e 's/\s/+/g' -e 's/++*/|/g'

09-29-2023|6-K|1687451|ZK|International|Group|Co.,|Ltd.
09-29-2023|NT|20-F|1896511|ZKGC|New|Energy|Ltd
09-29-2023|144|1423774|ZUORA|INC
09-29-2023|CERT|1760588|Zacks|Trust
09-29-2023|3|1994745|Zirkin|Adam|Ross
09-29-2023|8-K|1794515|ZoomInfo|Technologies|Inc.

My code [spaghetti code ] cat list.txt | sed -e 's/<[^>]*>//g' -e 's/\s\s*/|/g' -e 's/|/ /4' -e 's/|/ /4' -e 's/|/ /4'

09-29-2023|6-K|1687451|ZK International Group Co.,|Ltd.
09-29-2023|NT|20-F|1896511 ZKGC New Energy|Ltd
09-29-2023|144|1423774|ZUORA INC
09-29-2023|CERT|1760588|Zacks Trust
09-29-2023|3|1994745|Zirkin Adam Ross
09-29-2023|8-K|1794515|ZoomInfo Technologies Inc.
09-29-2023|SC|14D9/A|1621443 Zynerba Pharmaceuticals, Inc.

I beat the machine.

The purpose is to find all the day's form 4 insider trading buys and sales of stocks, that by law must be reported, by the CIK number that is my key (like [keyword]) matching the ticker symbol in my database.

Look all the form 4's files for the day!

#massive one-liner

$ cat list.txt | sed -e 's/<[^>]*>//g'  -e 's/\s\s*/|/g' -e 's/|/ /4' \
-e 's/|/ /4' -e 's/|/ /4' |grep '|4|'|sort|uniq -c |sort -nr|less

Ranked by the most filings that day -- when insiders buy the stock price often goes up ---- when insiders sell the stock price often goes down.

But I am the first in line before the various financial news services will report it days ahead (I hope). That is the tactical maneuver. I can bot this and automate it and have a list waiting for me in the morning first thing.

this is the page where my 'registered' bot "User-Agent: Mozilla/5.0 Paragon/1.0 goes (public data): EDGAR Current Events

Total form 4: 656/4968 or13.20%
Suspect form 4:1 26/4968 made my List as shown or 2.536%
That might be worth my time to further investigate. Maybe 4 of the 17 stock may prove interesting.

Point is: Now I have narrowed the search from the list of 490 to 17 lookup and research. Tomorrow I will try to get the exact location so my bot can retrieve the files. the files are in XML or JSON format and they can be parse with PHP or python then loaded in a table on my database.

17 09-29-2023|4|1006830|CONSUMERS BANCORP INC /OH/
12 09-29-2023|4|16732|CAMPBELL SOUP C
10 09-29-2023|4|93676|STARRETT L S CO
9 09-29-2023|4|318306|
8 09-29-2023|4|1326190|Altimmune, Inc.
8 09-29-2023|4|107140|JOHN WILEY & SONS,|INC.
7 09-29-2023|4|750577|HANCOCK WHITNEY CORP
6 09-29-2023|4|96021|SYSCO CORP
6 09-29-2023|4|821189|EOG RESOURCES INC
6 09-29-2023|4|1819404|Nerdy Inc.
6 09-29-2023|4|1814329|Astra Space, Inc.
6 09-29-2023|4|1113169|PRICE T ROWE GROUP|INC
5 09-29-2023|4|1812364|Relay Therapeutics, Inc.
5 09-29-2023|4|1635088|Roivant Sciences Ltd.
5 09-29-2023|4|1598646|Minerva Neurosciences, Inc.
5 09-29-2023|4|1001614|Riley Exploration Permian, Inc.
5 09-29-2023|4|1001316|TG THERAPEUTICS, INC.

AI `gets it` and explains my tactical maneuver:
Need a to-do list and an organized plan? --Ask AI to lay it out for you ...

Thanks for coming to my TED Talk!