Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

jamesblue

Connecting BarChart Data Feed to Excel

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Similar Content

    • By Analytics
      Hello all,
      I'm new here so be gentle if I've posted something incorrect. I'm looking for a data feed or API (push or pull at this point) that provides the ability to pull trades based on any set of criteria. All services I am looking at require a Symbol at least. I'm looking for the ability to ADHOC query on any field on the trade or quote and then be able to analyse the information I'm getting, tweak my parameters, to narrow down to symbols I want to watch or monitor. 
      I will be building this within a .net framework so something that works nicely with .net is a plus but at this point I'll code around the difficulties if I find a solution that provides this functionality. 
      Does anyone know if this exists?
      Thanks!
    • By trading4life
      Hello, My name is trading4life.
      I just joined this forum.
  • Topics

  • Posts

    • $CSCO Cisco Systems stock, nice top of range breakout, from Stocks to Watch at https://stockconsultant.com/?CSCOSEPN Septerna stock watch for a bottom breakout, good upside price gap
    • $CSCO Cisco Systems stock, nice top of range breakout, from Stocks to Watch at https://stockconsultant.com/?CSCOSEPN Septerna stock watch for a bottom breakout, good upside price gap
    • MNST Monster Beverage stock, top of range breakout above 60.45, from Stocks to Watch at https://stockconsultant.com/?MNST
    • ...hallucinates.... Student: “What if we gave the monkey LSD?” Guru: “The monkey already did LSD”
    • Question: To those that had/have cancer, what were the signs that made you think “something is not right here” to make you go see a doctor? Answer: So, 5/25/2018, I woke up, got ready for work, and as I walked to my car, I started gagging. Like something was stuck in my throat and I needed to clear it. And then it went away.   But 10 minutes after that, I was T-boned at 40mph on the driver side door. But what made me see a doctor was while my muscles felt better and bruises were going away, the gagging still continued, I started having fevers, my neck felt swollen, I was having such a hard time breathing, and I'd have random sharp pains in my chest, but not from where the seat belt saved me.   2 weeks after the accident, I finally see an urgent care doctor, who looks me over, tells me I'm fine, but luckily requests a neck X-ray. And I ask for a chest X-ray, which he rolls his eyes but let me have (most of my pain was in the neck, so I understand).   The very next day, he calls and says “So, that chest X-ray shows there's a 4 inch mass on your heart and lungs, and your lungs have been filling up with fluid, as well as in your pericardial (heart) wall. We need you to come in tomorrow.”   Turns out the big mass, due to the accident, caused my heart and lungs to tear and fill with fluid, the swollen neck and gagging was caused by 2 metastasized tumors, and the fevers and weight loss were symptoms. Stage 4b Hodgkin's Lymphoma.   But thankfully, we went very aggressive with chemo (and had a lot of bad side effects that don't normally happen to patients), and now I'm about 16 months cancer-free. Yay lucky X-rays! Rachel Jurina, Quora Source: https://www.quora.com/To-those-that-had-have-cancer-what-were-the-signs-that-made-you-think-something-is-not-right-here-to-make-you-go-see-a-doctor   Profits from free accurate cryptos signals: https://www.predictmag.com/  
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.