Archive: Need Excel Trading Tool

Budget 255$ per month

Posted: 5 years ago

Closed

Description: Need a simple Excel Tool (for Mac!!! not Windows)
a) Import daily closing price from Yahoo finance or similar free source
b) Calculate Moving average value (2 moving averages), have a drop down menu where I can select the value of a moving average in 5 day increments from 10 days to 200 days
c) Create a signal if the faster moving average crosses the smaller one either UP or DOWN
d) ideally create an alert on a cross over or simply have a function that color codes the change
e) show a chart with that updates daily as well with the moving average selected and the price
Excel sheet has ~ 20 tabs for 20 different stocks
Skills:
microsoft windows,software development,Visual Basic programming language