Expires in:
Turning Bullish
Your Objective
Your Objective
Your dataset for this drill contains daily closing prices for the SPDR S&P 500 ETF Trust (SPY) over the last 5 years.
Your task is to calculate the 50-day and 200-day moving averages based on the closing price, and identify every “Golden Cross” moment – when the short-term average (50-day) crosses from below to above the long-term average (200-day) – signaling a potential bull market.
To complete the drill, create a table containing the date, close price, and three new columns:
50-day moving average: The average closing price for the last 50 trading days, calculated for each date
200-day moving average: The average closing price for the last 200 trading days, calculated for each date
Golden Cross: A binary field (1/0) that equals 1 only on the exact date when the 50-day average crosses from below the 200-day average; otherwise 0
Submit your solution
What was the close price on the date of the most recent "golden cross"? (numbers only, no currency symbols)
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in data literacy, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in data literacy, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
FOR INDIVIDUALS
Master modern data skills
Start learning for Free. No credit card required. Master skills in data literacy, Excel, Power BI, SQL, Python and more.
FOR COMPANIES & TEAMS
Train your team in data
Create your team account today, request a demo, or start with a team assessment today.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER