So, This does a bit more with formatting another, quick. Example to highlight here is this, example will also insert. Some charts and so, the. Charts API is very similar to the, range API you're, saying hey sheet charts, add. You're. Applying some properties like a chart title a chart legend. Data. Labels, and. So. Forth so, if I go and run this. And. Click. Create report, and. This. Will insert that data, into, excel, and, they this, is using. The. Same. Same. Built in chart functionality, so if I were to change one, of these values real, quick and make it really large. Excels. Built-in chart, will would automatically, update right, so it's not just like a you're, taking whatever the context, is of your application, and you're bringing that to excel. So. Excel is this rich. Flexible. Powerful tool and so we do need a lot of api's to interact with that, today. We have roughly. 1400. Api's available. And. Proud. To announce that. With. Our 1.9. Release, we're gonna have over. 18. Hundred different api's, available. And, the. 1.9, is GA today so. Thank, you for, folks, who have contributed for, that. And. By the way we, have Raymond, and Tuan from our Excel. Api's team from Beijing so, if you have api's questions. Come. Talk to them afterwards. So. A ton. More capability, in this release new. Shapes, access. To all the rich chart, types that are in office 365, greater. Cal control. Ability. To insert, save close workbooks, so, a bunch more and then, we, also have a beta channel so beta. If you're on the insiders. Preview. Channels. You, can to get access to the new betas, new, API s that are coming soon specifically. Comments, slicers, and we have a bunch more and. We'll have pointers to our deaf. Program and community call where you can stay engage with us to provide us that feedback as we move forward. So. With, this we have, api's. For, every step in. The. Excels user. Journey right, the the platform. It has a. Rich, set, of api's that you can use in your applications, today so. With, that I'd like to invite Gilbert, to talk about how they're working with our APs. For. Having me on the stage. Let. Me just prepare, that. Ok. So. Hello, I'm. Gilbert Kaba I'm. Working for sa p. SI. P as, a market leader and enterprise, application, software. While. Most people might. Know, us because. We serve. 92%. Of the Forbes Global. 2000. Companies. We. Also have eighty percent of our customers being. Small and mid-sized customers. In. Fact altogether, we'll more than four hundred and twenty-five thousand customers, so.
With. That many customers it's, easy to see that, more than three-quarters, of the. World's, financial. Revenue, flow. Through SFP systems. We. Cover all aspects, of enterprise, application, software, from. The back office to the boardroom, and also from the storehouse. From. The warehouse, to the storefront. I'm. Personally working, in the field of analytics, and here. We, have a product that's called ASAP. Analytics, cloud and, it's a software, as a service solution that. Enables business, users to discover. Analyze. Plan. Predict, and collaborate. All in, one place. And. Today I would, like to give you a lab, preview, of a new product that, brings. Analyst, AP analytics, cloud into. Excel. Online. So. For, the demo I will, be a controller. That, would like to analyze financial. Data. For. There. I'm using the web client of Sapa analytics cloud. Please. Observe the, URL, up there as. ASAP. Cloud platform, separates, and. Protects. Customer. Data by providing, customer. Specific tenants. This, URL here is specific, to my customer, it's, planning, reflecting. My company planning incorporated, EU, turn for the data center and Danna sa periodic structure. Please, keep that in mind it. Would be important, a few, minutes later. So. Here, I am and I'm, opening, a story that I've got prepared. That. Shows my operating, income data and a spreadsheet application. This. Has a very nice UI, for. Example, I can single click on a cell to. Drill down, on, my. Account structure which, is hierarchical. And. Seeing. Like my gross revenue, I see, that some. Of my goods are. Returned, and I. Would like to calculate the, percentage, of the of the goods returned and. As. A, controller, I'm. An Excel guy so actually. I'm used to Excel workflows, so what I would expect is, to, insert. A row here and then, calculate, the, percentage. With a formula. Unfortunately. It, just worked, a little bit differently than I then, I'm used to it as an Excel user so. I'm. Know. How to do this here and it would be easy but as, a controller and feel more familiar. With Excel so. What. I could do now is I, could. Export. This data as. Comma separated, values, but. Doing so I would. Lose. All the metadata information and. In. Addition, it will only export a snapshot of the data so, whenever. The data changes I would need to do, that over and over again so. Instead. I will. Do the same in, Excel online and, as, my IT department, does, not want to be bothered with installations, I will, do that in the online version of Excel so, let me switch to that. Currently. I have to do this manually but we're working on a seamless. Transition, from. The one to the other so. Here. I already have my my, web at NSA Pianist cloud installed, it's. It's a pre-configured. By mighty department as kay I just showed.
So. When. I click on login a. Task. Pane shows up and it. Presents a, landing. Page and, in. This landing page I need, to. Provide my talent specific, URL. So. Let's. Get. That, from. Here. I, need. To do that. Because. As, care showed the Adhan manifest, specifies. The location of. The web application. Running in the task pane, as. The, add-in, is. Available, in the store. This. URL needs to be the same for our customers, but. In, our, case the, web application, is, 10 on specific, so. Therefore, I need to enter this here. And. It. Will redirect me to this, to. This tenant. Specific web application, I. Only. Have to enter this information once. Because. It will be cached and in fact we're working on our together with the Microsoft, graph team, to. Pre-configure. This. Information, for every, user. So. Let me click on go. And why. The landing, page was, publicly, available, the. Actual. Turn on the application, is protected. By. Our authentication. Step. Prepare. And. Now I'm seeing the welcome page of the. Actual web application, here so. Now let's bring in the data. Who. Are you so. Press on select source. Now. Browse for. The operating, income. Data. Model. And. I enter it and it's here. Let. Me just. Add, the. Version, to the columns. And. Now you see the the. Same, data that we have seen in the web application it's. Nicely formatted as. A crosstab, here in the spreadsheet. We, need to to, expand, the account structure initially. Because. With, the current version of the office, Jas API. It's. Not possible to trigger an action on a single click but, we ask the requirement, to you. To Microsoft, and. They. They. Already solve it and it will be in one of the next version of the. API so. What, I can do now is I. Can. Add. Some more characteristics. To analyze my data. For. Example I can add regions, here. At. The product group and. With. Each change of the layout the data is retrieved live, from the back end. So. Getting back to my. To. My initial. Task. I. Would. Like to know the percentage, of the goods returned. Now. Let's, just. Enter that new line. Okay, and then just calculate, the, value using. A formula. Let's. Do this also for the land. Values. For. Merit with axial means. And. Here it is. So. With. This new add-in we. Bring the. Functionality. As, AP analytics, cloud to. Excel online and I. Would like to end with. Showing. You. Some. Code examples, how. Easy it is to, use the office. Jsapi, the, first one the upper one does. Show, you how easy it is to merge ranges. We. First create, range by. Giving some parameters, like start roll start column row count current count, and. After we have created the range object, we simply call range to merge and, the second one is. A little bit more complex but, not. That. It's. About, the styling of the cells usually. You. Would need to style, each cell individually but, if you have a lot of data that, could. Be very. Costly. For performance, so what we do here is we loop over the over, the columns and the rows check. The style of the cell and. Collect. All the cells with the same style and only if the style changes we. Create range. Of. The, cells and, assign. The. Style to. The to the whole range object so clockwise, starting. So. With. That I would, like to hand over again to care thanks. Thank. You Gilbert. Right. So. Gilbert, showed us an example where they, they, took the data to new to, excel so they could perform. Custom calculations and. So. What we're gonna do is now talk about how you can extend excels, function. Library so. With. Inside at excel as, part of its calculation, engine there's, a hundreds. Of different functions that you can use that are built in natively and. One. Of the things that was. One of our top requested items. On user voice was. The ability to allow. Developers to extend these functions, as part of web Adan's so.
Windows Mac Excel, online big. Thank you to all. The, developers, who. Gave us feedback tried, it out, during. The preview. So. With. That let's, actually see. How one of our other partners is. Using custom functions sahil. Thanks. Q hi. Everyone I'm. Sal Serrano, I am, a senior engineer, who. Works with the Bloomberg score applications, team, we. Build. Add-ins. To get Bloomberg data and analytics, into, Microsoft, Office. I'm one of the five thousand, engineers who work at Bloomberg. Bloomberg. Is a leader in global business, and financial, information and, news. Bloomberg. School product, the Bloomberg terminal quickly. And accurately delivers. Data news. And analytics. Through. Innovative technology. Bloomberg. Terminal was first introduced, in 1982, to bring transparency across, global, financial markets. Today. It's, used by more than three hundred and twenty-five thousand. Influential, decision-makers. To, turn knowledge into smarter, and well, informed financial decisions. To. Give you an idea of the scale we deal things each. Day we, process, more than a hundred and twenty billion, market, data text in real time that. Means normalizing. The data cleaning. It and making, it consumable, for our clients, across global, capital markets in mere, milliseconds. We. Also build in deliver analytics, and trading, solutions, on top of just market data along. With email, and instant messaging. Each. Day our clients, exchange more than a billion. Emails. And instant messages. Now. That you have an idea of what, Bloomberg, does and how the Bloomberg, terminal is an integral, part of our clients workflow, of conducting. Research, making. Trades managing. Their portfolios, it. Should come as no surprise that. A majority, of our clients also, use Excel to drive their financial, models. But. Bloomberg data. So. One, of the one, of the client workflows, that I want to talk about today is the investment, idea generation, process, a. Portfolio. Manager who. Makes decisions about investing. In different financial, instruments, consumes. Information, and research about those instruments from various sources, these. Sources can be financial. Information services. Like the Bloomberg terminal. External. Brokers and dealers and. Their own research analysts, now. These research, analysts, who work for the portfolio manager, they. Visit companies. Our executives. Attend, investment, conferences, to, get an idea of what a company is doing what. The pipeline, of product, looks like and would, recommend and, investing. In that company. They. Then share this research with the portfolio, manager. Along. With supporting financial, models so, that the portfolio manager, can act on this information. Let's, look at this workflow, in, desktop, Excel. Switch. Over. So. This. Is a financial model called discounted. Cash flow on, a very high level discounted. Cash flow is a valuation, model which estimates the value of an investment. Based. On its future cash flows so. Let's. Say I'm a research analyst and I'm visiting Microsoft, I, look, at that pipeline of products, I made their executives, and based. On a growth, rate of 4.3%. Let's. See what the value, of Microsoft, stock would be at the end of the year. So. Based, on a growth rate of 4.3%. It says Microsoft. Stock will grow by 4%. This is pulling in real. Data by a Bloomberg, add-in and Bloomberg formulas, to give you an example of a Bloomberg formula, the very simple one is be DP or Bloomberg. Data point I can, put in the. Ticker. And. Let's say I want today's. Price. I can say a last price, and. It will go and pull in the. Data in real time so. After. Meeting Microsoft, executives, and you know looking, at the pipeline of products I think Microsoft is going to beat this growth estimate, and let I believe it's going to grow at at least 5%, so. Let me put. In my estimated, growth rate gives. Me a target growth rate for the Microsoft, stock at 15%. So. This has all the, prior this, financial models all the data it needs you. Know it's pulling in all the estimates cash, flows everything, that needs to power the entire financial model, I. Can, put in my comments, also that. This is why I think, you. Know the stock is going to grow by this much and. I'm, recommending it, recommending. My portfolio, manager to buy I can.
Share This information with my portfolio, manager, using, the Bloomberg added. The. Click of a button I can, upload. This to the Bloomberg terminal. When, I upload it to the Bloomberg terminal my, portfolio, manager would get a notification that, a, research has been published and, he. Can go to. The terminal and. Look. At at real, time he, can drill in further, look. At my comments, look at the entire, financial model, that I published. Along. With all the supporting, numbers. So. This, is what I just published two. Minutes ago you can see growth. Rate of five percent target growth rate of fifteen percent and the, entire financial model, he. Can also use other analytics, that is built into the Bloomberg terminal like. Charting, so he can go to. Graph. Look, at the Microsoft, stock over the year look at all the research that has been published, over time so it is these tiny I can see see at the top this is the research that was published over the year he. Can go and clicking. On any. Research. Go. In and read, that research along, with the, entire financial model. You. Can also look at other statistics, about Microsoft, so he. Can go in, into. Financial. Analysis, look. At revenue. Gross, profit, look. At income statements, balance sheets etc, and, then make his trade recommendations. So. So. This has been fairly straightforward. For us to accomplish in desktop. Excel but the Bloomberg add-in and. Bloomberg. Functions, but. As research. Analysts, are increasingly on the move, it's. Not always possible for them to have access to desktop Excel in. This, case they would have to wait till they can get to, desktop Excel then, write up their reports, and recommendations and, share. It with the portfolio manager. Now. Very often this research is extremely time critical and the portfolio manager would want to see it right away. This. Made us rethink on how we can support our clients workflow, on the move, so, that they can quickly write up their analysis reports. And recommendations and, then easily share it and. This, is where custom, functions in Excel come into play. Custom. Functions in Excel give us the ability to seamlessly migrate, our, clients workflow, from desktop, Excel to Excel online, by.
Enabling Our clients, to. Query, the Bloomberg API to, fetch and manipulate. Data in, real time and drive, the financial, models from anywhere, the. Web, browser made a tablet, beat a smart phone we. Give them the flexibility, and the choice that they want in. A more complete solution, that supports the way they work and most, importantly, where they work. Now. Let's look at the same workflow in Excel, online. So. Here. I have the same data, model but, this time loaded in a web browser in Excel online. What. I'm going to do first is authenticate, myself sign, in with my credentials. But, in my credentials it asks, me for my two-factor. Authentication. Authenticates. Me why am i fingerprint, this is a bloomberg supplied device which checks my fingerprint, and gives, me a one-time, access code so. This, flashing thing actually is a code, which can be read by this device, securely. I'll. Put in the code. Now. Again. In. A-put Microsoft's, talk. Can. See all the custom functions fire the entire data model will evaluate and, give me a target growth rate. Networks. A bit spotty but you will see data come in and we'll. See the growth rate come, up here. Still. Calculating. Still, fetching. And. Any. Time now. That's. Conference. Network mix party. Right, it. Will eventually get there. Let's. Go look at the architecture. We have in place to support. Custom. Functions so. Here's. A very high-level view. When. I put in my credentials and authenticate, my, credentials are sent over to an authentication, server which responds, authenticate. And responds with a token which is valid for the session. Anytime. A custom formula fires that, token is sent along with the data request to Bloomberg servers where it's validated, and that request is forwarded, to the Bloomberg API. Bloomberg. API responds back with data which flows into the same path into. Excel online. Another. Thing we did is to introduce client-side. Batching, to our formulas, so when a bunch of formulas fire we batch them together and then send it over to our servers, and. That has led to significant, performance gains so. As an example. I'm. Gonna pull. Ten. Data points for each of the securities, in the S&P 500 index, so, that's 5,000 formulas, I can use a Bloomberg.
Popular. Table functionality. To put in all the formulas, together as. You can see all, the formulas fired together and. If. The network would help me the data would come. There. We go. So. With batching, and a, good network this would have worked, this. Would have worked you know I would have fetched all the five thousand formulas in about two seconds and to. Give you an idea if Pierre had made five thousand separate requests without batching, that's what I've easily taken, me close to fifteen seconds. So. That's. Magic. To. Accomplish, this batching what we do is when a formula fires we, put it on a cue and that cue is flushed, based on either a time interval or the cue exceed a certain size. There's, a link here which leads to the patterns and practices, for. Using. Batching, which we work with Microsoft, along, with other patterns and practices, should, really check this out it's going to help that really, help at performance. They've. Been working really hard over, the past year, with Kaos team ever, since custom, functions were announced. To. Get support custom functions so that our clients can support, their workflows, on the go and all. This hard work has paid off in something being known that our our times would be eager to adopt we're. Really excited that. Custom. Function that Bloomberg custom functions would be available later this year for our clients, thank. You. All. Right. So. We've talked about our, what. Add-ins are we've talked about our api's and, we've talked about custom, functions. I'm, curious who, has a office. Or combat, and/or, a VST Oh at in an audience. Okay. About. Half of you, so, one of the things, Sahil demoed, was he started off on Windows. And he. Demo there the, Bloomberg's combatted, and then. He he. Went to Excel online where, the web ad and was, running and so. Essentially. What was, accomplished, here was what we call the com2 web atom bridge so. What, we will now. Allow you to do is, to. Essentially, have that on Windows, if your users are using your combating, they, can continue to use that combat and in the in their flow as. They would if they're, not using that combat. In well then they would get your web add in and then, on Excel online, excel. For mac that's, when they would get the new, web, add-in experience, and. With. The compatibility. Mode with custom functions, and XML UDF's, you can have co-authoring, sessions, where, you have a user on your, combat and working. Within. The same session with someone who's on Excel online and so. Here's, a quick, example from, one of our partners frontline solvers. Daniel's right here he's going to be here after. This session at, five o'clock talking, about their journey moving, from calm. To the, web, Adhan world so to encourage folks to stick around for that. So. The, way the combo web Adam bridge, works is you, essentially do add, some. Capability, at some declarations to your manifest XML so. There's two parts to this the first part is. You're. Specifying, your UI portion, so, where you're specifying your Prague ID for your existing combatted, and you. Just a type, is calm and so, this, is essentially. What we use to trigger hey should. We. Show the web add in UI. Or, not because, the last thing want is IT, deploys, a web. Adhan and someone. Gets two of, your ribbon, buttons and they get confused so, this will help mitigate some, of that. Likewise, if the as I said if the combat and isn't installed or IT, can uninstall, the comment and by setting group policy, to. Move folks over to the new model the. Second part of the, equivalent dead ends is you can specify.
Through This portal. As well as tools training and it gives you another channel to keep, in touch with us, so. Thank. You thank you, for being, up build thank you for continuing, our, journey we. Even. Have about three and a half minutes to spare so, we're. Here, told, the next session if not come to our add-ins, booth tomorrow. Yeah. And have a great build.