AppBankAsia Function as a Service (FaaS)
Service Function by calling through the RESTful API for use in creating applications / software without having to write the function itself to waste time, lose money, waste money. We have more than 1,000 functions covering all businesses, our function is working. On IBM Cloud Function, there is a Worldclass security level.
No downtime. Work fast with the RESTful API.
Our Functions (Partial)
1.Function CreateContact – Create contact information.
2.Function CreateAccount – Create a financial account
3.Function CreateContract – Create contract
4.Function CreateInstallment – Create installments that must be paid.
5.Function CalculateInterest – Calculate interest by contract type.
6.Function CalculatePenalty – Calculate the penalty amount for the contract type.
7.Function CalculateAdvanceClose – Calculate the total amount off the contract.
8.Function CalculateFee – Calculate fees
9.Function CalculateDownPayment – Calculate down payment.
10.Function CalculateIRR – Calculate Interet rate of return
11.Function CalculateDay – Calculate the number of days
12.Function CalculateAccruedInterest – Calculate the interest that must be recognized for the period.
13.Function ACCRINT – Accrued interest for securities that pay interest in installments sf
14.Function ACCRINTM – Returns accrued interest for securities that pay interest on the maturity date.
15.Function AMORDEGRC – Returns depreciation for each accounting period using depreciation coefficients.
16.Function AMORLINC – Returns depreciation for each accounting period.
17.Function COUPDAYBS – Returns the number of days from the start date of the interest payment period to the date of payment of the transaction.
18.Function COUPDAYS – Returns the number of days in the interest payment period with the payment date.
19.Function COUPDAYSNC – Returns the number of days from the date of payment to the next payment date.
20.Function COUPNCD – Returns the next interest payment date after the payment date.
21.Function COUPNUM – Returns the amount of interest payments between the payment date and the maturity date.
22.Function COUPPCD – Returns the interest payment date of the previous period before the payment date.
23.Function CUMIPMT – Returns the cumulative interest paid during the two periods.
24.Function CUMPRINC – Returns the cumulative principal amount paid to the loan during the two periods.
25.Function DB – Returns the depreciation of an asset for the specified period using the exact reduced balance method. (Fixed-declining Balance)
26.Function DDB – Returns the depreciation of an asset for the specified period using a double-balanced balance method. (Double-declining balance) or other methods that you specify
27.Function DISC – Returns the discount rate of the securities.
28.Function DOLLARDE – Convert dollar prices into fractional numbers to dollar prices in decimal numbers.
29.Function DOLLARFR – Convert dollar prices in decimal numbers to dollar prices in fractional numbers.
30.Function DURATION – Returns the period per year of securities that pay interest in installments.
31.Function EFFECT – Returns the actual interest rate per year.
32.Function FV – Returns the future value of the investment.
33.Function FVSCHEDULE – Returns the future value of the principal after applying a series of compound interest rates.
34.Function INTRATE – Returns the interest rate of securities that use all assets invested.
35.Function IPMT – Returns the interest that must be paid for the specified period for investment.
36.Function IRR – Returns the internal rate of return for the cash flow data set.
37.Function ISPMT – Calculate the interest paid during the specified investment period.
38.Function MDURATION – Returns the Macauley Modified Duration of the securities assuming the par value is 100 dollars.
39.Function MIRR – Returns the internal rate of return that positive and negative cash flows are paid at different rates.
40.Function NOMINAL – Returns the specified interest rate per year.
41.Function NPER – Returns the number of periods for an investment.
42.Function NPV – Returns the net present value of an investment based on a cash flow set as a period and discount rate.
43.Function ODDFPRICE – Returns the price per 100 dollar instrument value of the securities that are the first, short or longer than the standard
44.Function ODDFYIELD – Returns the return of the securities with the first period, shorter or longer than the standard.
45.Function ODDLPRICE – Returns the price per instrument value of 100 dollars of securities that have a final or shorter period than the standard.
46.Function ODDLYIELD – Returns the return of securities that have a short or longer period than the standard.
47.Function PDURATION – Returns the number of periods required for an investment to expand the capacity to the specified value.
48.Function PMT – Returns payment in installments for annuity.
49.Function PPMT – Returns the principal amount to be paid for the investment for the specified period.
50.Function PRICE – Returns the price per instrument value of 100 dollars of securities that pay interest in installments.
51.Function PRICEDISC – Returns the price per instrument value of 100 dollars of securities with discounted rates.
51.Function PRICEDISC – Returns the price per instrument value of 100 dollars of securities with discounted rates.
52.Function PRICEMAT – Returns the price per instrument value of 100 dollars of securities that pay interest on the maturity date.
53.Function NPV – Returns the current value of the investment.
54.Function RATE – Returns the interest rate per period of an annuity.
55.Function RECEIVED – Returns the amount received on the maturity date for all securities that use all assets invested.
56.Function RRI – Returns the equivalent interest rate for investment growth.
57.Function SLN – Returns the straight line depreciation of an asset for one period.
58.Function SYD – Returns the total depreciation for the year. (Sum-of-Years’ Digit) of assets for the specified period
59.Function TBILLEQ – Returns the bond-equivalent return of treasury bills.
60.Function TBILLPRICE – Returns the price per instrument value of $ 100 of treasury bills.
61.Function TBILLYIELD – Returns the return of the treasury bills.
62.Function VDB – Returns the depreciation of an asset for a specified period or part of a period using the Declining Balance method.
63.Function XIRR – Returns the internal rate of return for a schedule of cash flows that are not necessarily periodic.
64.Function XNPV – Returns the net present value for a certain period of cash flows that are not necessarily periodic.
65.Function YIELD – Returns the return of the securities that pay interest in installments.
66.Function YIELDDISC – Returns the annual return of securities with discounted rates such as treasury bills.
67.Function YIELDMAT – Returns the annual return of securities that pay interest on the maturity date.
68.Function CalculateTax – Returns the VAT amount.
69.Function CalculateWht – Returns the amount of tax paid.
70.Function CalculatePayrollWht – Returning personal income tax monthly
71.Function CalculatePayrollWorkingDay – Returns the number of work days.
72.Function CalculatePayrollOTHrs – Returns the number of working hours.
73.Function CalculatePayrollOTAmt – send secret, overtime amount
74.Function CalculatePayrollSpecificAmt – Returns the amount of other values specified in the parameter
75.Function TranslateText – Returns the translation from the source language to the specified destination language.
76.Function GetCurrency – Returns the exchange rate according to the specified date and the specified currency.
77.Function GetGoldPrice – Returns the gold price according to the specified date.
78.Function CalculateRegisterAmt – Returns the amount of car tax that must be paid.
79.Function CalculateInsuranceAmt – Returns the amount of insurance that must be paid.
80.Function ConvertCurrency – Returns the amount converted to other specified rates.
81.Function ConvertTextToSpeech – Send the secret file as the audio from Convert from Text to Voice
82.Function ConvertSpeechToText – Returns the text from the Convert Voice File to Text.
83.Function ConvertImageToText – Return the text from Convert image file to Text.
84.Function CalculateRentAmount – Returns rent
85.Function CalculateCapacity – Returns the calculated capacity.
86.Function CalculateFutureValue – The value of future money under the time period and the rate of return set.
87.Function GetTitleName – Returns the name prefix. From the full name submitted
88.Function GetFirstname – Send the name back from the full name sent.
89.Function GetLastName – Send the last name back From the full name submitted
90.Function GetProvinceFromZipCode – Returns the province name. From the postal code sent
91.Function GetDistrictFromZipCode – Returns the name of the district. From the postal code sent
92.Function GetSubDistrictFromZipCode – Returns the district name. From the postal code sent
93.Function GetZipCodeFromAddressLine – Returns the postal code from the address sent to the Address line.
94.Function GetCountryFromAddressLine – Return the country name from the address sent to Address line.
95.Function GetProvinceFromAddressLine – Returns the province name from the address that is sent to the Address line.
96.Function GetStateFromAddressLine – Returns the state name from the address that is sent to the Address line.
97.Function GetDistrictFromAddressLine – Returns the name of the district from the address that is sent to the Address line.
98.Function GetRoadFromAddressLine – Returns the street name from the address that is sent to the Address line.
99.Function GetHomeNoFromAddressLine – Send home the number from the address that is sent to the Address line.
100.Function GetVillageNameFromAddressLine – Returns the name of the home from the address sent to the address line.
101.Function GetBuildingNameFromAddresLine – Returns the building name from the address that is sent to the Address line.
102.Function ASC – change the English alphabet or full-width Katakana (double byte) within the character string in half-width characters (single bytes)
103.Function BAHTTEXT – Convert numbers to text Using the currency format ß (baht)
104.Function CHAR – Returns the character specified by the code number.
105.Function CLEAN – Remove all unprinted characters from the message.
106.Function CODE – Returns the numeric code for the first character in the text string.
107.Function CONCAT – Combine text from multiple ranges and / or strings, but no separators or IgnoreEmpty arguments.
108.Function CONCATENATE – Combines multiple messages List into one message list
DBCS 109.Function – change the English alphabet or Katakana to half-width (single-byte) within the character string in full-width characters (double bytes)
110.Function DOLLAR – Convert numbers to text. By using the currency mark format $ (dollar)
111.Function EXACT – Check if the two text values are the same or not.
112.Function FIND – Search for one text value within another text value. (Exactly as in the case of capitalization)
113.Function FIXED – Format numbers as text with the exact number of decimal places.
114.Function LEFT – Returns the leftmost character from the text value.
115.Function LEN – Returns the number of characters in a text string.
116.Function LOWER – Convert text to lowercase.
117.Function MID – Returns the specified number of characters from the text string starting from the location you specified.
118.Function NUMBERVALUE – Convert text into numbers in a manner independent of the language system.
119.Function PHONETIC – Separate the phonetic characters (furigana) from the text string.
120.Function PROPER – Change the first letter in each word of the text value to uppercase.
121.Function REPLACE – Replace characters within the text.
122.Function REPT – Repeat the message according to the specified number of times.
123.Function RIGHT – Returns the rightmost character from the text value.
124.Function SEARCH – Search for one text value within another text value. (Not case-sensitive)
125.Function SUBSTITUTE – Replace the original text with new text in the text string.
T 126.Function – Converts the argument to text.
127.Function TEXT – format numbers and convert numbers to text
128.Function TEXTJOIN – Combine text from multiple ranges and / or strings and have delimiters that you specify between each value of the text to be included. If the separator is an empty text string. This function will link the various ranges. Together effectively
129.Function TRIM – Remove spaces from messages
130.Function UNICHAR – Returns the Unicode character referenced by the specified numeric value.
131.Function UNICODE – Returns the number (code point) corresponding to the first character of the message.
132.Function UPPER – convert text to uppercase
VALUE 133.Function – Converts text arguments into numbers.
134.Function DATE – Returns the serial number of a specific date.
135.Function DATEDIF – Calculate the number of days, months or years between two dates. This function is useful in the formula that you want to calculate age.
136.Function DATEVALUE – converts dates in text format into sequential numbers
Day 137.Function – Convert the serial number into days in months.
DAYS 138.Function – Returns the number of days between the two dates.
139.Function DAYS360 – Calculate the number of days between two dates based on 360 days.
140.Function EDATE – Returns the serial number of the date as the number of months specified before or after the start date.
141.Function EOMONTH – Returns the serial number of the last day of the month before or after the specified number of months.
142.Function HOUR – Convert ordinal numbers into hours
143.Function ISOWEEKNUM – Returns the number of ISO week numbers for the specified date.
144.Function MINUTE – Convert ordinal numbers into minutes.
MONTH 145.Function – Convert serial numbers into months.
146.Function NETWORKDAYS – Returns the total number of working days between two days.
147.Function NETWORKDAYSINTL – Returns the numeric value of the total number of working days between two dates using the parameters to specify the date and number of days that are weekend.
148.Function NOW – Returns the serial number of the current date and time.
149.Function SECOND – Convert ordinal numbers in seconds.
150.Function TIME – Returns the serial number of a specific time.
TIMEVALUE 151.Function – Converts the time in text format into sequential numbers.
152.Function TODAY – Returns the serial number of the current date.
153.Function WEEKDAY – Convert the serial number into days of the week.
154.Function WEEKNUM – Converts the ordinal number into numbers that represent the week position in one year.
155.Function WORKDAY – Returns the serial number of the date before or after the specified number of working days.
156.Function WORKDAYINTL – Returns the serial number of the date before or after the specified number of working days using the parameters to specify the date and number of days that are weekend.
157.Function YEAR – Year number conversion
158.Function YEARFRAC – Returns the fraction number of the year that represents the total number of days between the start date (start_date) and the end date (end_date)
159.Function GetInterestRate – Returns interest rates such as MOR, MRR, MLR, .. according to the specified bank and according to the date specified. Can support sending secret interest in Syndicate Rate
160.Function CheckHoliday – Returns whether the specified date is a holiday or special holiday.
161.Function GetAge – Returns the age, year, month, day from the date that was submitted, such as age, job, age, person or other age.
162.Function CreateRunningNo – Create a new Running Profile
163.Function GetCurrentRunningNo – Returns the current No.
164.Function GetNewRunningNo – Returns the new running No. added.
165.Function CreateReceipt – Create a receipt and send it back as a PDF file.
166.Function CreateTaxInvoice – Create invoices with documents and send back in PDF file format.
167.Function CreateWitholdingTax – Create withholding certificate and send it back in PDF file format.
168.Function CreateGLVoucher – Create an account entry according to the specified Posting Key such as Create Purchase Voucher, Sale Voucher.
169.Function SendSMS – Send SMS to the desired number worldwide.
170.Function SendMMS – Send MMS to the desired number worldwide.
171.Function GenerateQRCode – Create QRCode file
172.Function GenerateBarCode – Create a Bar Code file
173.Function GenerateLabelAddress – Create a label address to send mail.
174.Function GetListCompanyName – Returns the Company name as specified by the condition returned as JSON.
175.Function GetListCompanyAddress – Returns the Company address for printing to the envelope.
www.appbankasia.com | www.softoneasia.com
Rent Applications & Products Live Demo Contact Sale Need Call Back