I'm sending you a separate file with the Excel formulas.
For others who don't have the formulas, you might be able to get an Excel Vidya template at a site Richard mentioned: halcyon.com
I was unable to reach the site ("Not available on this server"), but maybe some people can get through, if it's still up.
I've also posted at my charts page HyperSnaps of the top of an EXcel Vidya spreadsheet, to give you an idea of what they're supposed to look like.
members.aol.com
Once you've created a Vidya Excel template, you can calculate Vidya in it with WOW data and plot it in WOW. Here's how:
First, export data for a stock (AMES, for example) from WOW to Excel, using the "Comma separated price data" option for CSV files in WOW. Call this file "Ames1," for example, and save it as a CSV file in your Excel directory.
Now paste into "Vidya Template," right down the columns, everything from these categories in "Ames1": Date, Open, High, Low, and Close. You have to use "Special Paste" to paste just the values, not the formulas. "Special Paste" is under "Paste" in "Edit." Make sure you put the new E9 into K9 in "Vidya Template," too. Go to the bottom of the file and make sure every column is the same length, or the importing program (WOW) won't accept the data. Once "Vidya Template" is set up with all the new data from Ames1, with Vidya automatically calculated down column K, starting at K9, save the file as an Excel document.
In "Vidya Template," copy everything down column K, all the Vidya data, open Ames1 again and paste into column B in Ames1. Normally, "open" price data goes in column 1. Now it's Vidya data. Make sure you have the right Vidya data for the right date (checking with the template), and that the columns are all even at the bottom of the file. Save the file as a CSV file. Now you have two files, the template that you used to get Vidya and the CSV file which has been revised with one column of Vidya data.
Go back to WOW and import the CSV file, Ames1. When you bring up this "stock," called "Ames1," there will be a dotted line running through the price line. This is called "open," but it's really Vidya. If you don't think the dotted Vidya line is clear enough, change it to a solid line and change the color. If there is no dotted line representing "open" (really Vidya now), but only the price, create this formula in indicators: open. That's it: open. Plot "open" (really Vidya) in the same window as price. (Sometimes, for some odd reason, the dotted line representing open fails to appear at first, but the "open" plot gets around that.)
Now, it's easy to do the Vidya bands in WOW. Create these formulas for the upper and lower bands: Upper Vidya band: open+var*open Lower Vidya band: open-var*open where the default value is .01 (.03 works better with small caps) Remember, with this weird new Vidya chart, "open" is actually Ames' Vidya, which you substituted for "open" when you were in Excel.
If you don't think the dotted Vidya line is clear enough, change it to a solid line, and change the color.
But enough of these Vidya games. |
