The forex database can be used to access high, low, close daily forex ranges for key currency pairs, such as the EURUSD, USDJPY, USDCHF, GBPUSD, USDCAD, AUD, NZD and major crosses, including EURJPY, EURGBP, EURCHF, GBPJPY, GBPCHF and .
Additional Pricing Information
If you are a forex day trader, use the Forex Daily Stats page to get all sorts of daily stats on the forex pairs of your choice. You can also find a list good day trading stocks on the Day Trading Stock Picks page, which is updated weekly.
With this strategy, I watch for a volatile stock to make a swing high or low in the first 15 mins of the day. Often a swing high or low made early in the day is important, and the high or low made in that initial 15 minutes gives us a baseline for the rest of the day. We then watch to see which level either the high or low made in the first 15 minutes or so is potentially going to be the high or low for the rest of the day.
We do this by watching for a lower high or higher low in the stock as trading progresses. For example, assume the price initially declines. The first few minutes see the price drop, then there is brief rebound, but then the price keeps falling. It then moves above the swing high of the rebound and back above the open. Once a pattern like this occurs, we can make an assumption that the low or high is in place for the day.
Here is a simplified example. Since our low is already in place we must assume all action will now be above the low and on the upside. In this case, our profit target is our assumed low plus the daily average range: We will talk about fine-tuning targets, to make them more accurate, a little later on. The open price is important. A stop loss can be placed below the most recent low. Trade signals should occur before How to Spot Trading Opportunities for more ideas on how to enter trades.
That is how far we can reasonably expect the price to move after the open on a typical day. It reaches the same high as before. A stop loss order is placed above the recent high, as represented by the red horizontal line near the upper left corner of the chart below. In some cases, there may be another swing high we can use if going short, or another swing low if going long, that provides us with an alternative stop loss location.
Reward-to-risk ratios of 3: In fact, if the reward-to-risk is much less than 3: When trading with a reward-to-risk ratio of 3: Once this occurs we can begin looking for entry signals. This will also reveal the reward: If a signal occurs in the opposite direction, exit immediately and trade the new signal or stick with your original trade, up to you. This occurred on May 4, the day prior. Our daily range is 7.
When it pulls back, it creates a higher low and then moves through the open price again and also a consolidation breakout , triggering a long position. That long position fails soon after, as the price creates a lower higher and then moves back to the daily open. Exit at the open or when the price makes a lower low , and initiate a short trade one cent below the open. The first trade is a wash down a cent or two. How you handle this situation is up to you.
You can use another method or your analysis skills to concoct an exit, or you can just exit at the end of the day. Targets can also be fine-tuned, discussed in a moment, so this situation occurs less often.
If you are an active trader, this method provides you with an idea of how far the price may run, but you may opt to take multiple trades along the way instead of just one. I use multiple entry and analysis methods. You can also come up with your own entry methods. In this way, we are not only assuming a high or low is in place, but we are also assuming that the price movement today will be at least equal to the average. If the price moves less than the average, our target will not be hit.
If the price moves more than average our target will be reached and we could have potentially extracted more profit. My primary concern is getting out with a profit.
I am not concerned with trying to squeeze every penny of profit out of a trade. Therefore, a simple way to produce more winning trades, and more targets hit, is to reduce the daily range we use. By moving the target closer, the short trade in the example above may have hit the target.
Whether you do this is a personal choice. By reducing the target you reduce the size of the winners, yet slightly improve the odds your target is reached. You will need to find a balance that works for you.
A more advanced option is to study the trajectory of volatility. This will help us assess whether we should use the daily range as it is, or if volatility is likely to be higher or lower than average today. On StockFetcher, you can see the history of daily volatility.
Is it recently rising, dropping, or stable? Was there a one or two-day volatility spike which has abnormally skewed the average? These simple questions can often help us determine whether we should use a smaller or larger target than the average daily range.
Averages will change slightly each day. Averages lag real changes, so stay on top of it, and if it looks like the average you are using is no longer accurate, then avoid using this method on that stock. There is no perfect solution or magic formula. This is why we only take trades with a favorable reward: The more the strategy is practiced, the better each trader will get at fine-tuning their targets…and entry and stop loss techniques.
The example below shows a trade in ROKU. The average daily range on Feb. Alternatively, we could simply use a reward: The complete URL which gets me to a csv table is http: So I sort of figured it out. The URL you used builds a link to a download file, whereas the one I posted above links you to a table on a web page. Plus, if you use bid, ask, or mid it does return different numbers. So thanks very much. I just wish I could have multiple currency pairs in one sheet… or better yet have all of this going straight into powerpivot!
Samir — awesome — time saving and easy to use. OANDA has changed its website in the past days. Data is no longer available. Do you have a solution? I am using a macro I built from scratch 2 years ago but I cannot find a good source website now to get exchange rates. I appreciate your feedback. The are not matching up.
Are you providing the daily average? I double checked today again and I am getting weekend results. Thanks for such good website. However, I am also looking if there is any possibility to get the rates from Oanda. Thank you very much. When I try to embed the code into my existing workbook I get a runtime error however. Any ideas why this occurs? I need to know if it is possible to get data as below: On a particular date, if we need exchange rate for these many currencies.
Can it be possible through adjustment in above coding. Hello there, is there any solution for this request since the rest of the code and way of exporting information is perfect only need this to implement it in my sheets so it can populate all currencies needed at once. OANDA now has also changed the historical data page and calls it …historical-rates-classic. I tried to code my macro to download from this page but I guess they also changed the format of the date in the link.
I checked with your excel sheet, ForexExcelImport. Do you know of another website that has historical forex data that I can download with the definition of a period? I guess, you have not downloaded correct sheet. Your means of describing the whole thing in this post is actually nice, all be able to simply be aware of it, Thanks a lot.
This is excellent, thanks Samir! The code is just fantastic and works fine on my US laptop! I only had a problem using it on a german Excel version in my office as the decimal separator was not correctly recognized. I am trying to use this tool to streamline some financial information but there seems to be a bug in the code I downloaded.
No matter what I fill in in the excel sheet, the code always seems to extract the same period between today and a month ago, whereas I need much older data. How far back does the code go? AS Simon said this is not working properly anymore? Is there any alternative way of getting the data? Could this be fixed? I download the latest version of ForexExcelImport. This spreadsheet is really awesome. I am looking to expand the date range, however, it appears that the data is being drawn from a csv file which is automatically set to the last 30 days.
How do you code the excel spreadsheet to draw from the csv file from the past 1 year? Hi there — thanks for producing this spreadsheet it is very useful! Is it possible to have a version without a password for the code? Hi, looks like the Oanda link in the Macro for historical FX rates has stopped working. This may be due to Oanda stopping providing the service for free. Any idea what the syntax would be for getting the FX data from Yahoo Finance? I only discovered your tool two or three months ago and have enjoyed convenience and accuracy the macro has allowed me to build reports for work for internal use, not a publicly traded company , but it appears that sometime since April 1 Oanda has changed something in the structure of their databases that renders the workbook outdated.
I discovered there was a problem when I started updating my reports for April data and the macros did not update my main table as I expected.
This tool was amazing and curious if there is a fix or something similar? Your email address will not be published. Premium Excel Tools Kudos Baby. Hi It looks like a terrific tool to use with excell. When you loaded the spreadsheet in Excel, did you give the macro permission to run?
I tried the worksheet. Refresh Another approach would be to delete all existing connections before adding a new one: It is possible to modify to show the open, high, low, and close? Thanks in advance , Lance.
High/Low vs. Open/Close in Forex February 11, by Andriy Moraru Today, it has come to my attention that I still had not blogged about one of the most important issues in Forex chart analysis — the validity of using the Open/Close values in . Daily Highs/Lows Don’t forget bookmark/favorite this Page (Daily Highs / Lows): Hit “ CTRL + D ” on your keyboard This table shows Lowest and . The real time streaming feed displays Open, High, and Low rates as well as the performance in pips and percentage compared to the price close at GMT. Click on a pair to get detailed information.