Excel Macro
- or -
Post a project like this2203
$50
- Posted:
- Proposals: 2
- Remote
- #1950530
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
- Create a Macro that will connect to a REST API, it should be compatible to MAC OSX and WINDOWS OS.
- When logging in a username and password textbox should pop-up when you open the excel file.
Sample API output:
{
"results": [
{
"status": "1",
"market_cap_formatted_value": "903,275.8",
"ticker": "AAPL",
"stock_exchange": "NasdaqGS",
"vc_rating": "IG4+",
"sub_industry": "Technology Hardware, Storage and Peripherals",
"revenue_formatted_value": "239,176.0",
"fy_end": "2017-09-30 00:00:00",
"sic_sub_industry": "Electronic and other electric equipment",
"va_formatted_value": "0.0",
"currency": "USD",
"peer_group": [
"HPQ",
"HPE",
"WDC",
"NTAP",
"KOSE:A005930",
"CNTF",
"SWX:LOGN",
"TSEC:2353",
"TSEC:2357"
],
"trading_currency": "USD",
"stock_price": 178.02,
"peers": [
"HPQ",
"HPE",
"WDC",
"NTAP",
"KOSE:A005930",
"IQ266017",
"CNTF",
"SWX:LOGN",
"TSEC:2353",
"TSEC:2357",
"CSCO",
"CTRL",
"FIT",
"ARRS",
"ARW"
],
"ebitda_formatted_value": "0.0",
"company_website": "www.apple.com",
"industry": "Technology Hardware and Equipment",
"ticker_alias": "AAPL:USA",
"market": "United States",
"traditional_pb_formatted_value": "0.0",
"un_code": "USA",
"sic_sector": "Manufacturing",
"date_of_analysis": "03/17/2018",
"trading_market_cap": 903275.79426,
"company_address": "1 Infinite Loop, Cupertino, California, 95014, United States",
"revenue": 239176.0,
"name": "Apple Inc.",
"market_cap": 903275.79426,
"traditional_pe": 0.0,
"traditional_pe_formatted_value": "0.0",
"sector": "Information Technology",
"ve": 0.0,
"trading_stock_price": 178.02,
"vr_mark": null,
"ebitda": 0.0,
"traditional_pb": 0.0,
"trading_revenue": 239176.0,
"icds": 30,
"id": "58be710b484721d850b42aa4",
"company_description": "Apple Inc. designs, manufactures, and markets mobile communication and media devices, and personal computers to consumers, and small and mid-sized businesses; and education, enterprise, and government customers worldwide. The company also sells related software, services, accessories, networking solutions, and third-party digital content and applications. It offers iPhone, a line of smartphones; iPad, a line of multi-purpose tablets; and Mac, a line of desktop and portable personal computers, as well as operating systems comprising iOS, macOS, watchOS, and tvOS. The company also provides iWork, an integrated productivity suite that helps users create, present, and publish documents, presentations, and spreadsheets; and other application software, such as Final Cut Pro, Logic Pro X, and FileMaker Pro. In addition, it offers Apple TV that connects to consumers’ TV and enables them to access digital content directly for streaming high definition video, playing music and games, and viewing photos; Apple Watch, a personal electronic device; and iPod touch, a flash memory-based digital music and media player. Further, the company sells Apple-branded and third-party accessories, such as headphones, displays, storage devices, Beats products, and other connectivity and computing products and supplies. Additionally, it offers iCloud, a cloud service that stores music, photos, contacts, calendars, mail, documents, and others; AppleCare, which offers support options for its customers; and Apple Pay, a cashless payment service. The company sells and delivers digital content and applications through the iTunes Store, App Store, Mac App Store, TV App Store, iBooks Store, and Apple Music. It also sells its products through its retail and online stores, and direct sales force, as well as through third-party cellular network carriers, wholesalers, retailers, and value-added resellers. Apple Inc. was founded in 1977 and is headquartered in Cupertino, California.",
"va": 0.0,
"ve_formatted_value": "0.0",
"dots": 0
},
}
- Create a button that will get all the companies from the API
The sample API URL will be given once the job was expected.
- When logging in a username and password textbox should pop-up when you open the excel file.
Sample API output:
{
"results": [
{
"status": "1",
"market_cap_formatted_value": "903,275.8",
"ticker": "AAPL",
"stock_exchange": "NasdaqGS",
"vc_rating": "IG4+",
"sub_industry": "Technology Hardware, Storage and Peripherals",
"revenue_formatted_value": "239,176.0",
"fy_end": "2017-09-30 00:00:00",
"sic_sub_industry": "Electronic and other electric equipment",
"va_formatted_value": "0.0",
"currency": "USD",
"peer_group": [
"HPQ",
"HPE",
"WDC",
"NTAP",
"KOSE:A005930",
"CNTF",
"SWX:LOGN",
"TSEC:2353",
"TSEC:2357"
],
"trading_currency": "USD",
"stock_price": 178.02,
"peers": [
"HPQ",
"HPE",
"WDC",
"NTAP",
"KOSE:A005930",
"IQ266017",
"CNTF",
"SWX:LOGN",
"TSEC:2353",
"TSEC:2357",
"CSCO",
"CTRL",
"FIT",
"ARRS",
"ARW"
],
"ebitda_formatted_value": "0.0",
"company_website": "www.apple.com",
"industry": "Technology Hardware and Equipment",
"ticker_alias": "AAPL:USA",
"market": "United States",
"traditional_pb_formatted_value": "0.0",
"un_code": "USA",
"sic_sector": "Manufacturing",
"date_of_analysis": "03/17/2018",
"trading_market_cap": 903275.79426,
"company_address": "1 Infinite Loop, Cupertino, California, 95014, United States",
"revenue": 239176.0,
"name": "Apple Inc.",
"market_cap": 903275.79426,
"traditional_pe": 0.0,
"traditional_pe_formatted_value": "0.0",
"sector": "Information Technology",
"ve": 0.0,
"trading_stock_price": 178.02,
"vr_mark": null,
"ebitda": 0.0,
"traditional_pb": 0.0,
"trading_revenue": 239176.0,
"icds": 30,
"id": "58be710b484721d850b42aa4",
"company_description": "Apple Inc. designs, manufactures, and markets mobile communication and media devices, and personal computers to consumers, and small and mid-sized businesses; and education, enterprise, and government customers worldwide. The company also sells related software, services, accessories, networking solutions, and third-party digital content and applications. It offers iPhone, a line of smartphones; iPad, a line of multi-purpose tablets; and Mac, a line of desktop and portable personal computers, as well as operating systems comprising iOS, macOS, watchOS, and tvOS. The company also provides iWork, an integrated productivity suite that helps users create, present, and publish documents, presentations, and spreadsheets; and other application software, such as Final Cut Pro, Logic Pro X, and FileMaker Pro. In addition, it offers Apple TV that connects to consumers’ TV and enables them to access digital content directly for streaming high definition video, playing music and games, and viewing photos; Apple Watch, a personal electronic device; and iPod touch, a flash memory-based digital music and media player. Further, the company sells Apple-branded and third-party accessories, such as headphones, displays, storage devices, Beats products, and other connectivity and computing products and supplies. Additionally, it offers iCloud, a cloud service that stores music, photos, contacts, calendars, mail, documents, and others; AppleCare, which offers support options for its customers; and Apple Pay, a cashless payment service. The company sells and delivers digital content and applications through the iTunes Store, App Store, Mac App Store, TV App Store, iBooks Store, and Apple Music. It also sells its products through its retail and online stores, and direct sales force, as well as through third-party cellular network carriers, wholesalers, retailers, and value-added resellers. Apple Inc. was founded in 1977 and is headquartered in Cupertino, California.",
"va": 0.0,
"ve_formatted_value": "0.0",
"dots": 0
},
}
- Create a button that will get all the companies from the API
The sample API URL will be given once the job was expected.
Ally B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
27 Mar 2018
Philippines
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies