Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Hi,
I recently purchased intraday data to perform backtesting on. The data contained the date, time, OHLC, VWAP values, volume and number of trades. I cleaned the data (deleted VWAP column) and imported it using ASCII mapping. I wasn't able to construct VWAP using the actual indicator I have coded in Multicharts (because it uses up/down ticks to construct). So, I constructed a new symbol and called it VWAP, then imported the values that came with the data, and inserted it in the chart as an instrument. This works fine, I have the data instrument and VWAP drawn on it. My question is: was there a better way to do this? Also what's the best way to go about constructing the VWAP bands?
Can you help answer these questions from other members on NexusFi?
one way to accomplish this via an indicator would be to read the file using EasyLanguage Collections and then plot the values. It will require some programming and if your method works for you, there might not be a reason to change it.
Ok Thank you. I was just reading a few threads that talk about how to reference a .csv file. My workarounds works for now but I will probably try to do it the correct way. My main goal right now is to figure out how to construct the bands around the VWAP, any tips?
you would have to elaborate what kind of bands you are looking for. Otherwise the tips might not be too helpful for you. Check the Bollinger Bands and the Keltner Channel indicators for two types of bands around an average.
great, if it gives you the results you are looking for. I am just not clear where you'd use the high/low/typical price (or what ever price) in the computation for the standard deviation of the VWAP.