I am interested in doing some Risk Profiling like V. Sperandeo outlined in his book Methods of a Wall Street Master. However, my idea was to do the analysis on the treasury market rather than the stock averages.
In gathering my data the Federal Reserve Board of Governors home page lists Treasury prices back to 1962 which is a pretty good sample. However, whenever or however I try to import this data into Excel I can not get the values to import as comma or space seperated values.
What I'm currently doing is copying and pasting the data into a text file. Then I go to open that file in Excel which automatically opens the import 'wizard'. Although I've downloaded lots of comma and space seperated data in the past I have no such luck with this series. It just pastes the data into continous rows rather than keep the web page format of two columns. One column for the date, the other column for the rate that day.
If I can't figure out an automated way to do it I estimate I'll have to mouse click and hit the return key for every business day back to 1962 to create a file where every day is in a column and the corresponding interest rate is in a column beside that. While this could be done I estimate it would be roughly 240 business days per year * 40 years or over 10, 560 clicks. This may give me a good finger cramp!
Any suggestions?
In gathering my data the Federal Reserve Board of Governors home page lists Treasury prices back to 1962 which is a pretty good sample. However, whenever or however I try to import this data into Excel I can not get the values to import as comma or space seperated values.
What I'm currently doing is copying and pasting the data into a text file. Then I go to open that file in Excel which automatically opens the import 'wizard'. Although I've downloaded lots of comma and space seperated data in the past I have no such luck with this series. It just pastes the data into continous rows rather than keep the web page format of two columns. One column for the date, the other column for the rate that day.
If I can't figure out an automated way to do it I estimate I'll have to mouse click and hit the return key for every business day back to 1962 to create a file where every day is in a column and the corresponding interest rate is in a column beside that. While this could be done I estimate it would be roughly 240 business days per year * 40 years or over 10, 560 clicks. This may give me a good finger cramp!
Any suggestions?