You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Importing Data into Excel/OpenOffice
- Thread starter ksmetana
- Start date
Who is your broker and where are you getting your data from?
Regardless, there's probably a free and publicly available way of importing the data directly into excel, and there's people who can set it up for you if you aren't tech savvy.
Regardless, there's probably a free and publicly available way of importing the data directly into excel, and there's people who can set it up for you if you aren't tech savvy.
just put them in a googledoc and use the syntax from this document and you can easily get everything: http://docs.google.com/support/bin/answer.py?answer=54198
Alright, lets say I wanted to collect the following information from a group of symbols every day (different set of symbols each day):
1. Symbol
2. Opening Price
3. 9:30 - 10:30 low
4. Yesterday's Closing price
5. Dividend (quarterly payout, not yield %)
I need to know where to get this data, and how to import it into excel / open office.
I know I can use something like finviz and export data. But finviz does not have all the data I need.
What service could provide me such data?
The 9:30 - 10:30 low would be a difficult data point to obtain from generic data providers.
My platform is Blackwood. Should I be contacting them for a customized data output or something?
**I know how to use Excel. I just need to know how to get customized data.
What if I wanted the price of the first new high after 10:30?
etc etc etc the list goes on.
How do people do this?
1. Symbol
2. Opening Price
3. 9:30 - 10:30 low
4. Yesterday's Closing price
5. Dividend (quarterly payout, not yield %)
I need to know where to get this data, and how to import it into excel / open office.
I know I can use something like finviz and export data. But finviz does not have all the data I need.
What service could provide me such data?
The 9:30 - 10:30 low would be a difficult data point to obtain from generic data providers.
My platform is Blackwood. Should I be contacting them for a customized data output or something?
**I know how to use Excel. I just need to know how to get customized data.
What if I wanted the price of the first new high after 10:30?
etc etc etc the list goes on.
How do people do this?
Quote from ksmetana:
My platform is Blackwood. Should I be contacting them for a customized data output or something?
Sounds like a good starting point.
Depending on their answer, that may dictate if you have to look for a dedicated data provider as there aren't too many free intraday data providers that I know of. I think many people/firms here use eSignal for this type of info, though there are plenty of relatively affordable choices.
you can do anything you want using excel's macros. It uses a program called Visual basic. Basically what you said isn't hard to do but you need a site to scrape that data off. The hardest out of those you listed is the lowest price between those times. The rest is easy peasy because you can easily find sites that have the info and with the click of a button the excel Macro can rip the data off instantly whithout you having to do a thing.
Quote from ksmetana:
How do you all get your data into Excel? I have been manually inputting data and I'm sick of it.
If there is a service or script I can buy, let me know as well.
Also, how would I get and add historical data?
You should check out XLQ available here: http://www.qmatix.com/index.htm
For about $100 (more or less depending on which version you want), you get a full set of macro's that you can use to pull current or historical data (and derivations of the data such as RSI, moving averages and some other indicators) into Excel spreadsheets - no programming required. Available sources include: Google, MSN, Yahoo, Yahoo - RT (real time), Interactive Brokers, IQ Feed.
I've been using it for about 1.5 years and don't know how I ever got by without it.
http://www.gummy-stuff.org/Yahoo-data.htm
you have to modify this to get exactly wht you need,but it will give you general idea.
there is so many ways to get the data into excel via web query,DDE,brokers API, etc..using various sources-your brokers,yahoo or some other third party providers. intraday real time,delayed,EOD etc..
you have to modify this to get exactly wht you need,but it will give you general idea.
there is so many ways to get the data into excel via web query,DDE,brokers API, etc..using various sources-your brokers,yahoo or some other third party providers. intraday real time,delayed,EOD etc..