Recent Changes

Wednesday, September 20

  1. page Download Webpages or Files to Excel edited ... Maybe the best file to get lot of economic and financial date for the U.S. as well as for othe…
    ...
    Maybe the best file to get lot of economic and financial date for the U.S. as well as for other countries is data tabulated by the St. Louis Fed. The data collection is called FRED which stands for the Federal Reserve Economic Database. This website has data on credit spreads, all kinds on exchange rates, LIBOR and EURIBOR swap rates for different terms, term structure of interest rates and a whole lot of other data. One of the problems with getting data so that you can put stuff together and automatically update the files is that the old text files have been taken away from the website. But I demonstrate that this does not matter. This is because you can still use the old links from codes that are associated with each database to put the data into text files.
    The file that you can download below goes to the St. Louis Fed database (FRED) and gets a bunch of data including credit spreads, interest rates, interest rate swaps, term structure etc. As with other files, the WORBOOKS.OPEN is the basis for the analysis. A second file includes upload of yield curves so you can analyse the term structure of interest rates. The St. Louis Fred has an app that may be helpful, but I think doing this stuff yourself has many advantages.
    {Interest Rates.xlsm} {Yield{Yield Curve Analysis.xlsm} {Interest Rates No List Box.xlsm}
    Cost of Capital and Valuation Multiples Databases
    In analysing corporate finance I am obsessed with things like using the value driver formula (1-g/ROIC)/(WACC-g) and demonstrating its flaws. I also go crazy about finding alternatives to the CAPM with market to book analysis and use of the P/E ratio. The files below go to the different financial websites including market watch.com, finance.yahoo.com and the St. Louis Fed to gather data to evaluate the cost of capital and multiples. The file computes cost of capital using different techniques including CAPM, P/E ratios, P/B ratios and EV/EBIT ratios.
    ...
    Commodity Price History and Forecast Database
    I think there are a few sources for financial and economic data that are really good. One of the sources is the world bank data base that records and updates commodity prices called for some reason pink data. On this World Bank web site you can download monthly nominal prices since 1960 for more than 100 commodity price series. The workbook file listed below goes to the pink data part of the world bank website and updates historic commodity price data as well as forecast data published by the world bank. To update the history data you just have to press the macro button. The file allows you to analyse historic data and compare forecast and projected data for a large series of commodity prices. You can update the file every month or couple of months and you can use the file to perform statistical analysis of the various commodity prices. The historic data can be updated very easily by pressing the macro button. To update reading of the forecast you have to look-up the link that sometimes changes. You can also find commodity price data on the FRED database. The second file goes to the FRED database and puts together a whole bunch of the commodity price series.
    {Interest Rates{Commodity Price Analysis No List
    Reading Forward Natural Gas, Oil, and Electricity Futures Prices from CME
    I and some of my clients use futures prices for oil, natural gas and electricity to make forecasts. When you go to the CME website and copy the data into an excel file it can be a pain. One of the big problems is that dates are expressed in different formats and the data is read into files with different spaces. The file below (which is of course transparent like all of the other files) reads data from the CME on futures prices for oil, natural gas, U.S. electricity, gas basis spreads, diesel oil and coal. The data is in different places, there is a bunch of crap above the data and the data has spaces between the futures data. The file below solves these problems. It reads data from the NYMEX website and tabulates futures prices for oil and gas. By pressing on one button you can update your forecasts and analysis very quickly. As with the other files, if you want to use it, you just press the read files button and all is done.
    (view changes)
    2:35 am
  2. page Home edited ... he files below have been recently revised and improved; other recently added files are at the …
    ...
    he files below have been recently revised and improved; other recently added files are at the bottom of the page. Not many people try these files, but out of the thousands of files on the site they may be the best. You can read pdf files to excel and create waterfall graphs in seconds and use a bunch of helpful macros.
    {Waterfall Charts 2010.xlsm} {Read PDF to Excel.xlsm} {Scenario Reporter.xlsm} {Lookup and Interpolate.xlsm} {Generic Macros.xlsm} {Read PDF to Excel Korean.xlsm}
    Links for KBI
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8Y1VWNVNtQlhyRGc&usp=sharing
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8Y1VWNVNtQlhyRGc?usp=sharing
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8Wk9pRGtReGxvUjA&usp=sharing
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8Skxzc2ZRZWM1U0k?usp=sharing
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8V0JXS1BBa09WbGs&usp=sharing

    Email: edwardbodmer@gmail.com
    Skype: edward.bodmer
    (view changes)
    1:33 am

Monday, September 18

  1. page Home edited ... https://drive.google.com/drive/folders/0B5r4OP_dQLe8Skxzc2ZRZWM1U0k?usp=sharing https://drive…
    ...
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8Skxzc2ZRZWM1U0k?usp=sharing
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8V0JXS1BBa09WbGs&usp=sharing
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8ZndUTEw2bUg2aW8?usp=sharing
    Email: edwardbodmer@gmail.com
    Skype: edward.bodmer
    (view changes)
    11:34 pm
  2. page Home edited ... {Waterfall Charts 2010.xlsm} {Read PDF to Excel.xlsm} {Scenario Reporter.xlsm} {Lookup and …
    ...
    {Waterfall Charts 2010.xlsm} {Read PDF to Excel.xlsm} {Scenario Reporter.xlsm} {Lookup and Interpolate.xlsm} {Generic Macros.xlsm} {Read PDF to Excel Korean.xlsm}
    Links for KBI
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8NUtzRVVZNHYzY2s&usp=sharinghttps://drive.google.com/folderview?id=0B5r4OP_dQLe8Y1VWNVNtQlhyRGc&usp=sharing
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8Y1VWNVNtQlhyRGc?usp=sharing
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8Wk9pRGtReGxvUjA&usp=sharing
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8Skxzc2ZRZWM1U0k?usp=sharing
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8V0JXS1BBa09WbGs&usp=sharing
    https://drive.google.com/drive/folders/0B5r4OP_dQLe8ZndUTEw2bUg2aW8?usp=sharing

    Email: edwardbodmer@gmail.com
    Skype: edward.bodmer
    (view changes)
    11:32 pm
  3. page Download Webpages or Files to Excel edited ... Commodity Price History and Forecast Database I think there are a few sources for financial a…
    ...
    Commodity Price History and Forecast Database
    I think there are a few sources for financial and economic data that are really good. One of the sources is the world bank data base that records and updates commodity prices called for some reason pink data. On this World Bank web site you can download monthly nominal prices since 1960 for more than 100 commodity price series. The workbook file listed below goes to the pink data part of the world bank website and updates historic commodity price data as well as forecast data published by the world bank. To update the history data you just have to press the macro button. The file allows you to analyse historic data and compare forecast and projected data for a large series of commodity prices. You can update the file every month or couple of months and you can use the file to perform statistical analysis of the various commodity prices. The historic data can be updated very easily by pressing the macro button. To update reading of the forecast you have to look-up the link that sometimes changes. You can also find commodity price data on the FRED database. The second file goes to the FRED database and puts together a whole bunch of the commodity price series.
    {Commodity Price Analysis.xlsm}{Interest Rates No List Box.xlsm}
    Reading Forward Natural Gas, Oil, and Electricity Futures Prices from CME
    I and some of my clients use futures prices for oil, natural gas and electricity to make forecasts. When you go to the CME website and copy the data into an excel file it can be a pain. One of the big problems is that dates are expressed in different formats and the data is read into files with different spaces. The file below (which is of course transparent like all of the other files) reads data from the CME on futures prices for oil, natural gas, U.S. electricity, gas basis spreads, diesel oil and coal. The data is in different places, there is a bunch of crap above the data and the data has spaces between the futures data. The file below solves these problems. It reads data from the NYMEX website and tabulates futures prices for oil and gas. By pressing on one button you can update your forecasts and analysis very quickly. As with the other files, if you want to use it, you just press the read files button and all is done.
    (view changes)
    11:25 pm
  4. page Home edited ... he files below have been recently revised and improved; other recently added files are at the …
    ...
    he files below have been recently revised and improved; other recently added files are at the bottom of the page. Not many people try these files, but out of the thousands of files on the site they may be the best. You can read pdf files to excel and create waterfall graphs in seconds and use a bunch of helpful macros.
    {Waterfall Charts 2010.xlsm} {Read PDF to Excel.xlsm} {Scenario Reporter.xlsm} {Lookup and Interpolate.xlsm} {Generic Macros.xlsm} {Read PDF to Excel Korean.xlsm}
    Links for KBI
    https://drive.google.com/folderview?id=0B5r4OP_dQLe8NUtzRVVZNHYzY2s&usp=sharing

    Email: edwardbodmer@gmail.com
    Skype: edward.bodmer
    (view changes)
    10:35 pm
  5. page Home edited ... {LCOE.JPG} he files below have been recently revised and improved; other recently added file…
    ...
    {LCOE.JPG}
    he files below have been recently revised and improved; other recently added files are at the bottom of the page. Not many people try these files, but out of the thousands of files on the site they may be the best. You can read pdf files to excel and create waterfall graphs in seconds and use a bunch of helpful macros.
    ...
    {Generic Macros.xlsm} {Read PDF to Excel Korean.xlsm}
    Email: edwardbodmer@gmail.com
    Skype: edward.bodmer
    (view changes)
    10:15 pm

More