Simple excel macro which use Bittrex exchanges API. Base code in here: [login to view URL] you will find everything what you need in there. In the app we need few parameters: -API Key - StopLoss % - CurrencyPair - Price Check Interval in Seconds Macro need to do Trailing Stop-Loss which is for example: For example, a user buys 1
Create pdf template. Macro/tool buttons on pdf to edit: 1) draw with different "pens". 2) create coloured polygons calculating and displaying area. 3) button to clear. 4) button to save as. 5) button to export all entered fields to excel/csv. Already have a template made up but needs re-doing with correct formatting and functionality.
I have hard copies of business cards that I need put into an excel spreadsheet. Just copy all information into a sheet under standard headings (name, phone #s, address, etc). About 60 cards to start, and it could turn into an ongoing activity.
...project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i 3. scaled score (column Z) from the "SR sh...
We are looking for a number of people to test client experience in about 14 banks. This is a part-time project and each participant has a goal to test the digital client experience for 5-7 (enterprises, following a precise methodology. The participants need to - Realise 3 journeys (on line or very rarely in the agencies) - Test the communication channels (chat, calls, social media) - Test the ava...
Réalisation d'une macro qui 1- enregistre une feuille courante avec un nom structuré et un path 2- Effacer les zones saisies 3 - mettre à jour le n° de pièce suivant 4- Enregistrer le classeur
I am looking a suggestion for the ...suggestion for the best approach to model - 12 questioner (Ordinal - score of 0 to 4 – its the level of implementation intervention) and continuous outcome. Requires SAS STATS/ SAS Macro knowledge as well– May be one hour consultation. I already have something in place but just want get second opinion. Thanks
...We have a small scraping macro written in VBA which takes [login to view URL] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [login to view URL]) However there are some minor issues with this macro. One of them is scraping data when betting market was closed
...someone to scrap data automatically from the given financial websites using EXCEL Macro. Then apply some formulas to calculate some desired output. The macro should be fast to bring the output. Use the graphs Below are some websites for your reference [login to view URL] [login to view URL] [login to view URL]
...own a set of blogs about Chinese technology where everyday I receive dozens of coupons Data will be provided by: - internal sources - newsletters - other blogs Data with link, coupon code, expiry and description has to be accurately filled in the google spreadsheet I will provide most of the sources, any proactive activity finding new sources will be
I need to import about 7000 lines of data into a larger spreadsheet. I have 1 sheet of NEW data and 1 sheet larger that has OLD data. I need to have the NEW data imported into the OLD spreadsheet by finding matches and importing the new data where it locates the matches. For example: NEW DATA A1 B1 C1 904 23 77 OLD SHEET CONTAINS 904 N...
Looking for a writer who knows his macro and micro economic theory. I need a 15-20 page analysis on the following topics including references to theory and literature: 1) Lack of access to financial institutions for the poor sector of the population in Africa (how does this affect the economy and how they transact with each other). How does this affect
we have one Excel Macro in 2003 need to upgrade macro ,
I have a Python script which basically runs an Excel macro, but it is giving me a Runtime Error 1004. the macro basically refreshes Bloomberg formulas in the sheet. The macro runs fine within Excel but gives the above error when calling from Python.
...work, in an Excel spreadsheet. Create a macro in Google sheets. Will have main workbook with all jobs. Jobs assigned to employees and each employee to have their own sheet that they can edit, which in turn will also update the data in the main workbook. When new jobs are assigned I need would like a separate sheet that I can add the data. Then run a
...analysis tools FX calculator calculating whole and broken dates forex cross rates Fixed income price discovery Financial news, real time market data and analysis, including charting tools and excel capabilities Regulatory intelligence (FICA portal shared by South African Banks) Industry-specific news, research, prices, events, and performance
I need a framework, software, guidance or similar to ensure that no macros I install include virus. Also need a way to check if a existing file contain a macro virus or other infection.
I have a spreadsheet (Google Sheets)that contains a list of all my real estate sales addresses over the last couple of years. I need to format this spreadsheet into something usable. Currently each sale is split up in the spreadsheet in a predictable way (5 line text blocks all in the first column) and I need someone to pragmatically or manually separate
Macro to Manipulate Data in a MS-Word Table This is a request for a macro to run on Microsoft Word and to make some changes to a table and to the cells within the table. You will need experience in writing MS-Word macros and table management. PowerPoint can export a Word document which contains images of the PPT slides in a table. The table
...unique insurance company name occupies a single row. I had a colleague who created a quick macro that scans through records like this and builds a unique table. I lost the macro. Someone who is familiar with Excel can do this in 5 minutes. Attached is the Excel file. The first worksheet has the raw database. The second worksheet has the desired output
I have partially built an excel spreadsheet but require help with the complicated parts I cannot do myself. The spreadsheet incorporates data from several worksheets as well as online sources and will require the use of complex Excel functions.
hi, i need someone to fill contents from website to spreadsheet,final result should be [login to view URL] and excel. details will provided to shortlist freelancer. i need this urgent and to get mostly by today evening, if possible to deliver at today evening only place your proposals,along with your pay for 12k entries as i have so many things to do.
This is the Macro Im having trouble with. It adds the name and address and a job number to the file name. I am getting a save failed msg and a Run-time error 1004 Sub SvFile() [login to view URL] Filename:= _ "Z:Black Forest Hardwood FloorsBLACK FOREST HARDWOODS" & Range("FORMULAS!b26") & " Contracts" & Range("FORMULAS!A62&q...
iattached is 1 of 15 spreadsheets for 15 different builder subdivisions. i need to be able to change a few fields that contain % formulas so i can change for each subdivision. i want only certain fields to be editable for user. want it to look much nice than the lined spread sheet with colored fonts etc...
...for a short period of time to assist to build and implement a user friendly form for our employees. the application should be intuitive and user friendly. users will key in data and the form should be able to churn out quotations, invoices and a P&L budget sheet for projects with our company's letter head, etc. office managers are required to access
Very simple project. I have 2 Excel Spreadheets to convert into a nicer format following a specific layout. Look at the tab "Raw Data" and the tab " formatted". A basic example is shown in formatted tab. Using the data from Raw Data organize it in the same layout as the formatted tab. PLU is the UPC/PRODUCT ID copy the same. Name is th...
I have an excel macro that takes data from an excel workbook, and generates multiple outlook email messages from the data in the excel workbook. This code works right now in windows excel, but not with mac excel. I need to make this code compatible with mac excel.
... I'm trying to enter data I fill in from Sheet 1, in Workbook1, into multiple sheets, workbooks, other xlsx files, etc. I'm totally open to suggestion on how to improve my process to make the process itself go more smoothly. As is, I'm trying to do it now, but it's taking forever. A few things to consider: 1. The data entered by me in the source
I have 2 spreadsheets in excel currently. One is a larger sheet with multiple tabs, this is my worksheet. The other is just a page of notes to changes I want to make to the spreadsheet. Now what I'd like done is difficult to explain in this paragraph, so I'd like someone who is in the western side of Canada/US that is open to phone communication
i have xls wanted it open in excel file with groups and with sub totals and with design
I need you to develop some macro for me. I would like this macro to be developed with 3 logics We have a pick up trip sheet for passengers The drop sheet prepared will be dynamic in nature but will consist same passengers that we picked up We need to apply logic for drop saying which cab did pick them by using pick sheet. And a bit more logics there
Create a qualified and targeted list of 5000 contacts with name and email and company. Only companies that would use and need a chatbot AI technology.
...convert data contained in array into tabular format. 1st row is the header row and in the output date column names would become the row values in a column called Date and the integer values would come under a column called Hours. Integer value would move to row corresponding to date. See Raw to Clean tabs in file attached. Desire VBA macro solution