U.S. Seeks to Seize $700M in Assets from Crypto Mogul Bankman-Fried

Bullet Points:
• The U.S. government is attempting to seize nearly $700 million of assets from former FTX CEO Sam Bankman-Fried.
• Included in the assets is over 55 million Robinhood Markets (HOOD) shares worth about $525 million.
• Officials are also moving to claim $171 million in cash from a series of bank accounts linked to Bankman-Fried’s web of companies.

The U.S. government is attempting to take control of an estimated $700 million of assets it seized earlier this month from former FTX CEO Sam Bankman-Fried. The property includes over 55 million Robinhood Markets (HOOD) shares worth approximately $525 million, purchased with borrowed Alameda money, as well as $171 million in cash from a series of bank accounts linked to Bankman-Fried’s web of companies.

The government filed a bill of particulars on Friday in Bankman-Fried’s criminal case to officially move forward with the forfeiture. A government lawyer previously informed the judge that these assets are “not property in the bankruptcy estate” or are subject to exemptions, meaning they don’t have to be frozen like most FTX assets are, pending wind-up.

The U.S. has accused Bankman-Fried of a series of financial crimes, including securities fraud and money laundering. He is currently out on bail and has pled not guilty to all charges. The government’s seizure of his personal assets is seen as an attempt to pressure him into a plea deal.

The asset seizure has caused a stir both in the financial world and in the crypto community. Bankman-Fried is a prominent figure in the crypto industry, having founded the popular derivatives exchange FTX, and his case is being closely watched. Additionally, the seizure of Bankman-Fried’s assets has raised questions about the ability of the U.S. government to seize property from other crypto entrepreneurs.

The $700 million asset seizure is the biggest of its kind in the crypto industry and is likely to have a lasting effect on the industry. It remains to be seen whether the U.S. is successful in claiming the assets and how the case will play out in the long run. For now, Bankman-Fried and his lawyers are fighting the forfeiture in court, and the case is ongoing.

Posted in Allgemein | Leave a comment

Binance Capitalizes on High Inflation in 2022, Attracts Largest Number of Retail Investors

• A report from CryptoCompare found that Binance attracted the largest number of retail investors from countries facing high inflation in 2022.
• Binance recorded a 16.3% increase in its market share among exchanges due to the growing adoption of cryptocurrencies, particularly in emerging markets.
• Binance is the world’s largest exchange by trading volume, with more than $14 billion in spot trading volume over the past 24 hours.

In 2022, with inflation surging worldwide, crypto exchange giant Binance capitalized on the trend and attracted the largest number of retail investors from countries facing high inflation. According to a report from CryptoCompare, which tracks digital asset trends, the exchange won the largest market share among exchanges, recording a 16.3% increase.

This increase in market share is due to the growing adoption of cryptocurrencies, particularly in emerging markets, as Binance is often the most readily available choice for users in these areas. Binance is currently the world’s exchange by trading volume, according to CoinMarketCap data. It’s more than $14 billion in spot trading volume over the past 24 hours exceeded the amount of the next 20 exchanges in CoinMarketCap’s rankings.

This surge in market share has been beneficial for the exchange and its users. Binance has been able to expand its services to new countries and offer more trading options, while users have been able to access a secure and reliable platform to trade cryptocurrencies. The report also highlighted that Binance has taken steps to ensure that its users are compliant with local regulations and laws, which has helped to further solidify its position as the leading exchange in the crypto space.

In order to further capitalize on this growth, Binance has been expanding its offerings by launching new products and services. Recently, the exchange announced the launch of its Binance Cloud platform, which is designed to help businesses and institutions launch their own digital asset exchanges. The platform provides a suite of features, including an order management system, a liquidity pool, and an integrated wallet. This is just one of many products that the exchange has released in order to expand its user base and increase its market share.

Overall, Binance’s success in 2022 has been impressive, and it looks like the exchange will continue to be a leader in the crypto space. With its wide range of products and services, and its commitment to compliance, the exchange is well positioned to further capitalize on the increasing demand for cryptocurrencies in emerging markets.

Posted in Allgemein | Leave a comment

How to Combine Two Columns in Microsoft Excel

Utilizing multiple columns within Excel can save you the hassle of manually joining the columns manually. Learn how to join two columns using Excel.

When you’re working with Excel and you have data spread over multiple columns that wish to merge it isn’t necessary to perform this manually. You can instead make use of an easy and simple formula to join columns.

We’ll demonstrate how you can combine the columns of two columns within Excel with the ampersand symbol or CONCAT function. We’ll also provide some suggestions for formatting the data to ensure it is exactly the way you’d like it to.

How to Combine Columns in Excel

There are two ways to connect columns within Excel: the ampersand symbol and the concatenate formula. In most instances, using the ampersand method is faster and simpler than using Concatenate Formula. But, choose the one you are at ease with.

1. How to Combine Excel Columns With the Ampersand Symbol

  1. Click on the cell that you would like the data to be placed.
  2. Type =
  3. Select the first cell that you’d like to mix.
  4. Type &
  5. Select the second cell that you wish to join.
  6. Enter to enter. Enter key.

For instance, if you were to mix B2 and A2 cells The formula could look like: =A2&B2

2. How to Combine Excel Columns With the CONCAT Function

  1. Select the cell in which you’d like the combined data to be placed.
  2. Type =CONCAT(
  3. Click on the first cell that you’d like to mix.
  4. Type ,
  5. Select the second cell that you’d like to join.
  6. Type )
  7. Enter on the Enter key.

For instance, if you would like to combine cells A2 and B2 The formula could include: =CONCAT(A2,B2)

This formula was originally CONCATENATE rather than CONCAT. Utilizing the former will join two columns within Excel however it is decreasing, which is why it is better to use CONCAT in order to make sure that it is compatible with both current and the future Excel versions.

How to Combine More Than Two Excel Cells

You are able to combine the number of cells you’d like with either method. You can simply repeat the formatting as follows:

  • =A2&B2&C2&D2 … etc.
  • =CONCAT(A2,B2,C2,D2) … etc.

How to Combine the Entire Excel Column

Once you’ve placed this formula inside one cell, then you can then use this formula to populate the remainder of the column. There is no need to input the cell names you’d like to merge.

To accomplish it, double-click the bottom-right corner of the cell that is filled. Or, left-click and drag the bottom-right corner of the cell you want to fill across the column. This is an Excel AutoFill trick that helps you create spreadsheets more quickly.

Tips on How to Format Combined Columns in Excel

The group of Excel columns may include text, numbers dates, text, and so on. This is why it’s not always appropriate to just leave the cells merged without formatting the cells.

To aid you Here are some suggestions on how to format the cells of a group. The examples we’ll use will be referring to the ampersand formula however the principle is similar to using the formula CONCAT.

1. How to Put a Space Between Combined Cells

If you were to have two columns, a “First name” column and an “Last name” column, you’d need an empty space between them.

To accomplish this to do this, the formula is: =A2&” “&B2

This formula suggests adding B2’s contents then , add a space then include the contents of B2.

It doesn’t need to be an empty space. You can place anything you like between speech marks, for example, an apostrophe, a dash and any symbol, or word.

2. How to Add Additional Text Within Combined Cells

The cells that are combined don’t need to include the original text. You are able to add any additional information you’d like to add.

Let’s suppose that cell A2 has the name of someone (e.g., Marge Simpson) and cell B2 has the person’s age (e.g. 36, for example.). This can be incorporated into a sentence which is “The character Marge Simpson is 36 years old”.

To accomplish this then, the formula is: =”The character “&A2and” is “&B2and” years old”

The text in the additional paragraph will be wrapped with speech marks, and then followed by an and. It is not necessary to make use of speech marks when referring to cells. Be sure to specify where spaces should go, for instance “The character ” with a space at the end.

3. How to Correctly Display Numbers in Combined Cells

If the original cells have numerals that are formatted, like currency or dates you’ll see that the cell combined eliminates the formatting.

It is possible to solve this issue using the TEXT function that you can utilize to specify the format you require.

Let’s say that cell A2 has the name of someone (e.g., Marge Simpson) Cell B2 holds their birth date (e.g. 01/02/1980).

For combining these two, you could decide to make use of these formulas: =A2&” was born on “&B2

But, it will show: Marge Simpson was born on 29252. This is because Excel converts the properly formatted date of birth to the form of a simple number.

Utilizing the TEXT feature You can inform Excel what format you’d like the merged cell formatted. Like so: =A2&” was born on “&TEXT(B2,”dd/mm/yyyy”)

This formula is a little more complex than other formulas So let’s dissect it:

  • = A2 – join cell A2.
  • and” was born on “” – include the word “was born on” with an asterisk across both sides.
  • and TEXT Add something using Text function.
  • (B2,”dd/mm/yyyy”) Combine cell B2 and then apply the format of dd/mm/yyyyyyyyyyyyy the field.

You can change the format to suit whatever number you need. For instance, $#,##0.00 will show the currency using the separator of a thousand and two decimals #?/? will convert an decimal to a fraction the format H:MM AM/PM would display the time and it goes on.

Posted in Excel | Leave a comment

MS Excel Related functions: If the cell isn’t blank

Generic formula

=IF(A1<>””,result,””)

Summary

To perform an action only when the cell is empty (not empty) You can apply formulas based on INF function. In the example in column D, the column holds the dates for task completion. The formula used in cell E5 reads:

=IF(D5<>””,”Done”,””)

Explanation

In this case column D is the date that a job was finished. Thus, if column D has the date (i.e. isn’t blank) We can conclude that the task is done.

Cell E5 utilizes the IF function to determine whether D5 can be said to “not empty”. If not, the output will be “Done”. If D5 is empty IF results in an empty string (“”) that displays nothing”

=IF(D5<>””,”Done”,””)

The symbol > is an logic operator which is “not equal to”, thus”not equivalent to” <>”” is “not nothing” or “not empty”. If column D has a value, it is TRUE, and IF is returned as “Done”. If column D is unfilled, the output will be False and If results in an empty string. (“”).

Two results

To show simultaneously “Done” and “Not done” You can alter the formula in this way:

=IF(D5<>””,”Done”,”Not done”)

With ISBLANK

Another option is to make use of instead the functions ISBLANK to look for blank cells. The ISBLANK function returns TRUE if cells are empty and returns FALSE in the absence of. If you want to use ISBLANK, you could modify the formula as follows: this:

=IF(ISBLANK(D5),””,”Done”)

Note that the TRUE and FALSE results are switched. Now the logic is when cell D5 is blank..

To preserve the original logic and sequence You can also add an not function in the following manner:

=IF(NOT(ISBLANK(D5)),”Done”,””)

Posted in Excel | Leave a comment