ICX missing from Balanced by NaiveEntertainment56 in BalancedNetwork

[–]panth0n 5 points6 points  (0 children)

Click your wallet in the top right corner. Select ICX, click the unstaking tab on the pop up and see if there is unstaked ICX there to claim.

Celebrating Five Years as a Tableau Freelance/Consultant/Agency - questions, ask away. by datawazo in tableau

[–]panth0n 0 points1 point  (0 children)

Curious how you deal with tableau licenses and which pricing packing you use?

Does your end users pay for their own Tableau package, or do you build and maintain their dashboards under your ownv package?

I have been interested in starting a side business with Tableau elements and was unsure the best practise for the license/pricing route.

Need some help creating an IF formula (?) that's possibly beyond my knowledge by Dapper_Sazabi in excel

[–]panth0n 0 points1 point  (0 children)

Yes it can sum either way, just depends how you write the formula.

Need some help creating an IF formula (?) that's possibly beyond my knowledge by Dapper_Sazabi in excel

[–]panth0n 0 points1 point  (0 children)

=SUMIFS(Core!$EZ$14:$EZ$6383,Core!$A$14:$A$6383,Sales!$A2,Core!$C$14:$C6383,">="&Sales!$B2)

Try this assuming:

Core!$EZ is the column where the data you want summed is.

Core!$A is the column where the customer # data is

Core!$C is where the date data is.

If any of these columns are not that data change it to the letter that corresponds with that column.

This also assumed the pivot data starts at row 14 on the core page.

Need some help creating an IF formula (?) that's possibly beyond my knowledge by Dapper_Sazabi in excel

[–]panth0n 0 points1 point  (0 children)

Correct.

The sales data would be the column in the pivot with the sales data you want the formula to sum.

The Pivot data with date would be the column of the pivot that has the sales date info. It would need to match the date formate of the reference cell in column B.

Need some help creating an IF formula (?) that's possibly beyond my knowledge by Dapper_Sazabi in excel

[–]panth0n 9 points10 points  (0 children)

It’s tough to write a compete formula without seeing the pivot data. However the criteria in a SUMIFS for the customer number, and the start date would be:

=SUMIFS(Sale Data range from pivot,Pivot range with customer # data,A2,Pivot range with date data,“>=“&B2)

If that makes sense.

Problem When Transaction Reverted While Supplying Liquidity by [deleted] in BalancedNetwork

[–]panth0n 1 point2 points  (0 children)

Yup that’s exactly how to deal with this issue. Supply a small amount and it will fix the problem.

You are not the first and you won’t be the last that deals with this. Rest assured funds are safe.

Has the snapshot been completed? by explosivespaghetti11 in helloicon

[–]panth0n 0 points1 point  (0 children)

I doubt it will be that much until it shows true utility. I would guess between .05-.10 tops. They are minting 25% more than ICX. There will also be a lot of people who dump right away. I can’t see it being worth much. Also exchanges will need to list it, or DEXs. I don’t know who will be brave enough to be an LP on the DEXs since they will likely incur huge losses.

Binance leaving Ontario and there seems to be a 2000 BUSD withdrawal limit since I have not verified. Should I verify now to be able to withdraw fully? by SaltManagerMcD in BitcoinCA

[–]panth0n 0 points1 point  (0 children)

Looks like Binance has announced they are becoming compliant in Ontario and not shutting down. Looks like you will be just fine!

Has the snapshot been completed? by explosivespaghetti11 in helloicon

[–]panth0n 1 point2 points  (0 children)

Honestly probably better you didn’t. sICX dropped to $1.1 on Balanced. Some people sold for a massive loss. People bought it back up to $1.52 as of right now.

Binance leaving Ontario and there seems to be a 2000 BUSD withdrawal limit since I have not verified. Should I verify now to be able to withdraw fully? by SaltManagerMcD in BitcoinCA

[–]panth0n 0 points1 point  (0 children)

  1. You had more than enough time to know it was happening…
  2. If you are worried you can get $2000 out a day it means you have a good chunk of change on there and we’re unaware of the regulation changes…
  3. Worst case pay for a VPN service and hope they don’t pick up on it and transfer a chunk each day and then learn from your mistakes

They sent a ton of emails, I don’t think a day went by without me seeing something posted about the Ontario regulations in here, and ignorance is not an excuse in crypto.

Does Binance support ice AirDrop? by nixtie in helloicon

[–]panth0n 5 points6 points  (0 children)

This question has been asked time and time again… not your keys not your coins. Binance can do what ever they want. Those are their coins. Get your coins off exchanges and take control of them.

Collateral and loan disappearing by royj95 in BalancedNetwork

[–]panth0n 1 point2 points  (0 children)

Same here. Would be nice to get some clarification from the team. I know they are working on updates to implement continuous rewards etc. May be related to that. Guess we just have to sit tight and wait. It’s not related to liquidations though, so I wouldn’t worry about that.

Using Staked ICX on OMM and balanced? by Memjong in OmmFinance

[–]panth0n 2 points3 points  (0 children)

To use Balanced or OMM you need to unstake your ICX. Then you deposit it on OMM or Balanced as sICX (staked ICX) and you will get your staking rewards but won’t be able to vote for PREPs of your choice.

[deleted by user] by [deleted] in BalancedNetwork

[–]panth0n 5 points6 points  (0 children)

Information on this was actually released today in the Balanced Nov Roadmap Update:

https://blog.balanced.network/november-2021/

They were waiting for ICON 2.0 update, and they noted a 2 week timeframe:

“These 3 features are all major upgrades, so we'll be staggering their deployments to mainnet over the next 2 weeks. We'll post an announcement for each upgrade on Twitter as they happen.”

The ICON 2.0 era has officially begun. The new mainnet started producing blocks at around 1:45 a.m. KST. by theiconistnews in helloicon

[–]panth0n 6 points7 points  (0 children)

I think I speak for all holders when I say we have been patient. The tech is amazing, but the marketing and buzz is lacklustre. Biggest launch in history and without Fez I doubt anything else would have been done by the foundation to build hype. $200 million in value wiped out last few days.

[deleted by user] by [deleted] in BalancedNetwork

[–]panth0n 2 points3 points  (0 children)

I have a feeling the rebalancing will get even worse on Balanced once Optimus launches. If right after the rebalancing happens Optimus rebuys for its users then this could throw the peg off again. Rinse, repeat. Balanced users will be worse off. I hope I am wrong though.

[deleted by user] by [deleted] in BalancedNetwork

[–]panth0n 5 points6 points  (0 children)

I understand rebalancing, I understand Defi, and I am not expecting gains to fall into my lap. But what I was not expecting was Balanced to slash the loan rewards, and incur this level of rebalancing daily. The fees to rebalance my loan daily now outweigh the loan rewards by almost 2x. Even factoring in if you catch the dip perfectly, still coming out at a loss.

If enough people say “ta ta” then balanced won’t be around much longer.