Consulting

Results 1 to 2 of 2

Thread: Simulating a function 1000 times for a given integer (easy)

  1. #1
    VBAX Newbie
    Joined
    Apr 2024
    Posts
    6
    Location

    Simulating a function 1000 times for a given integer (easy)

    I have written a code that makes the table almost, the only problem with it is that whenever there is a margin call or margin release, the deposit doesn't change by the value of the margin call/release (margin call needs to be added to the deposit, margin release needs to be taken away).

    I can't move forward;

    I need to simulate 1000 times the profit rate for every liquidity buffer (0%-100%) and make the liquidity profit rate table
    Attached Files Attached Files

  2. #2
    add Volatile property to your function so it will recalculate, everytime you change anything:

    Function egesz(S0, alfa, szigma, N, yf, DB, IMR, MMR)
        Application.Volatile
        ...   ' rest of code
        ...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •