Recent content by TradingNerd

will try that tomorrow, thanks a lot!

getting errors in hidden modules..

and you manage over $1b? is there a way to get the xlsm password free?

does your fund have a website?

will give it a try, thanks. how much has your hedge fund make in the last years?

using average price would not work for my calculations by the way, I want to realtime YTD pnl per fund or daily pnl

Has anyone managed to get the real time PNL in Excel? I want to know what my pnl is after all the stocks open.

Hello, What would be the best place to 1 year of historical open price auction volume of about 120 US stocks? Thanks

The only problem is that you would have to turn on the calculation to Automatic yourself. I cannot figure out where to place this code yet: Application.Calculation = xlCalculationAutomatic (at the above example it does not turn it on by itself)

open VBA by pressing ALT + F11 go to Modules, uti then find this Function: Function rangeNameExists(ByVal rangeName As String) As Boolean Dim existingName As name rangeNameExists = False For Each existingName In ActiveWorkbook.Names If existingName.name = rangeName...

Hello, I am looking for the best and secure way to execute my orders. I am trading a stock (for example BAC) vs. a basket of stocks (1 till 10 different kinds of stocks) First I want to make sure that the BAC gets fully executed and then I want the other 10 hedge orders to be placed...