Analisis Financiero Con Microsoft Excel Apr 2026

El uso de Excel permite aplicar diversas metodologías de examen de datos financieros:

El análisis financiero con Microsoft Excel es una práctica esencial en el mundo de los negocios para transformar datos contables en información estratégica para la toma de decisiones. A través de funciones matemáticas, lógicas y financieras, los analistas pueden evaluar la salud económica de una empresa, proyectar escenarios futuros y determinar la viabilidad de inversiones. Técnicas Fundamentales de Análisis Analisis Financiero con Microsoft Excel

Ad-hoc analysis of finance data - Business Central - Microsoft Learn El uso de Excel permite aplicar diversas metodologías

Click Here to Leave a Comment Below

Analisis Financiero con Microsoft Excel
Sergey V. - November 17, 2016 Reply

Hi Caesar,

Thanks for interesting post. Sure credibility of backtest on simulated data depends on how precise your synthetic data is and how quickly your signal changes.

For 1-yr momentum there is one story, and you may use less precise data, and for 5-days reversion – completely different story, and you need much better data to test this.

BTW, six figs. investment have OHLC data on volatility ETPs: https://sixfigureinvesting.com/2014/09/simulating-open-high-low-vxx-vixy-tvix-uvxy-xiv-svxy/, maybe you could use this to trade not on closes of the same day (which may be not that realistic, given wild nature of the instruments involved)

    Analisis Financiero con Microsoft Excel
    Cesar Alvarez - November 17, 2016 Reply

    I am aware of the OHL simulated data but the amount of error he decribes is too much for me. The main thing I want to make sure people are clear is that the data may or may not work for you depending on the strategy. Just be careful using this data.

Analisis Financiero con Microsoft Excel
Michael - November 18, 2016 Reply

hi cesar, would you consider adding a search functionality to your blog so we can easily look up past blogs or topics?

    Analisis Financiero con Microsoft Excel
    Cesar Alvarez - November 18, 2016 Reply

    I can see when I am logged in as my WordPress admin but when I look at the site logged out I can’t see the search feature. I will have to look around and figure out how to get it back. Thanks for pointing this out.

Analisis Financiero con Microsoft Excel
michael - May 24, 2017 Reply

hi cesar, did you build your own synthetic data to run your tests? i recently ran some tests using the data from six figures investing. although the results over the overlap period were qualitatively similar, good years were good and worse years were worse etc, quantitatively they were very different with variations of 40% or more at times. what do you think?

    Analisis Financiero con Microsoft Excel
    Cesar Alvarez - May 24, 2017 Reply

    No, I used the data from Six Figure Investing. I found that it really depends on the strategy whether one can use this data or not.

Leave a Reply: