Phoenix - Your AI AssistantNeed Excel Trading Tool
- Posted:
- Proposals: 3
- Remote
- #2423525
- OPPORTUNITY
- Awarded
have already sent a proposal. Description
Experience Level: Expert
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
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
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.