Phoenix - Your AI AssistantSpreadsheet with Kagi chart
- Posted:
- Proposals: 3
- Remote
- #2501010
- Awarded
have already sent a proposal. Description
Experience Level: Entry
Estimated project duration: 1 day or less
Hi. Are you familiar with technical trading charts? I need a Google Sheet and a Kagi Chart. It needs 6 columns: Date - Open Price - Close Price - High Price - Low Price - ATR (Average True Range).
Date, Open, High, Low, Close are inputs. I will load my own once you have delivered the file. You can collect any data you like to create this template from this source:
https://finance.yahoo.com/quote/%5EFTSE%3FP%3DFTSE/history/
ATR is a very simple calculation:
https://www.investopedia.com/terms/a/atr.asp
The outputs I expect will be in google sheets and include:
1. A 7th column with Kagi value for each date that is used to plot the graph
2. Kagi Chart. This can be in google sheets or any other tool but must link to the google sheet data.
The sheet should be simple to extend the date/data range and the calcs and graph follow. I need this quick. Can you help? Thanks Nick
Date, Open, High, Low, Close are inputs. I will load my own once you have delivered the file. You can collect any data you like to create this template from this source:
https://finance.yahoo.com/quote/%5EFTSE%3FP%3DFTSE/history/
ATR is a very simple calculation:
https://www.investopedia.com/terms/a/atr.asp
The outputs I expect will be in google sheets and include:
1. A 7th column with Kagi value for each date that is used to plot the graph
2. Kagi Chart. This can be in google sheets or any other tool but must link to the google sheet data.
The sheet should be simple to extend the date/data range and the calcs and graph follow. I need this quick. Can you help? Thanks Nick
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.