Twitter Charts 4

Optuma General Discussion
1

This thread is for charts posted on twitter.com/Optuma

Previous Twitter threads can be found here, here, and here.

2

Bitcoin ETFs Assets under Management and monthly fund flows (requires access to US Fundamental data): https://x.com/Optuma/status/1765241697691181365?s=20

The attached workbook has been modified as not all clients have access to the column charts, and shows the AUM and Fund Flows below the price chart (green is higher than previous, red is lower).

image
image1897Ă—1019 120 KB

BTC ETFs.owb (31.1 KB)

3

Hello, Darren
how are you doing?

I saw you tweet: https://x.com/Optuma/status/1770576390116737523?s=20

Could you share your workbook with us, please?

Best,
Thank you.
RF.

4

Hey Rafi,

See attached for the US ETFs (it was built using the script formulas found here).

Closing highs by calendar year.owb (38.4 KB)

1 Like
5

Thank you very much!

best
RF

1 Like
6

Hi Darren,

I saw today that you updated this wookbook, am i right?
Would you share it with us?
https://x.com/Optuma/status/1772587804419088600?s=20

thank you.
RF

7

Hey Rafi,

Yes I added a column chart for the YTD Net Fund Flows - see attached.

BTC ETF Fund Flows.owb (21.4 KB)

8

Hi Darren,

You have published again your chart about how many SPX members beat the index on Twitter (https://twitter.com/Optuma/status/1773137003535564974).

I have recreated this chart some time ago using your forum post (Twitter Charts).

Unfortunately, my chart looks different than yours on Twitter.

Here is my script for the outperforming:

RIC() IsUp

Here are my settings for the Breadth engine:

screenshot - 0000
screenshot - 0000864Ă—626 42.9 KB

Here is my script for “< 33% outperforming”:

Line1 = GETDATA(CODE=SPXPSDOUTP:Market Breadth) ;

// Less than 33.33% outperforming on positive SPX Days
Line2 = Line1 < 33.33 and CLOSE() IsUp ;
Line2

Here is my chart:

S-P 500 with Percent of Stocks Outperforming Each Day
S-P 500 with Percent of Stocks Outperforming Each Day1878Ă—1060 68.5 KB

Inform me please why my chart is different than yours. My data for the “US Equity” database is up-to-date. I have 22798 items in the folder.

Thank you very much.
Thomas

9

Hi Thomas,

Not sure, but is your S&P500 chart using our data? The header looks like it’s imported, so it could be the RIC() function is not using the correct comparitive price data. Also, there’s no need to use the IsMember condition in a scan any more if the Historical Membership has been delected.

When left blank the RIC defaults to our SPX data in World Indices, but if you are not using that data then you have to tell it which data to use:

image

Also, you can open a watchlist of the S&P500 symbols and add the RIC() IsUp column, and then sum the true values in the Summary row. I get 369/503 for Wednesday (73%).

image

If that doesn’t work then please contact support.

10

Hello Darren,

Thanks for your reply.

I think I solved the problem by deleting the “IsMember” addition from the formula in the Breadth engine.

Now my chart looks exactly like yours.

Thank you very much for your suggestion.
Thomas