Connecting BarChart Data Feed to Excel

[jamesblue 10]

Can anyone explain with detail how to to do this?

 

I want to load real time data into a spreadsheet, and then add some VBA coding. First, things first, though how do I get the code in Excel.

 

I tried using the wizard data connection but it doesn't seem to take my user name and password that BarChart gave me.

 

Thanks,

 

James

[statsign 10]

http://realtime.barchart.com/mri/ax3/BarchartX.xla

[jamesblue 10]

Thanks Statsign - That's very generous of you.. It shocks me that I get this answer from a forum user in less than 1 hour and BarChart still hasn't responded to my same request now for over 1 week... But what you sent me seems to be going in the right direction.

 

I downloaded the .xla from BarChart.com but I can't see how to connect it.

 

I understand that .xla files are extensions that enable certain functionality (in this case the data feed).

 

But when I open a new spreadsheet, I don't see in the "data" tab of Excel, either in "From other sources" or "Existing Connections" where to add this next .xla extension.

 

What am I doing wrong?

 

James

[statsign 10]

Barchart Real-time Data Services: Troubleshooting