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.

Yader

1 Min Data to Excel

Recommended Posts

Hi all,

 

I'm new to using software (excel) to perform my own data analysis and haven't a clue where to start, or even search for information regarding it. Definitely not new to trading however.

 

What I'm looking to do is get the 1 min open/close/hi/low and volume of any given stock and download it to excel for my own analysis.

 

I would like to get at least a months worth of 1 min data. Do I need to purchase a data feed for this or can I find it free? What do you recommend? Also, are there any intermediary programs needed?

 

Thanks for getting me started on this, much appreciative.

Share this post


Link to post
Share on other sites

I have been using this software addon for excel for the past 5 years.

 

AnalyzerXL Builds 165 technical analysis functions, indicators, and experts directly on Microsoft Excel spreadsheets.

 

DownloaderXL Downloads free historical stock, index and mutual fund data into Microsoft Excel spreadsheets. US, European, Asian and Australian markets are covered.

 

BulkQuotesXL Downloads free historical future, stock, index, and mutual fund data into Microsoft Excel spreadsheets. US, European, Asian and Australian markets are covered.

 

RTQuotesXL Downloads real-time stock, index, future and fund quotes into Microsoft Excel spreadsheets.

Share this post


Link to post
Share on other sites
Hi all,I'm new to using software (excel) to perform my own data analysis and haven't a clue where to start, or even search for information regarding it. Definitely not new to trading however.What I'm looking to do is get the 1 min open/close/hi/low and volume of any given stock and download it to excel for my own analysis.I would like to get at least a months worth of 1 min data. Do I need to purchase a data feed for this or can I find it free? What do you recommend? Also, are there any intermediary programs needed?Thanks for getting me started on this, much appreciative.

 

 

TradeStation 9.0 has a utility that makes it easy to export any data or studies/indicators on any data to Excel. The platform comes with decades of 1 minute data on both stocks and futures.

 

UB

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.


  • Topics

  • Posts

    • CLX Clorox stock, watch for a top of range breakout at https://stockconsultant.com/?CLX
    • VTLE Vital Energy stock, watch for a bottom range breakout at https://stockconsultant.com/?VTLE
    • NFLX Netflix stock, nice breakout and rally to target 1 and the top of the rally bands at https://stockconsultant.com/?NFLX
    • VFC VF stock watch, pull back to 19.99 support area with high trade quality at https://stockconsultant.com/?VFC
    • Date: 15th November 2024. Treasuries cheapen slightly, Wall Street slips after Powell’s remarks. In the US session, the comments from Fed Chair Powell suggesting the FOMC might be pausing rate cuts weighed on Treasuries and Wall Street, keeping the US Dollar firm. Powell said the data are not showing the need for the FOMC to hurry with rate cuts. His remarks followed on the heels of the stronger than expected PPI and jobless claims data. Asia & European Sessions:   US: Producer prices exceeded expectations, and jobless claims hit their lowest since May. Policymakers called for caution on rate cuts amid strong economic performance, lingering inflation, and market uncertainty. Equity Futures Decline in US and Europe: Futures for Euro Stoxx 50 fell 0.7%, and S&P500 contracts extended losses after the benchmark declined 0.6%. Asian markets, in contrast, saw gains, with MSCI’s regional index rising on signs of economic resilience in China. China’s retail sales grew at their fastest pace in eight months, although the CSI 300 Index fell. Emerging markets equities were set for their worst week since June 2022, while emerging markets currencies neared year-to-date losses. US automakers like Tesla and Rivian dropped on reports that Trump might remove the $7,500 EV tax credit.Walt Disney shares surged after reporting better-than-expected profits. Bitcoin slid back to $87k territory, after Fed Chair Jerome Powell said there was no need to hurry interest-rate cuts. That left the token about $6,500 below a record high set on Wednesday. Markets seem to be cooling down at the end of the week. On the geopolitical front, Russian President Vladimir Putin expressed interest in resolving the conflict with Ukraine. This announcement came alongside President Trump’s endorsement of peaceful solutions, raising market hopes for a ceasefire and potential economic recovery in Eastern Europe. Analysts noted that an end to the conflict could spur economic activity and increase demand for cryptocurrency services. MicroStrategy made a significant $2 billion acquisition, adding nearly 25,000 BTC to its reserves. Institutional investments like these are seen as potentially stabilizing Bitcoin’s volatility and enhancing liquidity. Financial Markets Performance: The US Dollar was set to gain over 1.4% for the week despite a slight drop on Friday. Gains were driven by Federal Reserve Chair Jerome Powell’s comments about a gradual approach to rate cuts. The Yen recovered following Japan’s Finance Minister’s statement on monitoring the forex market. It is currently at 155.75. Oil headed for a weekly loss, impacted by a stronger Dollar and oversupply concerns for next year. Gold remained near a 2-month low. Bullion is currently at $2567, as the USDIndex remains on an uptrend and flirts with the 107 level. The precious metal is still around 25% higher than a year ago. Silver is once again underperforming and copper, and steel prices are also falling as markets weigh the impact of weak Chinese growth. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Andria Pichidi HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
×
×
  • Create New...

Important Information

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