Post by metro on Aug 20, 2019 6:50:38 GMT -5
looking for some help in doing this more eloquently, each day I select a cell's worth of data from here www.morningstar.com.au/Stocks/CorpCalendar
I'm looking to display the result in a more meaningful way and hoped to get some constructive criticism of my current approach.
struggling with a little brain fog ATM
so far I can only think of one approach I will then insert each event into a database of selection criteria for stocks to watch
thanks in advance
mystring$ ="AGM: IFT, LCY, PYG Books Close: AGL, BFG, SGR, TAH Div Ex Date: ANZPD, DHG, HGH, JBH, KOV, NCM, QBE Div Pay Date: CGFPB, GCM Report (Annual): ADA*, AIA*, AIZ*, AMT*, APD*, APT*, BGT*, CAF*, CAN*, CVF*, CVW*, EBO*, ECL*, EVS*, FLT*, FSA*, GCM*, GDF*, GDG*"
mystring$ =mystring$ + ", HPI*, IDX*, IMF*, ISD*, JIN*, LAU*, MAM*, NCC*, NSC*, NST*, OZG*, PAF*, PSQ*, SGP*, WEB*, WIC*, WTP* Report (Interim): APO*, ARQ*, AWC*, BLY*, CYC*, HGO*, IBX*, IRE*, NZM*, STO*, TFL*, VPR*, VVR* Report (Prelim): ADA*, AIA*, AIZ*, AMT*, APD*, APT*, ARA*"
mystring$ =mystring$ + ", BGT*, CAF*, CAN*, CGR*, CLH*, CMW*, CVF*, CVW*, DDT*, EBO*, ECL*, EMB*, EPW*, EVS*, EVT*, FLT*, FSA*, GCM*, GDF*, GDG*, GLB*, HPI*, HZN*, IDX*, IEL*, IMF*, ISD*, KSC*, LAU*, MAM*, MCE*, NAC*, NCC*, NEC*, NSC*, NST*, NVO*, NWH*, OZG*, PAF*, PBP*, "
mystring$ =mystring$ + ",PPC*, PSQ*, PTM*, PWH*, QAN*, QUB*, RBL*, RMC*, S32*, SGP*, SPZ*, SSG*, SXL*, TGG*, VRL*, VVR*, WAT*, WEB*, WIC*, WTP*, ZER"
AGM$= upto$(mystring$,"Books Close:")
print AGM$
BooksClosed$= after$(mystring$,AGM$)
BooksClosed$= upto$(BooksClosed$," Div Ex Date:")
print BooksClosed$
DivExdate$=after$(mystring$,BooksClosed$)
DivExdate$=Upto$(DivExdate$,"Div Pay Date:")
print DivExdate$
DivPaydate$= after$(mystring$,DivExdate$)
DivPaydate$= upto$(DivPaydate$,"Report (Annual):")
print DivPaydate$
ReportAnnual$= after$(mystring$,DivPaydate$)
ReportAnnual$= upto$(ReportAnnual$,"Report (Interim):")
print ReportAnnual$