coinmarketcap portfolio import

You need an API key from CoinMarketCap in order to utilize this module, you can get a key from here. as well as CMC have APIs. How to connect CoinMarketCap to Google Sheets. Hi Ana. It has never been easier to have your crypto portfolio, coin stats and latest Bitcoin, Ethereum and crypto news together in the same crypto tracker and portfolio app. (only 1 row, all tickers & their values displayed horizontally in many many columns) How do I fix this? The API used to import data into Excel is steadily growing in terms of capability. Lets start! Update: you can now set a starting cell to avoid overwriting your formulas. Thank you. When i tried to put symbol and id in the same URL, it gave an error. your article helped me a lot. Auerdem werden dir die 24-Stunden-Vernderung und die 24-Stunden-Vernderung in % angezeigt. Anyway I tried your URL in API Connector and got the following error message: "error_code":400,"error_message":"Invalid value for "symbol": "AGI"" So it looks like AGI is no longer valid. There is no shortage of ways in which geopolitical risk can affect a portfolio. On the create request screen in Data Fetcher, for Application, select 'CoinMarketCap'. So i have one sheet in which all the data for the top 500 coins come and another one in which i have my portfolio. I tried it with the template sheet out of the box. Click "create portfolio" to add a new portfolio to your account it's that easy. The way I could correct that is by using the id search instead but that would make me change all symbols to ids. Sure, you can use cell values in your request by wrapping the references in +++ on each side. CoinGecko has a /coins/{id}/history endpoint. Schau dir deine Lieblings-Coins und Tokens direkt vom Lock Screen deines iPhones aus an. So instead of https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=GRT you can use https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?slug=the-graph. Thank you very much! I was able to set this up in my spreadsheet in no time at all. It shows as an example, the bitcoin API link is https://api.coinmarketcap.com/v1/ticker/bitcoin/ 2.2. Du kannst auerdem die bersichtsstatistiken deiner Investition mit Hilfe der Registerkarte "Statistiken" berprfen. We auto-populate the price as of the timing you entered this modal, but you can still change the price accordingly. It has stopped working however about 2 weeks or so ago. Same here, enter the amount you received, and you can also change receiving time, fees, and any notes that would help you remember this transaction! Hope that helps pointyou in the right direction! Integrated new features into a platform that supports application development at high level for users. Keep track of your profits, losses and portfolio valuation with our easy to use platform. Sorry, what do I need to find a solution for? Real-time price data They sound similar, and you may wonder why we bothered to separate these two features. Please check the documentation link as it describes their requirements for access (you'll need a paid CMC plan). We are going to take a look at CoinMarketCaps new Portfolio feature. CoinMarketCap hat das Portfolio-Tool entwickelt, das es dir erlaubt, deine Krypto-Investitionsdaten einzugeben, hnlich wie ein Buchhaltungs-Tool, mit dem du alle deine Investitionen an einem Ort aufbewahren kannst nur besser, da wir nur CMC-Daten und -Methoden verwenden, um dir dabei zu helfen, deinen Investitionswert, Gewinn und Verlust zu analysieren! https://pro-api.coinmarketcap.com/v1/cryptocurrency/info?symbol=BTC,ETH. Part 1: Pull Data from Coinbase into Sheets The data we will be connecting to is stored as a table on a webpage and is not an API endpoint like the Ticker data. There are lots of tutorials online about how to use VLOOKUP, here's one: https://exceljet.net/excel-functions/excel-vlookup-function. Thanks Ana. I have the same problem, even if I modify the request it doesn't work. Thanks, I don't think CoinMarketCap provides an option to get all at once. I'm trying to load all of the metadata for all of the coins and im having problems with setting correct request. I think I need to see your sheet to help troubleshoot your issue. Nehmen wir an, wir haben den Kauf von 0,01 BTC zum Preis von 51.000 US-Dollar, erworben am 17. I'm not sure what you mean by the example works, but not in your sheet. Hi Leili, pagination handling is a paid feature, so it will show none if you're on a free plan. I'll try this night with your solution in google sheets. and our Fourth . But the first error message looks like the "date" parameter is case-sensitive, so you just need to change "Date" to "date". That one is still working for me, too. Wir bewahren nur diese Daten fr dich auf und fhren Analysen fr dich durch. If you're looking for a free solution you can check some other crypto APIs, e.g. Once you navigate to the portfolio page, you will see a box with your portfolios in it. =IMAGE(M2), and it will automatically display the image from the link. From here, select one coin or token that you want to add to your portfolio first: There must be an input of funds when you started your investment. Daher ist ein gutes Tool, das dir dabei hilft, dieses Chaos zu beseitigen, sehr wichtig. Auf der Desktop-Seite von CoinMarketCap kannst du mehrere Portfolios erstellen (bald auch mobil!). You can check their documentation to confirm, but I don't think CoinMarketCap has any endpoint that returns only the price of the currency without any other information, but you can edit the fields displayed in your sheet. If you have purchased crypto investments from multiple sources, you can now see them all in one place, right on CoinMarketCap. Feel free to message support if you'd like me to take a look. I "refresh all now" but on Summary tab all those below are empty from columns C to N. Thanks LTO,DATA,AMKR,NULS,CELR,CTXC,ONE,MLT,WIN,DUSK,BLZ,AION,CTSI,COTI,WRX,GXC,NKN,ARPA,DOCK,STPT,COS,KEY,MITH,PERL,MDT,GTO,MBL,CHR,TCT,DREP,TROY,OGN,AKRO,BEAM,FIO,IRIS,JST,NBS,OXT,REEF,RIF,SKL. On each of the coins that i am interested in in the price cell i have an ="name of the other sheet"AG2 for example and ofc when i click refresh the price change. Sobald du angemeldet bist, findest du "Portfolio" in der Navigationsleiste. Top notch crypto portfolio tracking at no cost. One more issue. i wanted to make a dynamic sheet where i will enter the symbol in cells ranges A3:A7 and it gives me respected prices in cell B3:B7 But here I can see that I have to manually enter the crypto symbol. This is super helpful. Hi! Historically, its role has been to understand the institution's aggregate credit risk, improve returns on those riskssometimes by trading loans in the secondary market, and . Hi Ana and thanks a lot for your article! You'll see a formula like this: =arrayformula(if($B$9:$B<>"",iferror(vlookup($B9:$B,Data!$D:$AZ,match(E$7,Data!$1:$1,0)-3,false),""),"")), Change the AZ to ZZ, like this: =arrayformula(if($B$9:$B<>"",iferror(vlookup($B9:$B,Data!$D:$ZZ,match(E$7,Data!$1:$1,0)-3,false),""),"")). How can we find out the ID for a particular coin? and need to input everything again No import/export Cannot merge portfolios 1 1 1 comment jxkos9soxdi 1 min. Now on the CMC Android app, you can see the prices of your top coins follow you around our site. Their documentation says "Alternatively pass one or more comma-separated cryptocurrency symbols" so unfortunately I think it's just one or the other, you can't mix and match. If that isn't clear, feel free to share your sheet with edit access, I can then help you in your sheet directly. Do you have a suggestion? Thx! I don't know why, but for some reason in the Summary Tab the columns percent_change_7d (0 value), percent_change_24h (0 value), last_updated and market_cap remain empty while all the other columns get regular values. So verwendet man das CMC-Portfolio Schritte zum Erstellen eines CMC-Portfolios Schritt eins: Fge eine "Kaufen"-Transaktion oder eine "eingehende berweisung"-Transaktion hinzu Thank you so much for checking and your reply. Wenn du auf den Namen der Coin klickst, wirst du auf die Detailseite der Coin weitergeleitet, wo du die Details der Coin ansehen kannst. Since overwrite mode overwrites everything in the sheet, I suggest using a formula like =query({Sheet1!A1:Z10000}) to pull all your data into a second sheet. Die Mglichkeit, Notizen hinzuzufgen, ist ein wunderbares Tool. Hey Amanda, I would just pull the data into a 'raw data' sheet, then use Google Sheets' VLOOKUP or MATCH functions for this, that way it doesn't matter if the source rows get rearranged (the source rows will always get rearranged since sort order changes between pulls). The script editor should open in a new tab. Please wait until the process is completed and the page has been fully reloaded. The CoinMarketCap is a free-to-use cryptocurrency API on RapidAPI when you register for an account (also free!) What if I just want USD price, 24h % and 7jd % for a list of coins defined by their ID (because symbol is sometimes the same for 2 coins)? So you'll need to switch to an ID-based request. I tried some tests with the recommanded endpoint (specific crypto), but I can't find all the crypto I want on the list. Reddit and its partners use cookies and similar technologies to provide you with a better experience. If I include SHDW, it reports the Shadow Token, but I want to have the GenesysGo Shadow, which apparently has the same ticker in coinmarket. Awesome tutorial. Watchlist bietet dir eine gute bersicht ber die Listen der Vermgenswerte, die du verfolgen kannst. Can i update the URL to use symbols for 99 coins and ID for the 1 coin? berweisung: eingehende berweisungen von Vermgenswerten oder ausgehende berweisungen deiner Vermgenswerte aus bestimmten Grnden. Jetzt setzt sich mein Guthaben aus 79,24%, Du kannst so viele Vermgenswerte "beobachten", wie du willst, ohne einen dieser tatschlich zu kaufen. The yen rose 0.1% on Friday. Hello! Subscribe now to get daily news and market updates right to your inbox, along with our millions of other subscribers (thats right, millions love us!) Wenn du mehr ber Watchlist erfahren mchtest, klicke bitte. Dieser Artikel ist ausschlielich zu Informationszwecken bestimmt und darf nur zu Informationszwecken verwendet werden. Any workaround?.. May 26, 2021 236 Dislike Share CoinMarketCap 377K subscribers We are going to take a look at CoinMarketCap's new Portfolio feature. Can you please confirm that this is the URL producing the error? Thanks. The error message received is the following : ERROR: The request could not be satisfied 403 ERROR The request could not be satisfied. For example a function like this would get columns A, C, and E: =QUERY(Data!A:Z, select A, C, E). There might be too much traffic or a configuration error. Here are other things I've done on Binance: Converted USDT to XRP and transferred that to a wallet in which I cashed it out For example, https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=1&aux=max_supply would send a response without data tags. to get the quotations of cryptocurrencies in euros? When I put in the parameters it skipped from coin#100 to coin #1000 and then continued from there. You will be led to the Portfolio main page now. Hier kannst du den aktuellen Preis dieses Vermgenswerts, die 24-Stunden-Preisnderung in %, den aktuellen Gesamtbetrag deiner Bestnde in deiner Whrung und in der Originalwhrung sowie den Gewinn und Verlust jedes Vermgenswertes mit P&L % sehen. Portfolio hilft dir dabei, all deine Asset-Investitionen an einem Ort zu verwalten und nachzuverfolgen, whrend Watchlist dir einen Ort bietet, an dem du Assets, die dir besonders aufgefallen sind, mit Lesezeichen versehen kannst. Thanks Ana. I'll try submitting a contact form to CMC. Now it's ok. How can we add names of multiple coins and get data of the coins? Get the API link for your coin of interest from the website I mentioned at the top. The Russia-Ukraine war disrupted the chances of global . Details: "Web.Contents failed to get contents from 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,AGI,ALGO,ANKR,ATOM,BAND,BAT,BNB,' (400): Bad Request. Unfortunately I don't understand your quote: "If youre looking for a more dynamic, ticker-like experience in Sheets, check out the API Connector custom function IMPORTAPI() for faster refresh rates. Request blocked. Here, we show you the total profit/loss of your crypto assets along with the P&L % (profit and loss percentage) from inception of your purchase. Hello, Thanks I use this one : https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=1000. Du kannst die Menge der gekauften Coins, den Preis pro Coin zum Zeitpunkt des Kaufs, das Datum und die Uhrzeit des Kaufs, die mit der Transaktion verbundenen Gebhren und eine Notiz zu dieser Transaktion eingeben. First of all, thank you very much for the tutorial as it has helped me to understand the CoinmarketCap API. Februar 2021, hinzugefgt. Thank you for the suggestion, I just updated the template to accept either IDs or symbols. The price (data.XYCoinname.quote.USD.price) shows a "very" rounded number (for example: 0.56$ is 1$ according to this, altough if I look it up in the data_NoJMES sheet, it shows the correct price) Is there any way to make it show the full value? I hope that you can help me about API. I try to get data for symbol DXT (Dexit finance), but it always displays DXT (data wallet) - which is also the correct symbol. I think this custom request URL should work, please check: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?market_cap_min=10000000&market_cap_max=100000000&volume_24h_min=10000000&volume_24h_max=100000000&aux=num_market_pairs,cmc_rank,date_added. Hello, thank you very much for the tutorial, and the (free) template. For more information, please see our Just remove that symbol from your list and it should work, please try and let me know how it goes. Congrats! One of the obstacles is the historical data URL requires an end date. Click here for additional documentation from CoinMarketCap. Now I would like to import the full listings data so I can have all the prices updated, in order to get a realistic value of my portfolio. I see info for, say, Enjin Coin with a URL like https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ENJ. We will create a request to import prices from CoinMarketCap. I'm CoinMarketCap you've probably heard of me. There was an update on AGI to AGIX. The concepts of Portfolio and Watchlist, from CoinMarketCaps point of view, are totally different. . You ROCK!!! In this guide, well walk through how to pull cryptocurrency data from the CoinMarketCap API directly into Google Sheets, using the API Connector add-on for Sheets. Basically what I do is purchase USDT via P2P, transfer to spot, then trade for whatever coin I want. At the time of writing this resource, they offer manual addition of a coin which you can track, and see the profit/loss. You can simply type in the cryptocurrency slugs or symbols and hit enter, you aren't limited to those that you see on the dropdown list. CryptoCompare Pros: With 13 user ratings, the app has earned 2.9 out of 5 stars at the App Store and generated 4 stars out of 191 ratings at the Play Store. Where does it work? Like this coin for instance: "https://coinmarketcap.com/currencies/metawars/". Can you please refresh your sheet and try again? I'm using the exact same url than the one shared by Anonymous, so that's really strange. My data does not update. Since the CoinMarketCap portfolio was launched, we listened to your user feedback and have added this multiple portfolio feature as a direct result of user requests. Quick feedback, for some reason I can't run the request since 2 days while it was working perfectly before. Hey Cris, please check this article. And some of the coins I'm trying to find the ID for aren't in the top 5000. The CoinMarketCap Portfolio lets you store all of the information about your crypto holdings in one place. Now on the CMC Android app, you can see the prices of your top coins follow you around our site. with a reference cell that would contain all the symbols ? I have educational subscription which allows me to get whole data. Check the section above called "Handle Pagination" for information on how to set that up, or feel free to respond if you'd like further clarification. From the data ribbon, select From Web which can be found in the Get and Transform group of commands. Due the low request rate, I recommend you to test your application in a sandbox environment. Tried this one, but it's still not working Hmm, that's odd, what kind of error do you get? Hey Eugene, I checked CoinMarketCap's documentation and it looks like you can get this from a URL like https://pro-api.coinmarketcap.com/v1/cryptocurrency/ohlcv/historical?time_period=daily&symbol=BTC,ETH&time_start=2020-11-29&time_end=2020-11-30. Wenn du auf die anderen Daten klickst, wirst du auf die Detailseite der Transaktionen weitergeleitet. How do I pull all the information for coins in DeFi because using, https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?tag=defi. It has many features . This means, daily prices for the last months/year, etc? Simply click on the + Add New button and follow the same steps mentioned above! Sorry, I'm completely new to this! I successfully did it. Yes! I'm trying to track the prices against my purchases but the way the API organizes by CMC rank messes with how my table links to different cells I.e, if a coin changes rank, my price tracker will link to the wrong coin. If you'd like, please feel free to message support and I can run some tests with you directly in your sheet. Are you seeing something different? Just add &limit=1000 to the end of your URL to get more. I used CRYPTOFINANCE.ai with Google Spreadsheets for some months now and I want to move on, to be able to get cryptocurrency data by "myself".. and second one ends with no results or no error! Here, you can see the current price of that asset, 24h price change %, your holding total current value in your currency and in the original currency, and the profit and loss of each asset with the P&L %. Follow. Second how can I get the entire historical data (starting from 2013) till today for all coins? Now let's get down to business. I'm currently working with lots of symbols, but there is only one that have multiple coins on the same symbol. Should I need to create a new endpoint and run it from another spreadsheet or can I run it in the same one? In 2017, pantera reported a 25,000% return and in 2018, a loss of 41% against all its investments. Have I misunderstood what you're suggesting I change? I am having trouble with part 5 (to get more than just the top 100). SAN FRANCISCO, March 01, 2023--(BUSINESS WIRE)--Salesforce (NYSE: CRM), the global leader in CRM, today announced results for its fourth quarter and full fiscal year ended January 31, 2023. https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,ALGO. Cannot delete portfolios Mis-clicking outside box when adding transaction closes the window (argh!) Did you have any luck? Yes, I just purchased the pagination feature, and now I have access to entire coins but just recent information (mostly last 90 days). Hover over the API Key box in the top left and copy the key to your clipboard. I think the issue here is that pagination settings only apply to loops after the first loop, so you need to add your limit parameter to that first request URL too, like this https://pro-api.coinmarketcap.com/v1/global-metrics/quotes/latest?limit=1000. Obwohl wir dir die Mglichkeit geben, alle Transaktionsdetails im Portfolio-Feature einzugeben, solltest du nicht vergessen, dass wir dein Geld NICHT einziehen, du berweist also kein Geld an CoinMarketCap. Here are other things I've done on Binance: Converted USDT to XRP and transferred that to a wallet in which I cashed it out, Transferred USDT from Binance to Mandela Exchange wallet, then traded it with MDX. CoinMarketCap users are from all over the world and have different backgrounds in languages, religions, cultures, etc. Du kannst neue Transaktionen ber das "+"-Symbol rechts hinzufgen oder auf "" klicken, um Transaktionsdetails anzuzeigen oder den gesamten Vermgenswert aus deinem Portfolio entfernen. Btw, I recommend using compact report style (under Output Options) to make the output easier to read. Please enter it like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=1000&convert=EUR&CMC_PRO_API_KEY=yourapikey Alternately you can run it like shown in the article, with the API key entered into the Headers section. I never heard about APIjust discovered a wonderful tool! and our Enter the API URL endpoint to the first URL parts box. Is the above possible? See your favorite coins and tokens right from your iPhones lock screen. Hey Phil, thanks for the message! We can't connect to the server for this app or website at this time. CoinTracker is the most complete portfolio tracker on the market. Dieser Artikel ist nicht als Finanzberatung gedacht und darf auch nicht als solche ausgelegt werden. 2. This article is intended to be used and must be used for informational purposes only. When I run the request the timestamp shown is 2020-08-29T06:34:36.879Z .But the Actual time I run the API was 1:38 PM JST.Due to this current Price is not shown(The Binance Exchane price was 17 USDT but my Google sheet is showing 15 USDT).Could you help to fix this issue? Cookie Notice thank you! Portugues. Like e.g. The project serves as a stepping stone for traders and investors of these non-fungible tokens by offering verification services. Or if you meant you want fewer columns returned, you can use the "aux" parameter described in their documentation to cut out response properties you don't need. CoinMarketCap is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement, approval or recommendation by CoinMarketCap of the site or any association with its operators. den du zuerst in dein Portfolio aufnehmen mchtest: Zu Beginn deiner Investition musstest du einen Geldbetrag einzahlen. How can I build an endpoint to call, for example the BTC and ETH, symbols and logos at the same time? Try again later, or contact the app or website owner. Hey Van! I'm not familiar with using Excel to connect to APIs so I can't comment on that, but I suspect it's the same issue. Bitte gib unserem System etwas Zeit, um das neue Ergebnis fr dich zu berechnen! I have a problem. It works well for almost all of the projects I am interested in, but I am having troubles with one symbol A.O.T, project Age of Tanks. Das gleiche gilt hier: gib den erhaltenen Betrag ein und du kannst Zeit, Gebhren und Notizen ndern, die dir dabei helfen, dich an diese Transaktion zu erinnern! Alternatively, you can just query the columns you want into a new sheet using Sheets functions. Anyway, you need to click the "Get Your API Key Now" button at https://coinmarketcap.com/api/. In my own tests the timestamps don't differ from API Connector's own timestamps by more than about 30 seconds. I had difficulties as well since the data is ordered in a different way after importing. 2. Shibcat is a powerful and disruptive BEP-20-based token that offers a range of utilities and features that make it a must-have for any cryptocurrency investor. Wenn du zur Portfolio-Seite gehst, siehst du ein Feld mit deinen Portfolios darin. Then you can apply your formulas to that second sheet, and won't lose your formulas when the data refreshes. Hi there, I have added the API data but I am not sure how/if it will be updated regularly like every 15 mins like google sheets with stock prices, that is what I'm after, so could you confirm if it will work like that? Jan. Hey there, great article, very helpful thanks a lot ! This user-oriented wallet allows investors to safely store Shibcat tokens, remain up to date with their investments, and import other tokens. Is there something I am doing wrong? Suggest adding it to the guide. So maybe you can check or post in there for more info. Thank you Ana. Wenn du Kryptowhrungsinvestitionen besitzt, hast du diese wahrscheinlich aus verschiedenen Quellen gekauft: Vielleicht hast du BTC bei Coinbase gekauft, BNB bei Binance und dann vielleicht noch viele andere Coins oder Tokens an verschiedenen Brsen. They have automatic import from exchanges built-in, and the interface is very clean. Thank you. unfortunately none of these URLs works. #excel #cryptocurrency #coinmarketcaphttps://theexcelclub.com/how-to-connect-excel-to-coinmarketcap-api/**brave verified creator**Learn how to connect Excel . You can enter the quantity of coins you bought, price per coin when you bought it, date and time of purchasing, fee associated with the transaction and a note to this transaction. Deinen aktuellen Kontostand, Diagramme und eine Zusammenfassung. As far as I can see, these are your options: 1) The Listings Historical endpoint returns all cryptocurrencies on a specific date, like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/historical?Date=2021-01-01&limit=5000&aux=date_added, 2) The OHLCV Historical endpoint returns historical open, high, low, close, and volume data for a list of currencies over a date range, like this: https://pro-api.coinmarketcap.com/v2/cryptocurrency/ohlcv/historical?slug=bitcoin,ethereum&time_period=daily&time_start=2018-09-19&time_end=2022-05-30. I succeed in import one or many quotes. This can be done using CoinMarketCap's API (Application Programming Interface). Import CSV File. Thanks Ana for your quick response. ****Coinmarketcap has changed and you now need a premium API to get historic information on Cryptocurrency. I'll update the article to reflect this. Marketing & Crypto Writer ~ For copywriting or ghostwriting enquiries: matt [at] mattshango.com. Try this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?sort=date_added&sort_dir=asc. This tutorial will show you how to use the CoinMarketCap API to import bitcoin prices and cryptocurrency data into Google Sheets.. DataSource.Error: Web.Contents failed to get content from "https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=9180&convert_id=2781,2790" (400): Bad Request Details: DataSourceKind = Web DataSourcePath = https: //pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest Url = https: //pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest? Klicke einfach auf die Schaltflche "+ Neu hinzufgen" und befolge die oben genannten Schritte! I just tested and those IDs seemed to work fine on this side. Hello Ana, I am using the API based on your useful Article put here. Verkaufen: jede Transaktion, die angibt, dass du eine bestimmte Menge an Vermgenswerten verkaufst. Clicking on the line of one asset, e.g. Reddit and its partners use cookies and similar technologies to provide you with a better experience. There's no way I'm going to manually add hundreds, if not thousands, of transactions I've made into CMC to track and manage my portfolio.. surely they don't expect us to do that?