** Fundamental quarterly
use “C:Users22830043Downloads10yearQuarerly.dta”, clear
gen year_quarter = yq(fyearq, fqtr)
format year_quarter %tq

* Average Revenue
preserve
collapse (mean) revtq, by(year_quarter)
tsset year_quarter
tsline revtq, title(“Average Quarterly Revenue”) ytitle(“Average Revenue (revtq) (AUD Millions)”) xtitle(“Year and Quarter”)
graph export “C:Users22830043Downloadstsline_avg_total_Revenue.png”, replace
restore

* Average Assets
preserve
generate roa = ibq / atq
collapse (mean) roa, by(year_quarter)
tsset year_quarter
tsline roa, title(“Average Quarterly Assets”) ytitle(“Average Return on Assets (roa) (AUD Millions)”) xtitle(“Year and Quarter”)
graph export “C:Users22830043Downloadstsline_avg_total_roa.png”, replace
restore

* Average Long term debt
preserve
collapse (mean) dlttq, by(year_quarter)
tsset year_quarter
tsline dlttq, title(“Average Quarterly Long-term Debt”) ytitle(“Average Long-Term Debt (dlttq) (AUD Millions)”) xtitle(“Year and Quarter”)
graph export “C:Users22830043Downloadstsline_avg_total_dlttq.png”, replace
restore

** Security Monthly
use “C:Users22830043DownloadssecurityMonthly.dta”, clear
gen year_month = ym(year(datadate), month(datadate))
format year_month %tm

* Price Volatility
preserve
gen volatility = prchm – prclm
collapse (mean) volatility, by(year_month)
tsset year_month
tsline volatility, title(“Average Monthly Price Volatility”) ///
ytitle(“Price Range”) xtitle(“Year Month”) ///
graphregion(color(white))
graph export “C:Users22830043Downloadstsline_avg_total_volatility.png”, replace
restore

* Trading Volume
preserve
collapse (mean) prccm, by(year_month)
tsset year_month
tsline prccm, title(“Average Monthly Trading Volume”) ///
ytitle(“Volume (AUD Millions)”) xtitle(“Year Month”) ///
graphregion(color(white))
graph export “C:Users22830043Downloadstsline_avg_total_prccm.png”, replace
restore

**