Pound races towards three-year high against the dollar as Trump's trade war sends the greenback tumbling
The pound raced towards a three-year high against the dollar yesterday as the latest skirmishes in Donald Trump's trade war sent the greenback tumbling.
With fears over the health of the US economy mounting, sterling rose as much as 0.7 per cent to $1.3557, while investors seeking safety pushed gold back towards its recent all-time high of $3,500 an ounce.
The dollar has fallen 9 per cent against a basket of major currencies this year and analysts at Morgan Stanley are predicting a further 9 per cent drop over the next 12 months.
That could push sterling – just below last month's three-year high of $1.3593 – back towards $1.50.
The latest ructions on the foreign exchange markets came after Trump threatened to increase tariffs on imported steel and aluminium to 50 per cent from 25 per cent from tomorrow, dousing hopes his stance on trade was softening.
Sentiment was also hit by an escalation in tensions between Washington and Beijing – with each side accusing the other of 'violating' a truce – suggesting a pause on the US-China trade war has ended.
'The flip-flopping on policy looks set to continue,' said Derek Halpenny at financial group MUFG.
'That is likely to give investors reason to renew selling of the US dollar.'
Hashtags
Try Our AI Features
Explore what Daily8 AI can do for you:
Comments
No comments yet...
Related Articles
Geeky Gadgets
29 minutes ago
- Geeky Gadgets
Excel's Ultimate FILTER Hack : Multiple Columns Multiple Values
What if you could take the chaos of a sprawling Excel spreadsheet and distill it into exactly the information you need—no fluff, no manual sifting, just precision? For anyone who's ever wrestled with filtering data across multiple columns or criteria, the struggle is real. The typical tools often fall short, leaving you stuck with clunky workarounds or hours of manual effort. But here's the fantastic option: Excel's FILTER function isn't just a tool—it's a powerhouse. When used strategically, it can cut through complex datasets like a scalpel, delivering results that are both dynamic and razor-sharp. If you've ever thought, 'There has to be a better way,' you're absolutely right. Excel Off The Grid reveal the full potential of the FILTER function, showing you how to tackle even the most intricate filtering tasks with confidence. You'll discover how to use logical expressions like AND, OR, and NOT to refine your data, extract rows based on multiple criteria, and even optimize performance for massive datasets. Whether you're managing sales reports, analyzing regional trends, or working with text-heavy data, these techniques will transform how you approach Excel. By the end, you'll not only save time but also gain a newfound mastery over your spreadsheets—proof that even the most overwhelming data can be tamed with the right tools and strategies. Excel FILTER Function Explained Understanding the Excel FILTER Function The FILTER function is a dynamic tool in Excel that allows you to extract rows of data based on specific criteria. Unlike static filtering methods, it automatically updates the results whenever the source data or criteria are modified. This dynamic nature makes it an essential feature for managing large datasets or frequently updated information. By using the FILTER function, you can significantly reduce manual errors and save time, making it a valuable asset for data analysis and reporting. Filtering Data Across Multiple Columns and Criteria When filtering data across multiple columns with multiple criteria, a structured approach is essential. Simple filters may not suffice for complex datasets, but logical expressions can help refine your results. For instance, you might need to extract rows where one column meets a condition (e.g., 'Region = North') and another column satisfies a different condition (e.g., 'Sales > 5000'). Combining these criteria ensures that your filtered data is both relevant and accurate. To achieve this, the FILTER function can be combined with logical operators such as AND, OR, and NOT. These operators allow you to define relationships between conditions, allowing you to create tailored filtering rules that adapt to your specific needs. Excel's Ultimate FILTER Hack Watch this video on YouTube. Discover other guides from our vast content that could be of interest on Excel functions. Building Logical Expressions for Advanced Filtering Logical expressions form the backbone of advanced filtering in Excel. They allow you to define complex conditions and apply them seamlessly within the FILTER function. Here's how the key logical operators work: AND: Ensures all specified conditions are true. For example, 'Region = North AND Sales > 5000' will only include rows where both conditions are met. Ensures all specified conditions are true. For example, 'Region = North AND Sales > 5000' will only include rows where both conditions are met. OR: Allows any of the specified conditions to be true. For example, 'Region = North OR Region = South' will include rows where either condition is satisfied. Allows any of the specified conditions to be true. For example, 'Region = North OR Region = South' will include rows where either condition is satisfied. NOT: Excludes specific data. For example, 'NOT Region = West' will filter out rows where the region is 'West.' By embedding these logical expressions within the FILTER function, you can handle even the most intricate filtering tasks with ease. This approach is particularly useful when working with datasets that require multiple layers of criteria. Practical Examples of Advanced Filtering To better understand how to apply these techniques, consider the following examples: Example 1: Imagine a dataset with columns for 'Region,' 'Sales,' and 'Product.' To extract rows where the region is either 'North' or 'South' and sales exceed 5000, you can use a combination of AND and OR operators within the FILTER function. This ensures that only rows meeting all specified conditions are displayed, providing a focused view of your data. Imagine a dataset with columns for 'Region,' 'Sales,' and 'Product.' To extract rows where the region is either 'North' or 'South' and sales exceed 5000, you can use a combination of AND and OR operators within the FILTER function. This ensures that only rows meeting all specified conditions are displayed, providing a focused view of your data. Example 2: For text-based filtering, such as extracting rows where the product name contains specific keywords, you can combine the FILTER function with text functions like SEARCH or FIND. This method is particularly effective for datasets with extensive text fields, allowing you to pinpoint relevant information quickly. These examples illustrate how logical expressions and the FILTER function can simplify complex filtering requirements, making it easier to analyze and interpret your data. Optimizing Performance for Large Datasets When working with extensive datasets, performance optimization becomes a critical consideration. The following techniques can help ensure that your FILTER function operates efficiently: Limit the data range: Narrow down the range being filtered to minimize processing time and improve responsiveness. Narrow down the range being filtered to minimize processing time and improve responsiveness. Use helper columns: Break down complex criteria into simpler components by creating additional columns. This approach not only enhances performance but also improves the readability of your formulas. Break down complex criteria into simpler components by creating additional columns. This approach not only enhances performance but also improves the readability of your formulas. Use structured references: Use Excel's structured references to create dynamic and scalable filtering solutions. Structured references adapt automatically to changes in your dataset, reducing the need for manual adjustments. By implementing these strategies, you can maintain optimal performance even when dealing with large and complex datasets. Troubleshooting Common FILTER Function Challenges Despite its versatility, the FILTER function can occasionally produce unexpected results or errors. Here are some common issues and their solutions: Empty results: Verify that your criteria are correctly defined and match the dataset. Double-check for typos or mismatched data formats. Verify that your criteria are correctly defined and match the dataset. Double-check for typos or mismatched data formats. #CALC! errors: Ensure that the ranges and dimensions used in your FILTER function are valid and properly aligned. Mismatched ranges can lead to calculation errors. Ensure that the ranges and dimensions used in your FILTER function are valid and properly aligned. Mismatched ranges can lead to calculation errors. Performance lags: Optimize your dataset and formulas using the techniques outlined earlier, such as limiting the data range and using helper columns. By addressing these challenges proactively, you can ensure smooth and error-free filtering, allowing you to focus on analyzing your data rather than troubleshooting issues. Mastering the FILTER Function for Advanced Data Analysis The FILTER function in Excel is a powerful tool for advanced data extraction and analysis. By mastering logical expressions, handling multiple columns and criteria, and optimizing your approach, you can tackle even the most complex filtering tasks with ease. Use the techniques and examples outlined in this guide to enhance your Excel skills, streamline your workflows, and unlock new possibilities for data analysis. With practice and attention to detail, you'll be able to use the full potential of the FILTER function to transform the way you work with data. Media Credit: Excel Off The Grid Filed Under: Guides Latest Geeky Gadgets Deals Disclosure: Some of our articles include affiliate links. If you buy something through one of these links, Geeky Gadgets may earn an affiliate commission. Learn about our Disclosure Policy.
The Independent
29 minutes ago
- The Independent
Leaving oil in the ground an ‘act of national self-harm', says Findlay
It would be a 'complete act of national self-harm' not to continue drilling for oil and gas in the North Sea, the leader of the Scottish Conservatives has said. Speaking as his party's conference got under way in Edinburgh, Russell Findlay said Scotland should use its own oil, rather than relying on foreign imports. He also continued his attacks on the Scottish Government's target to reach net zero by 2045, describing the goal as 'completely unrealistic'. UK Tory leader Kemi Badenoch is expected to tell the Scottish conference on Friday that the windfall tax on oil and gas companies, and the ban on new licences in the North Sea, should be scrapped. Appearing on BBC Radio Scotland's Good Morning Scotland programme, Mr Findlay said Scots will need oil and gas 'for decades to come'. He said: 'We are the party who completely support the North Sea oil and gas industry. 'The SNP in Edinburgh are completely hostile to any form of new exploration, and it's exactly the same with Sir Keir Starmer and Ed Miliband in London. 'They want to leave this oil and gas in the North Sea and import oil and gas from further afield. It makes absolutely no sense.' He warned it would be a mistake not to drill for more oil in Scotland. 'We, as a country, are going to need oil and gas for decades. 'The SNP's net zero target of 2045 is completely unrealistic on the basis of what we know the cost that it will inflict on the paying public. 'Even if net zero is achieved within a timescale, any kind of timescale like that, we're still going to need that oil and gas. 'It's a complete act of national self-harm to leave this natural resource in the ground and then just rely on foreign imports.' Mr Findlay said there should be a 'mix' of energy production in Scotland, including nuclear energy – something opposed by the Scottish Government. In her keynote speech to the conference at Murrayfield, Ms Badenoch will accuse the UK Government of 'killing' the North Sea oil and gas sector. She will say the current windfall tax on energy firms – first introduced by the last Conservative government and extended by Labour – would mean that by 2030, there would be no oil and gas industry to tax.'We must scrap the ban on new licences,' she will say. 'We must overturn the ban on supporting oil and gas technology exports. 'And we must champion our own industry.' Dame Jackie Baillie, the deputy leader of Scottish Labour, said the Tories are on the side of oil and gas companies 'rather than working Scots'. She added: 'With Kemi Badenoch desperately attempting to rally the few remaining Scottish Tories, it seems like it won't be long until they can fit all of their MSPs in a single taxi.' The SNP has been approached for comment.
Reuters
34 minutes ago
- Reuters
US stock futures fall after Israel attacks Iran
June 13 (Reuters) - U.S. stock index futures dropped on Friday after Israel's military strike on Iran escalated tensions in the oil-rich Middle East and battered risk sentiment across global markets. Israel's widescale strikes against Iran's nuclear facilities were aimed at preventing Tehran from building an atomic weapon. Iran has promised a harsh response and retaliated by launching 100 drones. The escalation of tensions in the Middle East - a major oil-producing region - sent oil prices surging more than 6% and U.S. energy stocks rose in tandem, with Chevron (CVX.N), opens new tab and Exxon (XOM.N), opens new tab advancing nearly 3% in premarket trading. The strikes come just days ahead of a planned sixth round of nuclear talks between Iran and the United States. Tensions had been building as U.S. President Donald Trump's efforts to reach a nuclear deal with Iran appeared to be deadlocked. U.S. Secretary of State Marco Rubio called the Israeli offensive a "unilateral action" and said Washington was not involved. At 04:32 a.m. ET, Dow E-minis were down 505 points, or 1.17%, S&P 500 E-minis were down 70.5 points, or 1.17%, and Nasdaq 100 E-minis were down 309.25 points, or 1.41%. A 1.6% slump in Russell futures pointed to sharp declines for domestically focused stocks. Airline stocks dipped as the surge in crude prices raised concerns about higher fuel costs. Delta Air Lines (DAL.N), opens new tab was down 3.9%, United Airlines (UAL.O), opens new tab dropped 4.8%, Southwest Airlines (LUV.N), opens new tab lost 2.5% and American Airlines (AAL.O), opens new tab declined 3.9%. Defense stocks rose, with Lockheed Martin (LMT.N), opens new tab up 4.7%, RTX Corporation (RTX.N), opens new tab up 5.5%, Northrop Grumman (NOC.N), opens new tab up 4.2% and L3harris Technologies (LHX.N), opens new tab up 4.3%. The S&P 500 (.SPX), opens new tab still remains just 1.8% below its record high reached earlier this year, following stellar monthly gains in May driven by upbeat corporate earnings and a softening in Trump's trade stance. The tech-heavy Nasdaq (.IXIC), opens new tab is about 2.8% off its record closing high reached in December last year. Investors are now focused on the Federal Reserve's meeting scheduled next week where policymakers are expected to keep interest rates unchanged.
