Huge portfolio correlation difference bettween SQ and MC

        Recently, when I was building a portfolio, I found a phenomenon that the portfolio correlation coefficient in SQX is usually very different from the calculation result in MC, especially in the Portfolio of different strategies of the same instrument. The correlation coefficient matrix is an important reference for building portfolio. So ask the development team to examine why the difference between the two is so huge?

Is the calculation formula of correlation coefficient different or the choice of profit different? Such as based on open profit or close trade profit.
        I chose a set of strategies at random, on the same instrument, please refer to attachment.
       One more point:
       1. there are very different entry and exit time for each trade in two strategies.

       2. When calculating the correlation coefficient of the two strategies in any trading software, it is required to select daily profit or weekly profit or montyly profit. 
           So that mean it is likely to be calculated with daily or weekly or monthly open profit data series  , not the closing profit on each trade. 
I really hope that the development team will solve this bug as soon as possible. This also helps to make the annual and monthly profit values in the performance report more accurate in SQ. Then it will be more efficient to verify the performance report on the trading platform. Thanks
        

Attachments
SA.jpg
(162.98 KiB)
QCZCESA HOT-Minute-Trade.rar
(2.19 MiB)
WF Matrix - Strategy 111149.sqx
(325.79 KiB)
WF Matrix - Strategy 116118.sqx
(322.94 KiB)
Portfolio Correclation in MC.jpg
(385.28 KiB)
Portfolio Correclation in SQ.jpg
(538.83 KiB)
WF Matrix - Strategy 418116.sqx
(321.41 KiB)
  • Votes +5
  • Project StrategyQuant X
  • Type Bug
  • Status New
  • Priority Normal

History

b
#1

binhsir

05.02.2023 04:50

Task created

E
#2

Emmanuel

05.02.2023 09:54
Voted for this task.
b
#3

binhsir

06.02.2023 13:47
Voted for this task.
k
#4

Karish

06.02.2023 22:42
Voted for this task.
KB
#5

kbtech

06.02.2023 23:05
Voted for this task.
b
#6

binhsir

07.02.2023 02:33

This is a bug that is seriously plaguing the build portfolio and has seriously affected my current work progress. It is sincerely hoped that the development team will prioritise fixing it if possible, preferably in version 137.

Also, if it's convenient, please tell me the reason for the bug. Is it something to do with the fact that it is not calculated according to open profit in SQ?

Many thanks.

b
#7

binhsir

10.02.2023 09:33
Thank you Tamas
e
#8

eastpeace

17.02.2023 04:19
hello binhsir, in your experience, which version matches better with MC? B135? B136? or some dev?


+ vx: wanggang_qd , we are trading the same market.

b
#9

binhsir

06.03.2023 14:33
to eastpeace:   i use SQX136
b
#10

binhsir

16.08.2023 12:48

Description changed:

        Recently, when I was building a portfolio, I found a phenomenon that the portfolio correlation coefficient in SQX is usually very different from the calculation result in MC, especially in the Portfolio of different strategies of the same instrument. The correlation coefficient matrix is an important reference for building portfolio. So ask the development team to examine why the difference between the two is so huge?

Is the calculation formula of correlation coefficient different or the choice of profit different? Such as based on open profit or close trade profit.
        I chose a set of strategies at random, on the same instrument, please refer to attachment.

       One more point:

       1. there are very different entry and exit time for each trade in two strategies.

       2. When calculating the correlation coefficient of the two strategies in any trading software, it is required to select daily profit or weekly profit or montyly profit. 

           So that mean it is likely to be calculated with daily or weekly or monthly open profit data series  , not the closing profit on each trade. 

I really hope that the development team will solve this bug as soon as possible. This also helps to make the annual and monthly profit values in the performance report more accurate in SQ. Then it will be more efficient to verify the performance report on the trading platform. Thanks

        

RL
#11

rickliao

09.12.2023 18:00
Voted for this task.

Votes: +5

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please