samerh 6 Report post Posted September 20, 2013 Does anyone know how to get a table of historical data on VXAPL from yahoo finance or any other site? for example these work for VIX, but not VXAPL: http://www.nasdaq.com/symbol/vix/historical or http://finance.yahoo.com/q/hp?s=%5EVIX+Historical+Prices Thanks Share this post Link to post Share on other sites
Marco 223 Report post Posted September 20, 2013 try google finance https://www.google.com/finance/historical?q=INDEXCBOE%3AVXAPL&ei=J3k8UqnFKuj6wAOyfQ 1 Share this post Link to post Share on other sites
samerh 6 Report post Posted September 20, 2013 Great, thanks Share this post Link to post Share on other sites
tjlocke99 18 Report post Posted September 26, 2013 Marco, He could use that spreadsheet that calculates std deviation that you have. I don't want to post it because its yours, but that builds a worksheet with historical data on any stock you choose. He could ignore the worksheet on std dev and just use worksheet it builds on the daily open low high close. Share this post Link to post Share on other sites
Marco 223 Report post Posted September 26, 2013 Marco, He could use that spreadsheet that calculates std deviation that you have. I don't want to post it because its yours, but that builds a worksheet with historical data on any stock you choose. He could ignore the worksheet on std dev and just use worksheet it builds on the daily open low high close. Post it if u like, it depends on yahoo data though and they don't have VXAPL for some reason Share this post Link to post Share on other sites
samerh 6 Report post Posted September 26, 2013 Thanks guys, the excel isn't a problem was more a question of where to source the data. Appreciate it. Share this post Link to post Share on other sites