Hello i'am digging my self in creating Tickers with vmix. And as a classic test subject iam trying a stock market ticker.

As i investing where to get free "live Data" from the indices i first tried rss feeds but only fund semi intresting news then live stock quotes.


But i found the following link as a data source:

https://www.ariva.de/dax-30 there you need to select "table 1" or "table 0"



If i try this with the excel/csv datasurce via the live url vMix freezes and crashes.

As an Workaround i created an excelsheet and imported the link there, wich works fine. I also can create an extra collum which sums up all data fields so it is more easy to assign to a ticker.
I also set the excel data source (it is an querry not an connection) to poll every minute (wich is the lowest vallue) and this works fine in excel. To be said the data has an delay of 15 minutes from the source timestamp but this is ok.

Now iam face the behaviour that if i set the datasource in vMix to the file excel, it only reads it once and then works wich these cahed data. IS the vMix excel interpreter able to run full excel files with scripts or can it only read the basic table functions?

It seems thaht i have to store that excel file periodicaly to get vMix to get actual Data.

What is the the best practice for this sceanario? Are there other ways?

Best regards Paul

What i wanted to create is somthing like CNN with a thin line of StockMarket quotes and trends running through the bottom.

I thought this is a good example of getting in touch with data from Websites. I have more in mind Custom Tables like event schedules, or tournament results also via a custom event website. But Stockmarket is classic and there a lot of stock infos i thought but most is not usable be default.

I first thought on RSS feeds, but they only show wich company is investing in y, and who is lawsuit with x and so on.
Also RSS imported in in VMix have nasty headers wich need to be edited. Which is not ideal, but iam still experimenting.

I found this Link i posten first wich is an live (15min Delay) CSV File.
But You have select Table 1 as Datasource. There is also Table 0 as an Source but its useless.
This data is importable as an live Datasource in Excel and gets updated every Minute in Excel nativly (if you set auto pull to each minute). So i see changing live values in Excel.
I then tried to import this link in vMix nativly. vMix finds an additional Data source in this link ,i assume it is the header of the link, wich contains nothing usefull.
If you try to select the table1 from this link vMix freezes. And i dont know why. But i also cant see the pushrate of the csv source. So native in vMix dont work.

I then tried to bring in the excelfile to vMix wich works without crashes. But the numbers are not changing. So think that vMix can only access the core data from xlsx file but is not running additional features like vba scripts and makros. It is indeed not capable of running the auto pull from internet. What i figured out is that if i have the file running in vmix and also in excel and then hit the store button in excel, vmix gets new data. My conlusion vMix is only reading the file but not „running“ it.

So in the documentation of vmix is not fully clear how vmix is interpreting this files and what will work and what not. Just to know the limitations.

So my aim in this post is to figure out maximum features of excel in vmix, and also why vMix crashes with the weblink.

If anyone have an testet online csv (content is not relevant) which not crashes vmix, i would appreciate to share.

Its just a discussion if what is possible. If know this i can tell a web designer how to programm a website suitable as an live Datasource.

Greetings Paul