Nancy K. Tran

Featured in: Favicon

medium.com Favicon

cell.com

Articles

"Quickly Generated Binomial Tree Applications for Options and VaR in Ex" by Tom Arnold, C. Mitchell Conover et al.

Jan 15, 2025 | scholarship.richmond.edu | Tom Arnold |C. Conover |Joseph Farizo |Nancy K. Tran

KEY TAKEAWAYS:Combining Excel’s =LAMBDA and =MAKEARRAY functions allows for the creation of user-defined functions for producing large binomial trees in less than a second. Further applications of the user-defined functions allow for very quick valuations of European and American style options with large binomial trees. Applying similar techniques allows for the calculation of value-at-risk (VaR) measures.
"Using Excel’s “LAMBDA” Function to Compute Modified Duration, Dollar D" by Tom Arnold, Joseph Farizo et al.

Aug 29, 2024 | scholarship.richmond.edu | Tom Arnold |Joseph Farizo |Andrew C Szakmary |Nancy K. Tran

We create a modified duration function that is more accessible than Excel’s current Macaulay duration function (=DURATION) which requires several details about the bond. The dollar duration and convexity functions are not currently available in Excel’s default functions. When these functions are copied to a second Excel file, the functions automatically become available as functions within the second file without the need for recreating the functions.
The Art of Nourishing Your Body and Soul

Jul 17, 2023 | nancythuytran.medium.com | Nancy K. Tran

We sometimes find ourselves hurrying through meals or blindly swallowing whatever is at hand in today's fast-paced society, when distractions abound and time is often precious. However, mindful eating- a different approach to eating-may lead to a better, more pleasant relationship with food. Mindful eating is about how we nurture our bodies and hearts, not just what we eat. By adopting this practice, we may savour the simple joy of eating and create a deeper connection with our bodies and food.
Effective Strategies for Energy Management

Jun 28, 2023 | nancythuytran.medium.com | Nancy K. Tran

I often use the same excuse when my family asks if I'm available: "I don't have the time." However, by implementing certain practices into my routine and prioritizing them, I can create more time and energy for the things that matter. One key aspect is adopting a regular exercise regimen. Exercising at least three times a week improves physical fitness and boosts endurance, stamina, and overall energy levels.