I am looking for the exact VBA code that will allow me to do the following in Excel: I want to have a custom function in Excel that references two other cells, one with the ticker of a stock eg AAPL and one with a date. The function should then pull the closing price of the stock on that date. The API I want to use for the code is AlphaVantage, they
...coding for data management projects. The data management projects involve manipulating and organizing files with the use of R studio. The project involves creating detailed excel databases with the use of content found online on the websites of Investment Banks. I need detailed spreadsheets with color coded data. I also need help with the transcription
...ugly report that when pasted into a "converter is supposed to produced a clean version with raw data that can be used to create further analysis with Pivots or graphs. The VBA in the converter is giving me a runtime error 91 Object variable with block variable not set and I do not know how to fix it. When i hit debug - I get this " intColRoomType
Hello, I have a list of images URLs in an excel file, I would like to have a macro file that I can use often to download the images and then in next column put his path that the image has been download, then in the next cell, the path of the image renamed. Thanks to contact me to discuss about it
... I need someone who can execute queries, from within Excel VBA such as the following: [ログインしてURLを表示],THB,HKD,GBP,EUR&base=USD To retrieve currency data and then paste it into excel cells. The HTTP query from within VBA is quite simple to build. Example: str = "https://api
... I need someone who can execute queries, from within Excel VBA such as the following: [ログインしてURLを表示],THB,HKD,GBP,EUR&base=USD To retrieve currency data and then paste it into excel cells. The HTTP query from within VBA is quite simple to build. Example: str = "https://api
Background: Excel spreadsheet has two workbooks: One for data entry, one for controlling entered data. Entry to a range of cells (A1:A10) on data entry sheet is LOV controlled by a table on the control sheet. The table controlling the LOV is exhaustive and the user cannot enter values outside the range. A second range of cells (B1:B10) on data entry
...statement, - Tabulating rent rolls from monthly reports - Creating financial models for real estate development deals - Analyzing debt instruments, Excel data manipulation and formatting, including using VBA to automate such tasks. - Maintaining historical records by filing documents into Google drive - Preparing financial reports by collecting
Have to post orders to an web site using Access VBA. Need help. Email address is PVEC12450@aol.com. Please address to David D.
Please bid if you are excel expert with excellent knowledge with ebay api from website only from macro. please bid. Thanks
Currently placing market orders through IB TWS BasketTrader with separate csv files for 6 segregated client accounts. Need to integrate the task to one Excel interface/worksheet. Column A contains the list of desired symbols separated by short and long. All intraday market orders with specific entry/exit times per account. US regular trading hours only
Super urgent within 30 mins I need a vba macro to run on Mac to access a web page via Safari and download csv file and other items
The macro started to get interrupted during execution. May be because of newer Excel version. Shall be very easy if you know Excel VBA well.
This project is to build a VBA macro to cycle through a drop down list of dates contained on an open internet explorer page and print them to pdf via pdf creator. For the file name I would like to be able to type a 6 digit number at the beginning of each run to be used with a date stamp added from the webpage (I.e. the pages date that is currently being
...appropriate error messages (e.g. through MsgBox); • display the final result (e.g. through MsgBox). • You are encouraged to add functionality such as allowing the program to accept input dates in different ways. You might also add features to ask whether the user wants to enter other birthdates (might be via a loop until the user says no); whether the
I have a project that i needs to be done on priority. please bid if you are expert only.
I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code) It mainly just moves stuff around I have recreated the spreadsheet in google sheets [ログインしてURLを表示] but I can’t recreate the macro as I don’t know google apps script. Is this
...people for multiple Skills. We need people for long term projects. We have projects related to different skills sets. 1. Data Entry, Data processing, Excel Macros, Excel VBA. 2. Typing 3. Word. 4. Excel So Please welcome all freelancers and Bid on the project. We will review the profile starting monday and provide the projects related to skills.
I need website scraped with Python and I need button in Excel that will start the script to pull the data .
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Develop VBA analyzer that can access stock pricing information from the Internet (e.g., [ログインしてURLを表示]) and perform basic analysis on them. To be completed in 4 days.
scan files in a selectable folder, identify all images in the file and dump the image and all known attributes into an excel spreadsheet.
I need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
I need someone to Fill out a web form through VBA excel. [ログインしてURLを表示] It's an urgent project for today
i have a project and need some editing for macro of the vba "excel"
i have a project and need some editing for macro of the vba "excel"
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
I need someone who is EXTREMELY good not only at VLOOKUPs, but also being able to analyze and backwards engineer VBA code
I m looking for a app developer who have complete knowledge on vba with ui interface and Google finance api
Hi Milan S., You did some work for me before. I am wondering if you could complete another small VBA project for me?
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Change country value by code value in 2 sheets and sure thanks to a 3th sheet with the matching between countries & codes. I put 2 sheets with the results example that i want. Easy easy ;)
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
Hi, need only freelancer with outlook appointement experience! pls see instruction file . need sub which get date and duration and set the appoitment as when you execute the macro need it today Thanks
...I need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned.
Necesito un código en VBA que extraiga la data que está en la siguiente web: [ログインしてURLを表示]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
I have a simple algorithm I need to code in VBA. It's about cross dock door assignment. It assigning arrival and departing trucks to doors at a warehouse.
I need Excel VBA/Macro expert to help with automating some process in Excel.
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[ログインしてURLを表示]" erfolgen. In dieser sind bereits Module und Code zur vorgesehenen
create a VBA function that plays 100 rounds of the game friend or foe
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
