Latest news with #GoogleFinance
Miami Herald
15-05-2025
- Business
- Miami Herald
How to track stock price changes from 52-week lows with Google Finance
In volatile markets, share prices can go up and down sharply - from one extreme to another. A large decline in a particular stock could wipe out a significant investment in a portfolio, leaving an investor to wonder at that moment whether to dump the stock or hold on. Tracking stock price changes from their 52-week lows can help investors identify opportunities to snap up shares in companies that might be undervalued. (You can also track stock price changes from their 52-week highs using this tutorial.) Don't miss the move: Subscribe to TheStreet's free daily newsletter The spreadsheet version of the following tutorial can be downloaded here. Make a copy of the worksheet by selecting "Make a copy" from the drop-down in the File menu. Screenshot via Google Sheets A first step to create a spreadsheet for using Google Finance will require you to set up a Google account that will allow you to access Google Sheets. To create a new spreadsheet on Google Sheets, type " in the URL bar of your browser. At the top row - from left to right by column - you will need to list the attributes defined by Google Finance that will import the requested data into the spreadsheet. In this example, we will use stocks that make up the Dow Jones Industrial Average, an index of 30 stocks that, according to the index's compilers, represent the breadth of the U.S. economy. The index was formerly composed only of stocks listed on the New York Stock Exchange, but it now includes Nasdaq stocks such as Microsoft (MSFT) , Nvidia (NVDA) , and Apple (AAPL) . Related: How to track stock price changes from 52-week highs on Google Finance For the spreadsheet, titled "52-week lows," we will use the following attributes: Name: This lists the name of the This shows the stock's lowest price in the past 52 This provides the latest available trading price of the stock. In Google Finance, there may be a slight delay on real-time prices for particular securities. Tradetime: This provides the last time and day of trading for the This shows the market capitalization of the company at the time of trade. To understand how to create Google Finance's formula with attributes, refer to the section "Understanding Google Finance's formula" in our "How to create a stock tracker with live data using Google Finance" tutorial. This spreadsheet will have seven columns, of which one will have a customized calculation. The cell in the first column and first row will be labeled "ticker." Static data for stock ticker symbols of the Dow 30 will appear in Column A. The attribute "name" will be in Row 1 for Column B, "low52" in Column C, "price" in Column D, "tradetime" in Column F, and "marketcap" in Column G. The header for Column E will be labeled "% change from 52-week low" to show how much a stock has risen from its 52-week low. (Note: A stock's 52-week low will never be above its current price.) More on tools: How to create macros in Google Sheets: Automating functions on commandHow to use conditional formatting in Google Sheets: Ranges, formulas & moreHow to create an in-cell dropdown list on Google Sheets You can calculate how much each Dow stock has risen from its 52-week low with the creation of a customized macro. In the top menu under "Extensions," the dropdown shows Macros, and under Macros, there's a function labeled "Largest Gains from 52-Week Lows." Clicking on that macro will sort the Dow stocks in this spreadsheet from the biggest gain to the smallest, based on Column E, "% change from 52-week low." The bottom of the spreadsheet shows a tab titled "Indexes," and it lists major stock indexes: the S&P 500, the Dow Jones Industrial Average, the Nasdaq Composite, the Russell 2000 Index, and the Nasdaq-100. The layout is similar to the spreadsheet tab "DJIA," and you can add whatever indexes you want by copying the entire row of one of the existing indexes and pasting it into an empty row. Alternatively, you can copy the "DJIA" tab and create your own list of stocks to track their changes from their 52-week lows. Related: Veteran fund manager unveils eye-popping S&P 500 forecast The Arena Media Brands, LLC THESTREET is a registered trademark of TheStreet, Inc.
Business Mayor
14-05-2025
- Business
- Business Mayor
Missed Ethereum's 37% rally? Bitwise CIO urges – Go beyond Bitcoin!
Bitwise CIO implored crypto investors to go beyond Bitcoin. Some crypto indices outperformed BTC over the past five trading days. Bitwise CIO Matt Hougan has championed a diversified crypto portfolio after last week's Ethereum [ETH] 37% pump sidelined many investors. ETH dropped 60% in the past four months amid heightened FUD and overall headwinds linked to the U.S.-China tariff war. This pushed some investors to Bitcoin and other altcoins like Solana [SOL] and Ripple [XRP]. As a result, last week's ETH pump may have caught many by surprise. Go beyond BTC, says Hougan To capitalize on such an opportunity, Hougan urged investors to go beyond BTC. 'Bitcoin is the king of crypto assets—the largest, most liquid, and most established. And yet I think most investors should own other crypto assets.' He referenced the early internet boom in 2004, where Google dominated the search market. But the internet was the general purpose layer (tech) supporting several verticals and segments like social media, retail, video, B2B software etc. In fact, as of 2025, Google did well, but other leaders in key verticals like Netflix performed exceptionally well, something that wasn't obvious in 2004, added Hougan. Source: Bitwise Hougan believed that a similar scenario could play out for blockchains, which he equated to general-purpose tech like the internet. 'You can use a blockchain to create a better form of money (Bitcoin) or to create a programmable network for transferring 'real-world assets' (Ethereum, Solana, Avalanche).' He added that each network may offer different returns over time. 'If, for instance, you're intrigued by the idea of nearly all the world's assets moving onchain—history suggests you'd want to own a basket of crypto assets: Bitcoin, Ethereum, Solana, Chainlink, and more.' Source: Bitwise The diversified crypto portfolio is the idea behind crypto index ETFs. In fact, from a traditional perspective, Hougan noted that individual equity funds have lagged behind indices. 'Over the past 20 years, actively managed U.S. equity funds have underperformed their benchmark indexes 97% of the time.' Interestingly, Google Finance data, on the lower 5-day timeframe, supported his thesis. Source: Google Finance (Performance as of 14th May, 6:54 UTC) Compared to other crypto indices like Bitwise Crypto 10, Hashdex Crypto Index and S&P Crypto MegaCap Futures, BTC rallied less than 1%. But the crypto indices and ETH surged 13% over the same period. Read More Can VIRTUAL keep its 22% surge despite overbought conditions?
Indian Express
26-04-2025
- Business
- Indian Express
Top 10 highest-valued currencies in the world in 2025
Top 10 Highest valued currency in the world in Rupees: The United Nations officially recognises 180 currencies used across 195 countries. While widespread use and popularity are common traits among many currencies, they don't always correlate with their value or strength. True currency strength lies in purchasing power: the quantity of goods, services, or foreign currency a single unit can secure. A range of local and global factors determine a currency's value, including supply and demand in foreign exchange markets, inflation rates, domestic economic performance, central bank policies, and the overall economic stability of the issuing country. This list highlights the world's 10 strongest currencies and explores the elements behind their impressive valuations. Rank Currency Symbol Value in INR Value in USD 1. Kuwaiti Dinar KWD 278.41 3.26 2. Bahraini Dinar BHD 226.43 2.65 3. Omani Rial OMR 221.65 2.60 4. Jordanian Dinar JOD 120.33 1.41 5. Gibraltar Pound GIP) 113.53 1.33 6. British Pound GBP 113.53 1.33 7. Cayman Islands Dollar KYD 102.49 1.20 8. Swiss Franc CHF 103.34 1.21 9. Euro EUR 97.01 1.14 10. United States Dollar USD 85.34 1.00 Note: The exchange rates are subject to change and the values are based on the recent exchange rates as per Google Finance. Kuwaiti Dinar (KWD) Kuwaiti Dinar (KWD) (Source: iStock) Introduced on April 1, 1961, the Kuwaiti Dinar (KWD) remains the most valuable currency globally. As Kuwait's official currency, the Dinar's strength stems from the country's massive oil wealth, economic stability, and tax-free environment. The KWD is particularly well-known among Indian expatriates, who closely monitor the INR to KWD exchange rate. Bahraini Dinar (BHD) Bahraini Dinar (BHD) (Source: Getty Images) The Bahraini Dinar (BHD), introduced on October 7, 1965, is Bahrain's official currency. The nation's oil-export-driven economy and the BHD's peg to the US Dollar have given it notable stability. A significant expatriate population, particularly from India, also supports the BHD's standing as the second most valuable currency in the world. Omani Rial (OMR) Omani Rial (OMR) (Source: Shutterstock) The Omani Rial (OMR) serves as the official currency of Oman. Before adopting the Rial, Oman used Indian rupee for its monetary needs. The country's substantial oil reserves play a crucial role in its economy, making the energy sector its primary driver. Pegged to the US Dollar, the Omani Rial holds its position as the third highest-valued currency globally. Jordanian Dinar (JOD) Jordanian Dinar (JOD) (Source: iStock) The Jordanian Dinar (JOD) became the official currency of Jordan when it replaced the Palestinian pound in 1950. Thanks to the country's stable fixed exchange rate system and a diversified economic structure, the Dinar has maintained a strong position on the global stage, ranking as the fourth highest-valued currency in the world. Gibraltar Pound (GIP) Gibraltar Pound (GIP) (Freepik) The Gibraltar Pound (GIP) serves as the official currency of Gibraltar. It maintains a fixed 1:1 exchange rate with the British Pound Sterling (GBP). As a British overseas territory, Gibraltar's economy relies heavily on industries such as tourism and e-gaming. The GIP ranks as the fifth strongest currency in the world. British Pound (GBP) British Pound (GBP) (iStock) The British Pound (GBP) is the official currency of Great Britain and is also widely circulated in several other regions and territories. Ranked as the sixth strongest currency in the world, the Pound holds a crucial role in international finance. Its value is bolstered by London's position as a leading global financial hub and by Britain's robust trade activities. Cayman Islands Dollar (KYD) Cayman Islands Dollar (KYD) (Freepik) The Cayman Islands Dollar (KYD) is the official currency of the Cayman Islands, introduced in 1972 after the territory transitioned from using the Jamaican Dollar. Despite ranking seventh in terms of the strongest currencies, it holds the fifth highest value globally. The Cayman Islands' financial prominence, driven by its status as a tax haven, helps maintain the high value of the KYD. Swiss Franc (CHF) Swiss Franc (CHF) (iStock) The Swiss Franc (CHF), introduced on May 7, 1850, is the official currency of Switzerland and Liechtenstein. Switzerland, renowned for its economic stability, is considered one of the wealthiest nations globally. The strength of the Swiss Franc reflects the country's robust financial system and its position as a major global economic player. Euro (EUR) Euro (EUR) (Shutterstock) The Euro (EUR), introduced on January 1, 1999, serves as the official currency for 20 member states of the European Union. It is the second-largest reserve currency globally and ranks as the second-most traded currency in the world. As one of the strongest currencies, the Euro secures its position in 9th place among the highest-valued currencies. United States Dollar (USD) United States Dollar (USD) (Shutterstock) The United States Dollar (USD) is the official currency of the United States and is also used by 11 other countries. As the most traded currency worldwide, the USD holds a dominant role as the primary reserve currency. However, despite its global significance and widespread use, it ranks 10th in terms of strength among the world's highest-valued currencies.
Forbes
10-04-2025
- Business
- Forbes
Nvidia Stock Could Fall If 125% China Tariff Drives Price Increases
Nvidia stock has fallen 30% from its November 2024 peak of $153, wiping out $1.1 trillion in value, according to Google Finance. One thing contributing to the drop is the results of the 2024 election which brought Donald Trump back to the Oval Office. Since April 2, his tariff policy has thrown markets into turmoil. And despite Trump's trumpeting of a 90 day pause on most tariffs, Nvidia could be in worse shape. That's because tariffs are high on countries where Nvidia products are built. More specifically, Taiwan faces a 34% tariff while China's rose yesterday to 125%. Is the drop in Nvidia's stock a buying opportunity. I see no reason to buy now because although orders may have soared in the current quarter in anticipation of tariffs, I expect the company's May 2025 earnings report to feature a disappointing growth forecast as a result of tariff uncertainty -- which would drive a conservative growth forecast. More specifically, it is difficult to answer precisely the following questions: Nvidia remains bullish. In March, CEO Jensen Huang said tariffs would not cause meaningful short-term harm to the company due to the company's agile supply chain; demand for AI would drive demand, and TSMC was building a plant in Arizona, according to Barron's. Nvidia declined to comment. A spokesperson referred me to a statement from Huang last month. 'Tariffs will have a little impact for us short term. Long term, we're going to have manufacturing onshore,' Huang said in the statement. Read on for why Nvidia's costs could rise significantly, whether Nvidia will pass along those costs to customers, and how the uncertainty around future moves in the global tariff wars will crimp consumer spending and company's investments in generative AI – which so far have yielded relatively small returns. Nvidia will report quarterly financial results next month featuring slower top-line growth and thinner margins based on the company's forecasts when it last reported in February. Nvidia expressed enthusiasm about its prospects. 'We've successfully ramped up the massive-scale production of Blackwell AI supercomputers, achieving billions of dollars in sales in its first quarter," said Huang in a statement. "AI is advancing at light speed as agentic AI and physical AI set the stage for the next wave of AI to revolutionize the largest industries.' Analysts were underwhelmed by Nvidia's results – which lacked 'the positive shock value of some of last year's reports,' Sungarden YARP Portfolio Investing Group Leader Rob Isbitts told SeekingAlpha. Nvidia's stock is likely to trade 'more on raw demand and supply, rather than on some sort of surprise element,' Isbitts added. 'Guidance was slightly underwhelming,' Edward Jones analyst Logan Purk said in a report featured by Bloomberg. "We think it will be challenging for management to continue to significantly beat expectations for future growth,' Purk added. Tariffs could increase significantly the prices of some Nvidia products. However, it is unclear whether Nvidia will pass all of its increased costs on to customers and whether the higher prices would lower demand. A more significant question for Nvidia's future is whether companies will view the high investment in generative AI as being worth the $1 trillion Goldman Sachs estimated. If the technology enables companies to do better work with fewer people, demand for generative AI is likely to remain strong in the event of a recession. Not all of Nvidia's products are likely to be harmed by Trump's tariffs. For example, fears of a Trump administration crackdown on Nvidia's H20 chip – which the company has been exporting to China – may not be realized. The reason? 'Nvidia promised the Trump administration new U.S. investments in AI data centers,' according to an NPR report featured by Reuters. However, tariffs could raise consumer personal computer prices by as much as 50%, according to WCCFTech. These estimates were made April 3 when the tariff on Chinese goods was a mere 54% – a far cry from the 125% tariff imposed on April 9. Tariffs could raise manufacturer's suggested retail price prices on the following Nvidia gaming machines by at least 50% – based on the latest triple-digit tariff: It remains unclear whether Nvidia will be able to avoid tariffs on GPUs for now. The tariffs could be avoided if actual products are assembled in the U.S., noted Tom's Hardware. For now, Nvidia may be able to ship 'actual GPUs and processors/chipsets to the U.S. without paying import duties along with half-finished logic boards – but paying an import tariff -- then assemble actual products in the U.S,' reported Tom's Hardware. Generative AI has been in search of a killer app, as I wrote in the Boston Globe. There has been no obvious progress on this goal and the investment required for the technology is enormous – potentially totaling $1 trillion, according to Goldman Sachs. Prior to the tariff announcement, the largest hyperscalers – Amazon, Google, Meta Platforms, and Microsoft – announced plans to spend $270 billion on generative AI data centers in 2025, according to the Wall Street Journal. However, that spending could take a hit – especially for companies like Meta and Google which are dependent on advertising for much of their revenue. If tariffs and the resulting uncertainty cause a recession – due to rising prices and fear of declining demand and higher unemployment – companies could decide to cut back on their generative AI spending. The reason for cutting back would be a simple realization that the return on investment in generative AI is not yet compelling. Amazon's cloud-computing arm historically has generated $4 of incremental revenue for every $1 of capital spending, TD Cowen John Blackledge tech analyst told the Journal. Generative AI's ratio 'is currently something like 20 cents for every dollar,' Blackledge added. Microsoft, which plans to spend $80 billion on infrastructure in the current fiscal year, is slowing construction – including a $1 billion project in Ohio. Microsoft canceled leases in the U.S. and Europe -- partly due to an oversupply of data-center space relative to the company's demand forecast, noted TD Cowen analysts. However, 'the moves signal a more cautious stance in the longer term,' the Journal reported.
Forbes
09-04-2025
- Business
- Forbes
Bitcoin Surges Above $80,000 After Markets Experience ‘Amazing Jump'
Bitcoin prices climbed sharply today as markets processed the latest tariff updates. Bitcoin prices rallied today, climbing over 10% in under 24 hours after President Donald Trump's announcement that he would 'pause' tariffs caused an 'amazing jump' in the global asset markets, according to analyst Tim Enneking. The digital currency rose to roughly $83,000 this afternoon, according to Coinbase data from TradingView. The benchmark S&P 5oo index and the Dow Jones Industrial average also experienced sharp gains, rising more than 9% and 7% during the day, according to data from Google Finance. In addition, many altcoins underwent notable price increases, rising between 10% and 30% in the space of 24 hours, CoinMarketCap figures show. The TikTok influencer who goes by Wendy O commented on the situation, emphasizing 'across the board' gains in these cryptocurrencies. When asked whether Trump's policy change triggered the latest gains in bitcoin, Enneking, managing partner of Psalion, stated via email that 'Yes, the 90-pause was hugely important and the sole proximate cause of the amazing jump across almost all markets in two ways.' 'The first was what we just witnessed: immediately concerns regarding the absurdly high tariffs have now been removed (with the major exception of China, where the tariffs actually got worse),' Enneking said after Trump posted via social media network Truth Social that while he would start imposing a tariff of 125% on China, tariffs on other countries would drop to 10%. 'More importantly, however, was the fact that Trump and most (but not all) of his administration's representatives have insisted that the tariffs were immutable and not a bargaining tool,' he stated. 'No one really believed that in their heart of hearts, knowing Trump's negotiating 'style,' but the fear that tariffs were 'here to stay come may' was starting to gain traction – and markets were pummeled as a result," Enneking added. 'Now we know it is possible to persuade Trump to back down, which means that we're back to tariffs as a bargaining tool. The sign of relief from seeing a solid example of that fact can literally be heard around the world!' he said. When asked whether Trump's tariff announcement was the cause today's bitcoin gains, Joe DiPasquale, CEO of cryptocurrency hedge fund manager BitBull Capital, offered a similar take. 'Yes, we agree that Bitcoin's rally reflects the broader risk-on mood sparked by Trump's tariff pause, which markets interpreted as a temporary easing of trade tensions," he said via email. However, he emphasized that bitcoin has been displaying a high correlation to other risk assets like stocks. This development contrasts with earlier times, when the digital currency didn't follow the price movements of assets like stocks. 'Despite being touted as a hedge or store of value, Bitcoin continues to behave like a high-beta risk asset—often outperforming during bursts of macro optimism," said DiPasquale. "Today's move was less about crypto fundamentals and more about a broad shift in sentiment across equities and digital assets.' Brett Sifling, wealth manager for Gerber Kawasaki Wealth & Investment Management, also offered his perspective on the situation, offering his views via email. 'Earlier today, Trump announced a 90 day pause on most of the tariffs besides China. This caused an immediate spike in risk-on assets across most markets, including Bitcoin, that resulted in one of the 10 best percentage returns day in the history of the S&P 500,' he stated. 'This is likely a combination of short-term oversold conditions, short covering, and reassessment after the worst-case scenario was already being priced in,' said Sifling. 'We expect the volatility is likely to continue, as this story is continuing to develop," he concluded.
